+ Reply to Thread
Results 1 to 2 of 2

links to multiple files : update links to 1 file at a time does not seem to work

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    1

    links to multiple files : update links to 1 file at a time does not seem to work

    Dear Readers,

    I have a huge excel file with over a thousand links to 30 other excel files.
    When I want to replace one of the 30 files by another one (via data > edit links> , it takes a long time, and all of the files seem to be processed and get the "OK" status

    In detail:
    When I want to change the source of one off the 30 files I do the next steps

    1. open the new file that I want to link to
    2. go to the window with the huge excel file
    3. data > edit links
    4. select the file that I want to replace by a newer version
    5. use the button " change source"

    After 2 minutes of waiting all the files get the status OK in the " edit links" window.

    My questions:
    1. It seems that the links to all of the 30 files were processed / updated. Why, I only selected one to change the source.
    2. Since I do not want to wait those 2 minutes every time I want to change the links to just 1 of the source files: What can I do to prevent this?


    Any help or tip is more than welcome.

    Hansiepansie

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: links to multiple files : update links to 1 file at a time does not seem to work

    Welcome to the Forum.

    I have used this Edit Links feature a lot at my office. However, it used to never take me 2 mins to change source, unless the file i am linking to was saved on a share drive. Is this your case?

    Also, it can take considerable time if you have opened the file in a different instance of excel. In the sense, the container window (the grey window that you see once you close all the excel files using the lower x button at the top of the screen) should contain both your big file as well as the file to link it to. You should not open the file using Start -> Programs-> Microsoft Excel 2007, etc.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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