copy formula
 

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?

copy formula
 

On Feb 8, 10:44*am, Steve wrote:
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.

copy formula
 

One method.

Select all cells to copy.

EditReplace

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

On Fri, 8 Feb 2008 07:44:00 -0800, Steve
wrote:

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?