Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Maintaining links when renamining/moving files | Excel Discussion (Misc queries) | |||
Copying Multiple Links at One Time | Excel Discussion (Misc queries) | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |