my paste special function won't let me copy formulas

S

squintana

I am using Excel 2007 and I can't seem to copy and paste formulas from one
workbook to another. Instead I get a dialogue box asking me if I want to use
paste or paste link and to chose from a list of formats. Does anyone know if
there is something that I can change in Excel to fix this problem?
 
D

Dave Peterson

It sounds like you have the workbooks open in separate instances of excel.

Close one of the workbooks (and its instance of excel) and then back to the
first workbook/excel.

Hit ctrl-o and open your second workbook and try the copy|paste.
 
J

Joe User

squintana said:
I am using Excel 2007 and I can't seem to copy and paste formulas from one
workbook to another. Instead I get a dialogue box asking me if I want to
use
paste or paste link and to chose from a list of formats. Does anyone know
if
there is something that I can change in Excel to fix this problem?

Are both workbooks open in the same instance of Excel?

I find it difficult to know when that it is actually the case. To be sure,
I use File > Open to open the second workbook instead of clicking on the
file icon.
 
J

Joe User

Oops.... I didn't see Dave's posting with the same information nearly 3(!)
hrs ago. Mea culpa!


----- original message -----
 

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

Top