Changing route directory of links across multiple files

Mar 13th, 2002, 08:31 AM

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 · Mar 13th, 2002, 01:40 PM

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 · Mar 13th, 2002, 01:46 PM

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 · Mar 13th, 2002, 02:47 PM

[ This Message was edited by: NateO on 2002-03-13 14:25 ]

Mar 13th, 2002, 01:40 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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. __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 08:31 AM	#1
Guest Posts: n/a	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?

Mar 13th, 2002, 01:46 PM	#3
marbel New Member Join Date: Feb 2002 Posts: 5	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

Mar 13th, 2002, 02:47 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	[ This Message was edited by: NateO on 2002-03-13 14:25 ]