- 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:
[Quoted Text] > 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
|