View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrbarnard
 
Posts: n/a
Default Repairing link roots when moving worksheets

I have several workbooks of data that have several links to adjacent
workbooks. They are all currently in a folder on the C: drive. I want to move
all the workbooks to a folder on a network T: drive.

How do I modify all of the links so that they will still link to the
adjacent workbooks once they are all moved to the T: drive? I'm sure this is
a simple issue, but I'm drawing a blank. If I simply copy them over, then the
link fails because it continues to "look" for the linked worksheet in the
original directory.

I'm working on MS Excel 2003, running on Windows 2000 Pro.