Sounds like you are running two instances of Excel with a workbook in each.

These will not communicate.

Close one instance and open both workbooks in a single instance then do your
copy/pasting.


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 05:37:01 -0800, sjmonroe
wrote:

All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B
sheet 1 it will not let me with out pulling up the office clip board and it
never used to do this. I used to be able to just highlight, right click, and
hit copy then go to the other workbook, right click, and hit paste. Also it
will not copy the formulas over just the values. Any suggestions why?