Excel 2007 Won't Paste Formulas
 

I have two different workbooks in Excel 2007. I'm trying to copy the formula
from one over to the other one. When I paste it in the second workbook, it
pastes the values not the formula. If I expand the Paste menu, Formulas is
grayed out. The only options are Paste and Paste Special. When I choose
Paste Special its like Excel thinks I'm trying to paste an object. Please
help!

Excel 2007 Won't Paste Formulas
 

Your two workbooks are open in separate instances of Excel and will not
communicate.

Close one instance and open both workbooks in a single instance of Excel.


Gord Dibben MS Excel MVP

On Wed, 9 Dec 2009 10:37:01 -0800, lhodgdon
wrote:

I have two different workbooks in Excel 2007. I'm trying to copy the formula
from one over to the other one. When I paste it in the second workbook, it
pastes the values not the formula. If I expand the Paste menu, Formulas is
grayed out. The only options are Paste and Paste Special. When I choose
Paste Special its like Excel thinks I'm trying to paste an object. Please
help!