View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derekc
 
Posts: n/a
Default I need to change the path of the linked files - thousands of them.

I need to change the path of the linked files - thousands of them, in batch
in my parent spreadsheet. How can it be done?

My old linked files are in:
='C:\Documents and Settings\owner\Desktop\PALOS VERDES BACK UP 2\UNIT
ENTRIES - CURRENT\

With a PC rebuilt, they are now in:
='C:\Documents and Settings\XXXX\Desktop\PALOS VERDES BACK UP 2\UNIT ENTRIES
- CURRENT\