| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing bulk Link references to different workbook.
We have an excel spreadsheet that has a lot (thousands) of links to data on
an excel spreadsheet on the C: drive. e.g. ='C:\My Documents\Excel\data\[SourceData.xls]Sheet1'!$B$3 We are moving to Citrix, and Losing our C: drives, so I need to update all references in all 16 worksheets from "C:\My Documents" to "H:\Working" Is there a bulk method of doing this? Thanx in Advance Simon Westenra Health Intelligence Wellington, New Zealand. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove link to another workbook | New Users to Excel | |||
| Changing cell references | Excel Discussion (Misc queries) | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| Can't link cells in worksheets in same workbook | New Users to Excel | |||
| How do I link sorted data to other workbook sheets? | Excel Worksheet Functions | |||
Threaded Mode
