Gord,

Great idea, I was overthinking it. Some of the formulas are over 255
characters so they wont transfer properly, but its better than updating
100 of links.

Thanks,
Ryan

Gord Dibben wrote:
One method which always works is.........

Before copying to new workbook do an EditReplace

what: =

with: ^^^^

Replace all.

Copy to the new workbook and reverse the replace process.

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

I find just closing without save is easiest for me.


Gord Dibben MS Excel MVP

On 23 Aug 2006 11:29:53 -0700, wrote:

I am creating a copy of a worksheet into a new workbook and all of the
formulas automatically reference the old workbook.

For example:

Formula in Old Workbook is

=R9*L17+GETPIVOTDATA("Billing Amount",'Labor
Pivot'!$A$6,"StatementDate",DATE(2006,8,20)","Tra deCode","F04")

Once I create a copy of the worksheet which contains this formula and
others like it into a new workbook, the formula automatically changes
too

=R9*L17+GETPIVOTDATA("Billing Amount",'[oldworkbook.xls]Labor
Pivot'!$A$6,"StatementDate",DATE(2006,8,20)","Tra deCode","F04")

I just want the same formula to be copied to the new workbook, not pull
from the old workbook.

Please help.
Ryan