Copy formula from one workbook to another without reference to 1st


S

Scott

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.
 
Ad

Advertisements

W

Warren Easton

Hi Scott,

Highlight the the formula when it's in the formula bar at the top of the
sheet then press ctrl -C them move it and paste it.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
 
G

Gord Dibben

After the copy/paste.

Assuming destination workbook has been saved.

Edit>Links>Change Source.......select current workbook and OK

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


Gord Dibben MS Excel MVP
 
M

Matt Beardsley

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

Gord Dibben said:
After the copy/paste.

Assuming destination workbook has been saved.

Edit>Links>Change Source.......select current workbook and OK

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


Gord Dibben MS Excel MVP

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.
 
Ad

Advertisements

E

Eric Hackett

Thank you so much! I had hundreds of cells that got jacked, and this saved me hours.
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
On Friday, December 12, 2008 3:41 PM WarrenEasto wrote:
Hi Scott,

Highlight the the formula when it's in the formula bar at the top of the
sheet then press ctrl -C them move it and paste it.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


"Scott" wrote:
On Friday, December 12, 2008 6:02 PM Gord Dibben wrote:
After the copy/paste.

Assuming destination workbook has been saved.

Edit>Links>Change Source.......select current workbook and OK

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top