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!

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!

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!

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!
|
|
|

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!
|
|
|

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!
|
|
|