I've got a spreadsheet where a huge number of formulae reference another
spreadsheet.
Typically the formulae look like this...
='C:\DBM\Maintenance 2005\[Theddlethorpe Maint 6rev1(EIM) 2005.xls]Oper
Maint Land & Build'!$F$24

How can I change all the references to source the file from H:\ instead of
C:\ ??

Find and replace seems to bu99er up the whole sheet....

Simon.