Same problem, your solution saved me from manually fixing 42000 cells. THANK
YOU!

"Gord Dibben" wrote:

After the copy/paste.

Assuming destination workbook has been saved.

EditLinksChange Source.......select current workbook and OK

The [1200.xls] will be gone leaving = 'Operating'!AE66


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 12:35:01 -0800, Scott
wrote:

I'm trying to copy formulas from one workbook to another with links to the
same worksheets that are in both workbooks, but when i copy and paste, or
copy and paste special, it links the 2nd workbook back to the 1st workbook
with the formula as follows:

='[1200-07.xls]Operating'!AE66

I would like it to appear as follows:

='Operating'!AE66

Any suggestions would greatly be appreciated. Thanks in advance for your
help.