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