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 files filename in many of the formulae??

the best method I know is to copy and then do find replace to insure the
proper sheet is referenced.
In other words I don't know how to do it directly.

"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 files filename in many of the formulae??

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??