+ Reply to Thread
Results 1 to 4 of 4

Moving a workbook with external links

  1. #1
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

    Moving a workbook with external links

    Hi,

    I want to move the workbook I have created to a different folder on the same drive.

    The workbook is pretty big and has loads of links to other workbooks. If I move it will all of these links fail and if so will I have to manually reset them all?

    I guess I am asking if there is specific method of moving workbooks which will automatically change the links to the cope with the new location?

    Any help much appreciated.

    Thanks
    Last edited by Gooford; 11-23-2009 at 09:00 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Moving a workbook with external links

    If you have all the linked files open and then SaveAs (new location) for the file you wish to move, the links will go to the new location. You can then delete the copy of the file in the old location.

    You need to save all the other files before closing them to retain the new links.
    Last edited by Huron; 11-23-2009 at 08:29 AM.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Moving a workbook with external links

    @ Huron: BRILLIANT!!

  4. #4
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

    Re: Moving a workbook with external links

    Thanks very much - cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1