This should be simple...

I have equations in one spreadsheet that reference cells in other worksheets
within that spreadsheet. I'm looking to copy these equations to another
spreadsheet and retain the relative reference to the named worksheet (i.e.
there's a worksheet in the new file with a name that matches the worksheet
from the previous file). However, when I do the copy / paste, I the equation
references the worksheet in the previous spreadsheet.

To clarify: say I'm copying the equation "=Sheet1!a1" from OldFile.xls to
NewFile.xls but in NewFile, the equation becomes "=[OldFile]Sheet1!a1" when I
just want the original equation. Any suggestions to avoid manually editing
everything?

thanks