Open both workbooks in the same instance of excel.
Select the worksheet to copy in the "sending" workbook.
Change all the formulas to text using that technique that Gord suggested.

Select all the cells
edit|Replace
What: =
With: ^^^
Replace all

Copy that sheet (edit|Move or copy sheet) to the other workbook.
Ignore the error about the truncation.

Back to the original workbook/worksheet.
Select all the cells
edit|copy

To the new workbook/worksheet
Select A1
Edit|Paste

With all the cells selected in that new worksheet, it's time to change the
strings back to formulas:

Select all the cells
edit|Replace
What: ^^^
With: =
Replace all

And do the same in the original worksheet, too. (Or close it without saving.)




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.

--

Dave Peterson