Copy formulas from one Excel book to another 1

[Josewr]

I have two Excel books opened (not two sheets on the same book) and I try to copy the equations from cells on one book to cells on the other book and all I get is the value the cell had on the first book rather than copying the equations.
I can copy the equations from the formula bar, but I would have to copy one cell at a time.
Also if the equations are in two sheets of the same book I can copy them.

Is there a property I have to change?

Thanks

 

[AnotherHiggins]

Sounds like you're running the workbooks in two different instances of Excel.

Open the first workbook, then from within that instance of Excel, go to Edit > Open to open the other workbook. Then try to copy 'n' paste from one workbook to the other.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Josewr]

I was hoping I could do it from one instance of excel to the other. I guess I can't as I could on Wingz.
Thanks

 

[kristal9]

You can from one instance to another if you copy 'n' paste special ---> formulas.

 

[Josewr]

Thanks, That may have worked on an earlier version of Excel, but not on 2007.
The Paste Special choices are different. It changes to:
Microsoft Office Excel Worksheet Object,
Pictures,
Bitmap,
...
DIF,
XML,

etc.