Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 29
Default Maintaining links when copying entire directories

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 100
Default Maintaining links when copying entire directories

- 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update links prompt not wanted neeraj Excel Discussion (Misc queries) 5 September 23rd 05 06:34 PM
Maintaining links when renamining/moving files Lou Di Pietro Excel Discussion (Misc queries) 2 July 20th 05 03:55 AM
Copying Multiple Links at One Time heelinva Excel Discussion (Misc queries) 2 May 31st 05 11:33 AM
Reoccurring Edit Links Error Spyder Excel Discussion (Misc queries) 6 April 12th 05 02:30 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"