Maintaining links when copying entire directories

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerry - 23 Aug 2006 14:43 GMT

I have an excel file that links to several other files in the same directory.
Previously, when I made a copy of the entire directory, the links in the new
directory would refer to the files in the new directory. However, today when
I copy an entire directory, the files in the new directory link to files in
the OLD directory. I've never had this happen all the years I've worked with
Excel. What could be causing this change?

Signature

Gerry

Reply to this Message

Naveen - 24 Aug 2006 11:25 GMT

- Open your file
- Click "Replace" in "Edit" menu
- Type old folder name completely in "Find What" text box
(e.g., c:\my documents\Gerry files)
(it should appear same as in your one of the cells. Click on cell that
has folder
name and see in formula bar)
- Type new folder name excatly in "Replace with" text box

click replace all.

*** Please do rate ***

> I have an excel file that links to several other files in the same directory.
> Previously, when I made a copy of the entire directory, the links in the new
> directory would refer to the files in the new directory. However, today when
> I copy an entire directory, the files in the new directory link to files in
> the OLD directory. I've never had this happen all the years I've worked with
> Excel. What could be causing this change?

Reply to this Message