 |
01-25-2012, 07:24 AM
|
#1
|
|
Registered Member
Join Date: Jan 2012
Posts: 3
OS: windows 2007
|
"Cannon Open The Clipboard" error in Excel
PLEASE HELP!!!!
I get an error message stating "Cannot Open The Clipboard" when I try to copy a cell in Excel. It doesn't happen every time I try to copy, but it happens very often and for no reason. If I continue to copy the cell it will eventually stop popping up and actually copy the cell. Although it may seem minor when you work in Excel ALL day long and this happens constantly thru out the day, it is very annoying and frustrating. I have googled for an answer but can't find anything. I have tried making sure the Clipboard is cleared and it is. if anybody can hep me fix this problem that would be great.
I have attached a screenshot of the error.
__________________
|
|
|
01-25-2012, 12:09 PM
|
#2
|
|
Team Manager Microsoft Support
Join Date: Mar 2010
Location: Midlands of South Carolina
Posts: 7,103
OS: Windows 7 Pro, ME, Vista. In the past CP/M, DOS, Windows 95, 2000 & 98SE
|
Re: "Cannon Open The Clipboard" error in Excel
The usual cause is another program using the clipboard and not releasing it. If you need immediate relief see: Delete items from the Office Clipboard - Word - Office.com
__________________
The stability of an OS is in direct proportion to the stability of the user.
|
|
|
01-25-2012, 12:29 PM
|
#3
|
|
Registered Member
Join Date: Jan 2012
Posts: 3
OS: windows 2007
|
Re: "Cannon Open The Clipboard" error in Excel
Corday-
The lihk you provided gives instructions on how to delete items from your clipboard. I have already done that and it doesn't fix the problem.
__________________
|
|
|
01-25-2012, 02:09 PM
|
#4
|
|
Team Manager, Articles Analyst Rangemaster, TSF Academy
Join Date: Sep 2005
Location: Glasgow
Posts: 38,052
OS: Win XP Pro SP3 / Win 7 Pro
|
Re: "Cannon Open The Clipboard" error in Excel
|
|
|
01-25-2012, 02:41 PM
|
#5
|
|
Team Manager Microsoft Support
Join Date: Mar 2010
Location: Midlands of South Carolina
Posts: 7,103
OS: Windows 7 Pro, ME, Vista. In the past CP/M, DOS, Windows 95, 2000 & 98SE
|
Re: "Cannon Open The Clipboard" error in Excel
Hopefully Glaswegian's fix worked for you. I wasn't sure of your OS (Windows 2007?) but now that I see you're on Windows 7: Task Mgr.>Process>Turn Off rdclip.exe. Open Excel>Tools>Options>Calculations>Calculation- Check Automatic>ReBoot Computer. Now clear the clipboard as you did before but at the bottom of the Window select Collect without showing Office clipboard and again reboot.
__________________
The stability of an OS is in direct proportion to the stability of the user.
|
|
|
01-26-2012, 05:36 AM
|
#6
|
|
Registered Member
Join Date: Jan 2012
Posts: 3
OS: windows 2007
|
Re: "Cannon Open The Clipboard" error in Excel
Glaswegian and Corday-
I tried all three suggestions and neither worked. The settings were already set as the instructions you provided had listed.
This is the strangest and most aggravating thing.
__________________
|
|
|
01-26-2012, 06:38 AM
|
#7
|
|
Team Manager, Articles Analyst Rangemaster, TSF Academy
Join Date: Sep 2005
Location: Glasgow
Posts: 38,052
OS: Win XP Pro SP3 / Win 7 Pro
|
Re: "Cannon Open The Clipboard" error in Excel
Have you tried a Repair on Excel?
Repair Excel 2003, Excel 2007, and Excel 2010
I have to say I have my doubts that there is actually a fix for this issue - I haven't been able to find a definitive answer so far.
|
|
|
06-21-2012, 02:22 PM
|
#8
|
|
Registered Member
Join Date: Jun 2012
Posts: 1
OS: win7
|
Re: "Cannon Open The Clipboard" error in Excel
Here is the fix I used with success.
start>
Run>
Type services.msc
look for> Network DDE & Network DDE DSM
~Enable both and set to Automatic and click start
Look for> ClipBook
~ Enable> Set to Automatic and click start.
This worked for me on a few PC we had here at the office.
__________________
|
|
|
 |
| Thread Tools |
Search this Thread |
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
All times are GMT -7. The time now is 08:14 PM.