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.
Bookmarks