That formula is not legal so I guess there must be a typo or two but aside from
that, one way to copy to another workbook is to copy the formulas as text then
change back to formulas.

Select formulas in source sheet and EditReplace

What: =

With: ^^^

Replace all.

Copy the altered results to the target workbook then reverse the EditReplace in
that workbook.

Close source workbook without saving or reverse the editrplace there also.


Gord Dibben MS Excel MVP

On Thu, 9 Aug 2007 10:42:05 -0700, Dutch
wrote:

I am trying to copy a worksheet A to another workbook. The original worksheet
A has formulas such as ='Store P&LE11, where Store P&L is another worksheet
in the same workbook. The new workbook to which I plan to copy worksheet A
also has a worksheet named Store P&L. I want the copied worksheet to retain
the original formula reference so that it will refer to Store P&L in the
destination worksheet. Instead, I am getting a link reference back to
worksheet A's workbook when I copy the worksheet to its destination. How can
I fix this?

Thanks.