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


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

"Joe User" <joeu2004 wrote in message
...
"squintana" wrote:
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.