+ Reply to Thread
Results 1 to 5 of 5

Links update from multiple files

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

    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
    158

    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
    158

    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
    158

    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
    158

    Re: Links update from multiple files

    Dear Friends,
    Any luck ????

+ 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