I need to copy some worksheets from one spreadsheet to another and I want the
formulae that I have written in the original s/s to copy exactly to the next
s/s, WITHOUT adding in a reference to the original worksheet.

e.g. if I write '=formula' in spreadsheet1.xls I want it to copy across as
'=formula' as opposed to '=[spreadsheet1.xls]formula'

I could use find and replace to get rid of all the unwanted references but I
get 'formula is too long' errors as a direct result of the fact that excel
has added the unwanted reference!!

Help!!