- 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 ***





"Gerry" wrote:

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?
--
Gerry