Changing route directory of links across multiple files

[Guest]

I have a number of excel files which are linked to files containing the raw data. I am moving all the files to a new directory. How can I change the route directories on the links without having to go into each file and change the link individually?

 

[Chris Davison]

2 options spring immediately to mind

1) make sure all your files are open and then "save as" into their new respective directories (any links will auto-update themselves)

2) on your files that were linked to (say) files in the old "personnel" directory which have now been moved to the new "finance" directory, just edit/replace the word "personnel" with "finance" on all sheets

3) there might be a find/replace command in MS DOS, it's been a while since I used it where you can just replace old text with new text.... long shot though.

 

[marbel]

I think you may also be a candidate for the Edit / Links menu item, where you can "change source," although each separate file would need to be updated individually. Find / replace (alt e e)would be my first choice.

mb

 

[NateO]

This message was edited by NateO on 2002-03-13 14:25