Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    3

    Question Unanswered: Excell - reorganize - Links Path

    Hello,

    I need to reorganize my drive of work because of the continuous increase of data. The general idea is to create 4 initial folders where I can reorganize the existing drive, The problem is that all my files are linked to another files and since I have thousands of files and millions of links I'm afraid of break the links since the path will change. I know that if I change the source documents while the output documents are open the excel update automatically the links but since I have a lot of data is not a reasonable solution.

    Does anyone knows another way to update the links path automatically



    Best Regards


    Francisco Costa

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    You might be able to find a solution here.

    http://www.wopr.com/cgi-bin/w3t/show...c=1#Post144144
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi
    An alternative possibility would be to use the Edit -> Links -> ChangeSource menue option to point at the same file(s) in it's new lockation after the reorganisation (if this is feasible).

    Regards

    MTB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •