Before copying do an EditReplace

What: =

With: ^^^

Replace all.

Copy and paste to other book and reverse the process.

Close source book without saving or reverse there also.


Gord Dibben MS Excel MVP


On Fri, 6 Jul 2007 10:08:01 -0700, Beep Beep
wrote:

When one has two versions of the same file open, say “frankstaxes.xls” and
“frankstaxes_2.xls” and one is copying a worksheet from one to the other, how
do you get around Excel renaming all the references so that they include the
local file’s filename in many of the formulae??