+ Reply to Thread
Results 1 to 6 of 6

Links update from multiple files

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Links update from multiple files

    Dear Friends,

    PFA the working files.
    In "summary 1819" file, there are multiple links of many file which are saved in different folders.

    Is there any macro which updates all the links at a time?

    Note:
    Actually, "summary file" is linked to approx. 300 files and the files are saved in 300 different folders.
    Updating all the links manually is very time consuming and chances of error are there.

    Please assist.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: Links update from multiple files

    Hello Friends,

    Any luck ?

    Please help.

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: Links update from multiple files

    any luck ?

  4. #4
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: Links update from multiple files

    Dear friends,

    PFA the working files.

    Open Summery 1718.xlsm in folder Links update 1718. Currently files are linked to folder "Link update 1718".

    Open Summery 1819.xlsm in folder Links update 1819. Currently files are linked to folder "Link update 1718".
    Is there any macro which will updates all the links in file to folders "Link update 1819" in one go ?

    Note:
    Actually, my "summary file" is linked to approx. 300 files and the files are saved in 300 different folders.
    Updating all the links manually is very time consuming and chances of error are there.

    Please assist.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: Links update from multiple files

    Dear Friends,
    Any luck ????

  6. #6
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: Links update from multiple files

    Dear Friends,
    Any luck ????

    I need to do the roll over for the new year...

    Please assist since the data is huge.

+ 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. [SOLVED] How to suppress the display of 'Update' message for files with external links
    By billj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2016, 06:02 AM
  2. Macro to open, update links, save then close all files in sub folders
    By msdelaney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2015, 05:48 PM
  3. Replies: 2
    Last Post: 12-01-2015, 01:08 AM
  4. Replies: 1
    Last Post: 01-06-2012, 12:31 PM
  5. Help needed to update links from unopened files
    By rkanchan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2011, 11:46 AM
  6. Update links to files Manually in Excel 2007
    By simjambra in forum Excel General
    Replies: 0
    Last Post: 04-22-2010, 10:39 AM
  7. [SOLVED] Links won't update unless files are actually opened
    By BretJacobs in forum Excel General
    Replies: 9
    Last Post: 08-04-2006, 08:55 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