Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can NOT copy / paste across workbooks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can NOT copy / paste across workbooks
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 -- Gary''s Student - gsnu200747 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can NOT copy / paste across workbooks
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? -- CL Chuck "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200747 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Workbooks | Excel Discussion (Misc queries) | |||
Copy/Paste hyperlinks between workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
cannot copy and paste worksheets or workbooks | Excel Discussion (Misc queries) |