Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving linked files (2000)

    I recently did some end-of-the-year organizing of my computer files. In the process I moved some Excel files that were linked to a completely separate "totals" worksheet. Now every time I open my "totals" worksheet, a box pops up that says the computer cannot find the files and I have to go through and show it where each of the five or six files is now. I thought that if I saved the "totals" file before closing it would remember where the moved files are, but, alas, I've had to re-show it where they are every time. Does anyone know what I have to do to make it remember? Any help is much appreciated! Thank you!

    Amy

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Moving linked files (2000)

    Edit, Links, Change Source. Be careful you point to the correct intended source Workbook(s) for the links, or you can end up with a mess. (Guess how I know this?)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving linked files (2000)

    Thanks, John. Worked like a charm.

    Amy

  4. #4
    New Lounger
    Join Date
    May 2001
    Location
    New York City, NY
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving linked files (2000)

    Wherever possible, Amy, you should keep linked files in the same folder. That way, you can move them wherever you like, without fear of disrupting the links.

Posting Permissions

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