Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Off-Workbook references (2000/3)

    I have a workbook (source), which has references to cells in a second (target), workbook. Both workbooks are being developed on a stand alone machine. On completion, the files will be moved to a different environment where the source workbook will reside in a machine's hard drive, and the target workbook will reside on a server.
    I am concerned that when the files are moved to the new environment, the links will no longer be valid, and am unable to find a technique which is not labour intensive for establishing links to the workbook in the revised path.

    Any guidance will be greatly appreciated.
    Regards
    Don

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Off-Workbook references (2000/3)

    You could move files to PC which will accommodate the Source workbook, and from that PC open both files and do a SaveAs of the target workbook to the server.

    The links on the Source file should be updated with the location of the newer version of the Target workbook.

    Andrew C

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Off-Workbook references (2000/3)

    Thanks Andrew
    Is there any significance in the order of opening (Target or Source first)?
    Regards
    Don

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Off-Workbook references (2000/3)

    When you develope the two workbooks, make sure that they are both in the same directory on the machine they are developed on. Then when you move them to the new PC, place both of the files into the same directory on that machine. Then open both workbooks and use SaveAs on the target workbook and save the workbook to the directory on the server (you will have to have write access to the server directory for this step). After saving the target workbook, the links in the source workbook should have been updated to the files new location on the server. Finally, save the source workbook to save the updated links.
    Legare Coleman

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Off-Workbook references (2000/3)

    Thank you Legare
    Comprehensive, as always.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •