Can't Copy and Paste between Excel 2003 Workbooks

[Guest]

We have a number of Excel users in our office who cannot copy and paste
between Excel workbooks. They can copy and paste between worksheets. When you
highlight the section to copy and then go to the new workbook both the paste
and paste special are "grayed out". This is true whether you right-click the
mouse, go to the edit menu, or use control keys. This occurs with any data
type and the most simple workbooks. I have seen some suggestions here but
none have worked for this particular problem. I have reset the menus and
renamed the .xlb files and neither helps. You can open the clipboard and the
paste will work, but there is no paste special option. Any help would be
greatly appreciated. Thanks!

 

[Jim Rech]

After you do the Copy the status bar in Excel's lower left corner should say
"Select destination and press Enter..." After you switch to the other
workbook it should still say that. If it doesn't that explains partially
what's going on - something is clearing the clipboard. What it would most
likely be is a macro that runs automatically when a workbook is activated or
deactivated.

--
Jim
| We have a number of Excel users in our office who cannot copy and paste
| between Excel workbooks. They can copy and paste between worksheets. When
you
| highlight the section to copy and then go to the new workbook both the
paste
| and paste special are "grayed out". This is true whether you right-click
the
| mouse, go to the edit menu, or use control keys. This occurs with any data
| type and the most simple workbooks. I have seen some suggestions here but
| none have worked for this particular problem. I have reset the menus and
| renamed the .xlb files and neither helps. You can open the clipboard and
the
| paste will work, but there is no paste special option. Any help would be
| greatly appreciated. Thanks!

 

[Guest]

Jim,
I appreciate your reply, however the clipboard is not being clearerd. When I
switch to the destination workbook I can paste from the clipboard but I
cannot by right-clicking the mouse, using the edit menu, or control
keys.Therefore I cannot peroform a paste special. This is a workbook that I
created and there is nothing special about it. In fact it is just a test for
this problem.

 

[Jim Rech]

Ah, you're talking about the flaky office clipboard not the Windows
clipboard. Irrelevant since you can only paste special from the real
clipboard. So can you answer my question about the prompt?

--
Jim
| Jim,
| I appreciate your reply, however the clipboard is not being clearerd. When
I
| switch to the destination workbook I can paste from the clipboard but I
| cannot by right-clicking the mouse, using the edit menu, or control
| keys.Therefore I cannot peroform a paste special. This is a workbook that
I
| created and there is nothing special about it. In fact it is just a test
for
| this problem.
|
|
| "Jim Rech" wrote:
|
| > After you do the Copy the status bar in Excel's lower left corner should
say
| > "Select destination and press Enter..." After you switch to the other
| > workbook it should still say that. If it doesn't that explains
partially
| > what's going on - something is clearing the clipboard. What it would
most
| > likely be is a macro that runs automatically when a workbook is
activated or
| > deactivated.
| >
| > --
| > Jim
| > | > | We have a number of Excel users in our office who cannot copy and
paste
| > | between Excel workbooks. They can copy and paste between worksheets.
When
| > you
| > | highlight the section to copy and then go to the new workbook both the
| > paste
| > | and paste special are "grayed out". This is true whether you
right-click
| > the
| > | mouse, go to the edit menu, or use control keys. This occurs with any
data
| > | type and the most simple workbooks. I have seen some suggestions here
but
| > | none have worked for this particular problem. I have reset the menus
and
| > | renamed the .xlb files and neither helps. You can open the clipboard
and
| > the
| > | paste will work, but there is no paste special option. Any help would
be
| > | greatly appreciated. Thanks!
| >
| >
| >

 

[Guest]

The prompt does say "Select destination....." but after I switch workbooks
the prompt returns to "Ready".

 

[Jim Rech]

So something IS clearing the real clipboard. Likely a macro. As a test you
might disable all macros (with Seurity Medium or higher) at startup (like
Personal.xls) and when opening workbooks. If the problem goes away you know
it's something in one of those workbooks.

 

[Guest]

I believe you mentioned the macro issue earlier so I set security to High and
the problem persists. The problem doesn't just occur on existing workbooks
either, I can create two new workbooks with data in as little as one cell and
the problem still occurs. I do appreciate your time on this, by the way this
doesn't just occur on one system we have about 8 different systems that this
is happening to. All systems are the same: Windows 2000 Professional SP4,
Office 2003 Standard SP1, IBM Notebooks. Thanks