Can NOT copy / paste across workbooks

C

CL Chuck

I am using Excell 2003. The workbooks are not protected. I highlight the
data in the 1st workbook and select copy. I then go to the 2nd workbook and
the paste (and paste special) feature is NOT available. Any help /
suggestions are appreciated.

CL Chuck
 
D

Dave Peterson

Does this mean that the option doesn't appear?
Or that it's disabled (greyed out)?
Or that you get a different dialog than you expected?

If it's the first, I'd reset the toolbar
Tools|customize|toolbars tab|select worksheet menu bar and click reset

If it's the second, I'd look for some macro that's killing the clipboard. Maybe
a worksheet or workbook event macro--or even an application event (which could
be in another workbook, too).

If it's the last, then you have two instances of excel running. Close one of
them and use File|open to open in the first instance to open the second
workbook. Then try the copy|paste.
 
G

Gary''s Student

Make sure all the workbooks are open in the same instance of Excel:

From the Menu bar
File > Open
each workbook, rathr than double-clicking icons
 
C

CL Chuck

The paste option is "greyed out". I tried opening the workbooks in the same
instance of Excell. That did not work. If it is a macro killing the
ckipboard, how I determine / fix that?
 
Top