Hi
I don't what your talking about here is there solution;
Hi srej,
I see the same error on my Excel 2000 at home and Excel 2002 here at
work. Usually, it occurs when I have an overlapping range (e.g. pasting
A1
5 to B1:E5). As long as I acknowledge the error message, it allows
me to proceed.
Brad
Comment from srej
Date: 11/21/2003 04:32PM PST
Author Comment
byundt,
thanks for responding, but I think my error is a little different. The
error message pops up even if I just copy one cell or even the format of
a cell and it will not allow me to paste even after I click "OK" on the
error message. It's like it never makes it to the clipboard.
Comment from pkhari
Date: 11/22/2003 01:41AM PST
Comment
Hi,
There are a few steps to solve your problem:
First thing to do is Clear items from the Office Clipboard. If the
Microsoft Office Clipboard is not displayed in the task pane, click
Office Clipboard on the Edit menu. On the Office Clipboard task pane,
do one of the following: To clear all items, click Clear All .
Next thing is to switch off the clipboard show option. To do this, what
you can do is to again display the Clipboard menu (select Office
Clipboard from Edit Menu). And in the selection button "Options" at the
bottom of the screen, select this particular option:
"Collect Without Showing Office Clipboard"
and now, you are relieved of the bug.
Hope this helps.
Cheers
P.K.
Comment from pkhari
Date: 11/22/2003 03:54AM PST
Comment
Hi
In case my above solution does not work, why dont you try an earlier
solution given in the below linK:
http://www.experts-exchange.com/Applications/MS_Office/Q_10053878.html
Hope this helps
Cheers
P.K.
Comment from byundt
Date: 11/22/2003 08:39AM PST
Comment
P.K.
The Edit menu in Excel 2000 does not expose the Clipboard object. I
suspect you are using Excel 2002 or 2003.
Brad
Comment from srej
Date: 11/24/2003 04:23PM PST
Author Comment
Yea, you can just use View > Toolbars > Clipboard to show the
clipboard, but I don't see the options you are talking about ("Collect
Without Showing Office Clipboard"). If you know how to do this on
Excel 2000 please let me know so I can test it.
Administrative Comment from modulo
Date: 12/29/2003 01:45PM PST
Administrative Comment
A request has been made in Community Support to close this question:
http://www.experts-exchange.com/Community_Support/Q_20836656.html
If there are no objections, a moderator will finalise this question
after 72 hours by:
- PAQ-ing the question and refunding points
Please leave any recommendations here.
modulo
Community Support Moderator
Experts Exchange
Accepted Answer from Computer101
Date: 01/01/2004 08:07AM PST
Grade: A
Accepted Answer
PAQed, with points refunded (75)
Computer101
E-E Admin
Comment from roos01
Date: 06/06/2004 08:30AM PDT
Comment
found a macro to empty the clipboard. not sure if it is for use of
you.
Public Declare Function OpenClipboard Lib "user32" ( _
ByVal hwnd As Long) As Long
Public Declare Function CloseClipboard Lib "user32" () As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Sub ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Sub
regards,
Jeroen
Comment from pkhari
Date: 06/12/2004 03:57AM PDT
Comment
Hi all
Just found a good way in attempting to solve my own "Cannot empty the
clipboard" error.
In all probability, when you have Getright or Flashget software
installed in your machine, it is likely to cause this error. Open that
software, and just uncheck the option "Monitor the clipboard", and come
back to excel. Now it should be ok.
Just thought of sharing this with all of you.
Cheers
P.K.
Comment from roos01
Date: 06/13/2004 10:39AM PDT
Comment
Thanks PK for sharing this. never thought about 3rd party software
causing suchs problems also.
Comment from osg192
Date: 02/07/2005 03:38PM PST
Comment
I am experiencing this problem too. In my situation it is being caused
on the host PC by terminal services (remote desktop). Host is running
Windows XP service pack 2. Excel: Excel 2000 ver 9.0.3821 SR-1.
RB
Comment from LoveToSpod
Date: 10/03/2005 02:44AM PDT
Comment
I had this problem and the errors have now stopped. When I opened
Excel, I was prompted to save or delete 'recovered files'. If I
deferred dealing with this, and chose 'I wish to view these files
later' I got the error. Cleardown these recovered files at Excel
startup, by either saving or deleting them. This sorted the problem for
me immediately. Hope this helps,
LoveToSpod