ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can NOT copy / paste across workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/160170-can-not-copy-paste-across-workbooks.html)

CL Chuck

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

Dave Peterson

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

Gary''s Student

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


CL Chuck

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



All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com