Could you select all sheets in the workbook then
EditReplace:
Find what: \owner\
Replace with: \XXXX\

That would fix the formulas.

Does that help?

***********
Regards,
Ron


"Derekc" wrote:

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\