Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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\ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to change the path of the linked files - thousands of them.
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\ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to change the path of the linked files - thousands ofthem.
Rename current correct linked workbook file. Create a new "old" workbook
dummy at the old location (it can be blank). Open both workbooks and then do "save as" on the dummy to the correct current location. Save the parent. Close Excel, delete dummy and rename the linked workbook to its correct name. 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\ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change thousands to intergers on my spreadsheet? | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
how would i change default user name all excel files | Excel Discussion (Misc queries) | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Controlling Linked Data to Workbooks | Excel Worksheet Functions |