Copy formula from one workbook to another without reference to 1st
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.
|