Excel - linking spreadsheets

[RAClarke]

I use a lot of Excel spreadsheets linked together on a data model - it is all housed on the C drive and I am due to be migrated to Windows 2000 and a new server. The problem I foresee is that when they do this work they are going to relocate the data model and it's associated spreadsheets to another drive - so all my links between the sheets will be obsolete. Will I now have to painstakingly go through every spreadsheet updating the links?

 

[patriciaanne]

Someone may know of a faster way but if not you can use Edit>Find Replace to replace and update the drive information. Click on options in the replace dialog box to do a global replace throughout the workbook.

 

[rpierle]

If you are using Excel 2000, it is very easy. For each spreadsheet you need to open it up and go into edit>links...and then hit change source and point that set of links to the new source. This should work.

 

[GlennUK]

If the links from a workbook to other Excel files are within the same folder ( directory ), or point to a sub-folder beneath the one where the linking book is held, then the links will be tracked automatically when copying using Windows Explorer. ( copy all the files at the same time, and do NOT, EVER EVER use Excel to move files by doing File/SaveAs because this will not work automatically ).

It is for this reason that I always link within a folder, or link to sub-folders, so that copying from drive to drive is easy.