copy formula

[Steve]

I have two nearly identical workbooks...one is a revision of the other.
They're names, for the sake of discussion, are Book1 and Book1_rev. They
have the same number of sheets and the same sheet names. If I have a formula
in Book1: +Sheet!A1 and copy it to Book2 I get the name of the workbook
(Book1). I know I can edit the formula but is there a setting I can change
that will not do it that way?

 

[HKaplan]

I have two nearly identical workbooks...one is a revision of the other.  
They're names, for the sake of discussion, are Book1 and Book1_rev.  They
have the same number of sheets and the same sheet names.  If I have a formula
in Book1: +Sheet!A1 and copy it to Book2 I get the name of the workbook
(Book1).  I know I can edit the formula but is there a setting I can change
that will not do it that way?

One suggestion. Hit F2 to get in edit mode , then copy the formula.
When you paste it, the exact same formula will be pasted.

 

[Gord Dibben]

One method.

Select all cells to copy.

Edit>Replace

What: =

With: ^^^

Replace all.

Copy to Book2 then reverse the process in both Books or just close Book1 without
saving.


Gord Dibben MS Excel MVP