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.

--
Jim
"wllee" wrote in message
...
The prompt does say "Select destination....." but after I switch workbooks
the prompt returns to "Ready".

"Jim Rech" wrote:

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
"wllee" wrote in message
...
| 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
| "wllee" wrote in message
| ...
| | 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!
|
|
|