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.

--
Scott