+ Reply to Thread
Results 1 to 3 of 3

Moving multiple linked workbooks

  1. #1
    Registered User
    Join Date
    03-07-2007
    Posts
    74

    Moving multiple linked workbooks

    Hello,

    I need to move multiple linked workbooks that pull from multiple different folders to a different server.

    I am hoping if I keep the hierarchy the same that the workbooks will automatically take on the new file string?

    For example:
    Current situation
    Folder 1 = file a in drive a is located at - \\a\b\c
    Folder 2 = file b in drive a is linked to file a located at - \\a\b

    I need to move folder 1 file a to drive x - \\x\y\z

    If I move both folders to the correct location will it change accordingly?

    Hope this explains it alright.

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Moving multiple linked workbooks

    Dunno, try it and let us know how it goes... (it may be more complicated than this, but it really depends on the properties of your folders & your particular setup etc. - the quickest way is just to try)

    If it doesn't do what you want, we can help you out with a macro to mass-rewrite the links

    CC

  3. #3
    Registered User
    Join Date
    03-07-2007
    Posts
    74

    Re: Moving multiple linked workbooks

    What an easy solution, and I will be sure to put solved on the thread. The file path does automaticallly change if all is kept in the same order.

    Thanks!

+ 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