View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Can NOT copy / paste across workbooks

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.

CL Chuck wrote:

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


--

Dave Peterson