+ Reply to Thread
Results 1 to 4 of 4

Links are not updated

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Romania
    MS-Off Ver
    Office 2013
    Posts
    2

    Links are not updated

    Hi to all,

    I have an excel file A that contains links to another excel file B. These 2 files are in, let's say, a folder called "Jan 2017".

    After copying both files in a new folder (called "Feb 2017") the links (from file A) to file B remain in the folder "Jan 2017".

    Is there a way that the links to be automatically updated to the files from a new folder?

    Many thanks.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Links are not updated

    Can I assume you are using the Windows/OS copy and paste command? The way I usually do this sort of thing, rather than using copy/paste file commands in Windows Explorer is to:
    1) Open both files in Excel.
    2) Save As -- into new location.

    I have found that, when I use the saveas command on file B, the links in file A will automatically follow the new file name/location, as long as file A is open when I execute the save as command.

    The other command I have found useful is the Edit Links command (Data tab). From this dialog, I can change the path (and file name) of links.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-25-2017
    Location
    Romania
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Links are not updated

    Hi,

    Yes, I use copy/paste commands to copy the files.

    Those 2 options described by you works fine but if you have more than 20 file (each file linked to another 30 files and placed in a different folder) then it is too time consuming both of these options.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Links are not updated

    I have also used Find/Replace command. I think for this to work, files B (the source files File A is linked to) need to be closed so that the formula text strings will display the full path name. Find: Jan 2017 Replace with: Feb 2017 (or other suitable text strings that will reliably perform the find/replace. Make sure it is looking in formulas and execute the Find/Replace across the workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 12-27-2014, 11:43 AM
  2. [SOLVED] Workbook contains links that cannot be updated
    By Cynthia Moore in forum Excel General
    Replies: 2
    Last Post: 12-26-2014, 01:51 PM
  3. Links cannot be updated
    By jacob@thepenpoint in forum Excel General
    Replies: 1
    Last Post: 11-28-2011, 09:45 AM
  4. Updated Links dont remember they're updated
    By carsto in forum Excel General
    Replies: 0
    Last Post: 05-05-2009, 11:26 AM
  5. Links can not be updated...
    By JDP1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2007, 01:34 PM
  6. [SOLVED] links are not updated
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2006, 08:50 PM
  7. [SOLVED] Links not showing updated value
    By Wanson in forum Excel General
    Replies: 2
    Last Post: 12-08-2005, 11:10 AM

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