Excel 2007 Won't Paste Formulas

L

lhodgdon

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!
 
G

Gord Dibben

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
 

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

Similar Threads

Paste to excel from word - auto format problem 1
Embed the same Excel multiple times 0
my paste special function won't let me copy formulas 3
Paste Special Menu 1
how to copy and paste value from one sheet to another 4
Pasting formulas advances cell reference 2
cut & paste HTML 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top