This might save somebody some time and headaches if google picks it up. I was getting a 'Cannot empty the Clipboard' error every time I moved cells around in Excel - eventually I mucked around with the settings and made it go away. Here's how; In the excel main menu (glass globe w/logo), click Excel options, then Advanced, then turn off 'Show paste options buttons'
How exciting was this as my first post of the year?
Update: I still haven't found a permanent solution but I found another thing that seems to help. In Excel 2007, from the "home" tab, the first thing on the left is the clipboard tool panel. Expand the panel to view the clipboard and in the clipboard you might find "cannot empty clipboard" as an entry. Empty the clipboard, keep the panel open for a second or two while you do a few cut and pastes/drags etc. and then the bogey seems to go away.
I call this the cable dance because back in the day I had a printer that only worked if you unplugged the cable, shook it out and plugged it back in.
Good answers by Paul Simon and Steve Homer, I shut down team viewer and that did the trick. Skype or other programs may trigger the same glitch, but in this instance, I recalled the problem occurred when I tried to cut n paste a 2MB file from remote system through windows right click rather than using "File Transfer function in TV. An error message appeared, then the problem with Excel "'Cannot empty clipboard' message.
This problem occurs when you are working on a remote system. After copying and pasting a huge amount of data it shows the error. I have found the solution to this problem.
Go to remote systems task manager and perform the following task
Go to Task Manager > Processes Look for "rdpclip.exe" End that process
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.
here. I have the problem, but it's sporadic. I just tried the technique, and I don't see the problem, but since it's sporadic I won't know for a while if it's gone for good.
Are you running Skype? This has been the best solution I have found to get rid of the "cannot empty the clipboard error" in Excel 2007 & 2010. Delete the Skype add-on in IE and/or Firefox and good-bye annoying error!
In reply to rjacobs7 post on February 28, 2011
Cannot clear clipboard error - Windows 7, Excel 2010 - This error occurs nearly every time a drag and drop of cell contents is attempted. I've had this same error over the past 10 years on older computers and older versions of Windows and Office. It has now reoccurred with a new laptop running Windows 7 64 bit and Office 2010. The issue can be replicated only if a browser - IE or Firefox - is open at the same time that Excel is open. Having Word and/or Outlook open at the same time will not cause the problem to occur unless a browser is also open. This error is extremely irritating and no solutions from Microsoft or other posts on this issue resolve it.
I have a solution - at least for me! Delete the Skype add-in in IE and Firefox and the "cannot clear clipboard" error after a drag and drop goes away when IE and/or Firefox are running. Apparently some sort of memory-management issue with Skype, Office and the browsers.
I've read lots of blogs on this subject going back to 2005!!
I'm sure that Paul Simon is right (see his submission to this thread) and it's a question of finding which program on your machine is locking the clipboard. I do not run the programs listed in various solutons suggested (eg on Microsoft website) nor am I in a networked or virtual environment so for me those aren't the locking programs (but might be for you). Similarly I don't have the RDP task going in my processes. For me the locking program is the Skype Add-in.
I am not a sophisticated user and am scared of altering my registry so didn't want to go there.
I have now been able to reproduce accurately the "cannot clear the clipboard" message by turning on and off the skype addins in internet explorer. This is easy for amateurs to do and might be one of the more common clipboard locking programs:
I first confirmed that I can turn on/off the problem in Excel by opening/closing internet explorer.
Then I disabled the skype addins:
Internet Explorer: Tools menu --> Internet Options ; Programs Tab ; Manage Add-ons button; Toolbars and Extensions selected in panel on left - scroll down to find skype add ons. Press Disable button.
NB have to restart Internet explorer before this works.
I copied a picture (instead of text) that I had in my excel 2007 file and that solved the problem for me. The picture copied to the (then empty) clipboard. I could then copy cells normally even after clearing the clipboard of the picture. I think a graph object should also do the trick.
我发现以下方法可以治愈它。 关闭所有 MS 应用程序，包括 IE 和 Outlook。 检查任务管理器进程以确保它们全部消失。
然后重新启动出现复制和粘贴问题的应用程序，然后它可能会起作用。
问候
保罗·西蒙
I have seen various answers which say when I uninstalled this or that it worked. I think that the uninstall is probably just sorting out an issue in the registry, rather it being an issue with the particular application that is being uninstalled.
I have also seen cases of people saying kill the RDP task but I don't have that and I still have the error.
I have seen cases of people saying clear the clipboard in Excel, but that doesn't work for me - nor does changing the settings in the Clipboard.
I believe that the issue is that an application has a lock on the clipboard and that application is not releasing it. The clipboard is a shared resource, so that implies that each application has to get a lock on it before changing it and then release the lock once it has completed the change, however, it looks like sometimes the lock is not released.
I found that the following cured it. Close down all MS applications including IE and Outlook. Check Task Manager processes to make sure that they are all gone.
Then restart the application where you had the Copy and Paste issue and it will probably then work.
发布评论
评论（10）
检查这个提示。 在这里工作过
http://mobeer.blogspot.com/2009/ 01/excel-2007-cannot-empty-clipboard.html：
check this tip. worked for here
http://mobeer.blogspot.com/2009/01/excel-2007-cannot-empty-clipboard.html:
保罗·西蒙和史蒂夫·霍默的回答很好，我关闭了团队查看器，这成功了。
Skype或其他程序可能会触发相同的故障，但在这种情况下，我记得当我尝试通过Windows右键单击从远程系统剪切和粘贴2MB文件而不是使用“电视中的文件传输功能”时，出现了问题。一条错误消息出现了，然后是 Excel 的问题“‘无法清空剪贴板’消息。
当您在远程系统上工作时会出现此问题。 复制并粘贴大量数据后，它显示错误。 我已经找到了这个问题的解决方案。
转到远程系统任务管理器并执行以下任务
转到任务管理器 > 流程
查找“rdpclip.exe”
结束该过程
您的问题将得到解决。
Good answers by Paul Simon and Steve Homer, I shut down team viewer and that did the trick.
Skype or other programs may trigger the same glitch, but in this instance, I recalled the problem occurred when I tried to cut n paste a 2MB file from remote system through windows right click rather than using "File Transfer function in TV. An error message appeared, then the problem with Excel "'Cannot empty clipboard' message.
This problem occurs when you are working on a remote system. After copying and pasting a huge amount of data it shows the error. I have found the solution to this problem.
Go to remote systems task manager and perform the following task
Go to Task Manager > Processes
Look for "rdpclip.exe"
End that process
Your problem will be solved.
我找到了这个建议：
这里。我遇到了问题，但它是偶发的。我刚刚尝试了该技术，但没有看到问题，但由于它是偶发的，我暂时不知道它是否消失了好的。
I found this advice:
here. I have the problem, but it's sporadic. I just tried the technique, and I don't see the problem, but since it's sporadic I won't know for a while if it's gone for good.
我通过取消选中 Excel 选项中的“覆盖单元格之前提醒”选项解决了这个问题。 我使用的是 Excel 2007
I got rid of the problem by unchecking the option for "Alert before overwriting cells" in Excel options. I'm using Excel 2007
如果找不到剪贴板，请关闭该 Excel 工作表并再次重新打开。 这将解决您的问题。
If you can't find the clipboard, then close that excel sheet and reopen it again. This will solve your problem.
尝试http://support.microsoft.com/kb/207438
如果您在注册表中遵循 v12.0，则该版本适用于 2007 年。
Try http://support.microsoft.com/kb/207438
which will work for 2007 if you follow v12.0 in the registry.
您正在运行 Skype 吗？ 这是我发现的消除 Excel 2007 和 Excel 2007 中“无法清空剪贴板错误”的最佳解决方案。 2010. 删除 IE 和/或 Firefox 中的 Skype 插件，告别烦人的错误！
回复 rjacobs7 2011 年 2 月 28 日的帖子
无法清除剪贴板错误 - Windows 7、Excel 2010 -
几乎每次尝试拖放单元格内容时都会发生此错误。 过去 10 年来，我在旧电脑以及旧版本的 Windows 和 Office 上也遇到过同样的错误。 现在，在运行 Windows 7 64 位和 Office 2010 的新笔记本电脑上，该问题再次出现。只有在打开 Excel 的同时打开浏览器（IE 或 Firefox）时，才会重现该问题。 同时打开 Word 和/或 Outlook 不会导致问题发生，除非浏览器也打开。 这个错误非常令人恼火，微软的解决方案或其他关于此问题的帖子都没有解决它。
我有一个解决方案 - 至少对我来说！ 删除 IE 和 Firefox 中的 Skype 插件，当 IE 和/或 Firefox 运行时，拖放后的“无法清除剪贴板”错误就会消失。 显然，Skype、Office 和浏览器存在某种内存管理问题。
Are you running Skype? This has been the best solution I have found to get rid of the "cannot empty the clipboard error" in Excel 2007 & 2010. Delete the Skype add-on in IE and/or Firefox and good-bye annoying error!
In reply to rjacobs7 post on February 28, 2011
Cannot clear clipboard error - Windows 7, Excel 2010 -
This error occurs nearly every time a drag and drop of cell contents is attempted. I've had this same error over the past 10 years on older computers and older versions of Windows and Office. It has now reoccurred with a new laptop running Windows 7 64 bit and Office 2010. The issue can be replicated only if a browser - IE or Firefox - is open at the same time that Excel is open. Having Word and/or Outlook open at the same time will not cause the problem to occur unless a browser is also open. This error is extremely irritating and no solutions from Microsoft or other posts on this issue resolve it.
I have a solution - at least for me! Delete the Skype add-in in IE and Firefox and the "cannot clear clipboard" error after a drag and drop goes away when IE and/or Firefox are running. Apparently some sort of memory-management issue with Skype, Office and the browsers.
从 2005 年起我就读过很多关于这个主题的博客！
我确信 Paul Simon 是对的（请参阅他对此线程的提交），问题是找到您计算机上的哪个程序锁定剪贴板。 我不运行各种解决方案中列出的程序建议（例如在微软网站上）我也不在网络或虚拟环境中，所以对我来说这些不是锁定程序（但可能适合您）。 同样，我的流程中没有 RDP 任务。 对我来说，锁定程序是 Skype 插件。
我不是一个经验丰富的用户，害怕更改我的注册表，所以不想去那里。
我现在已经能够通过打开和关闭 Internet Explorer 中的 Skype 插件来准确地重现“无法清除剪贴板”消息。 这对于业余爱好者来说很容易做到，并且可能是更常见的剪贴板锁定程序之一：
我首先确认我可以通过打开/关闭 Internet Explorer 来打开/关闭 Excel 中的问题。
然后我禁用了 Skype 插件：
Internet Explorer：工具菜单 --> 互联网选项 ; 程序选项卡； 管理附加组件按钮； 在左侧面板中选择的工具栏和扩展 - 向下滚动以查找 Skype 附加组件。 按禁用按钮。
注意，必须重新启动 Internet Explorer 才能生效。
.... 4天后....它仍然有效
I've read lots of blogs on this subject going back to 2005!!
I'm sure that Paul Simon is right (see his submission to this thread) and it's a question of finding which program on your machine is locking the clipboard. I do not run the programs listed in various solutons suggested (eg on Microsoft website) nor am I in a networked or virtual environment so for me those aren't the locking programs (but might be for you). Similarly I don't have the RDP task going in my processes. For me the locking program is the Skype Add-in.
I am not a sophisticated user and am scared of altering my registry so didn't want to go there.
I have now been able to reproduce accurately the "cannot clear the clipboard" message by turning on and off the skype addins in internet explorer. This is easy for amateurs to do and might be one of the more common clipboard locking programs:
I first confirmed that I can turn on/off the problem in Excel by opening/closing internet explorer.
Then I disabled the skype addins:
Internet Explorer: Tools menu --> Internet Options ; Programs Tab ; Manage Add-ons button; Toolbars and Extensions selected in panel on left - scroll down to find skype add ons. Press Disable button.
NB have to restart Internet explorer before this works.
.... 4 days later.... it's still working
我复制了 excel 2007 文件中的图片（而不是文本），这为我解决了问题。 图片复制到（然后是空的）剪贴板。 即使清除图片剪贴板后，我也可以正常复制单元格。 我认为图形对象也应该能达到这个目的。
I copied a picture (instead of text) that I had in my excel 2007 file and that solved the problem for me. The picture copied to the (then empty) clipboard. I could then copy cells normally even after clearing the clipboard of the picture. I think a graph object should also do the trick.
我看到过各种答案，说我什么时候卸载了这个或者它起作用了。 我认为卸载可能只是解决注册表中的问题，而不是正在卸载的特定应用程序的问题。
我还看到有人说终止 RDP 任务，但我没有这样做，而且仍然有错误。
我见过有人说清除 Excel 中的剪贴板，但这对我不起作用 - 更改剪贴板中的设置也不起作用。
我认为问题在于应用程序在剪贴板上有锁，并且该应用程序没有释放它。 剪贴板是共享资源，因此这意味着每个应用程序在更改它之前都必须对其进行锁定，然后在完成更改后释放锁定，但是，看起来有时锁定没有释放。
我发现以下方法可以治愈它。 关闭所有 MS 应用程序，包括 IE 和 Outlook。 检查任务管理器进程以确保它们全部消失。
然后重新启动出现复制和粘贴问题的应用程序，然后它可能会起作用。
问候
保罗·西蒙
I have seen various answers which say when I uninstalled this or that it worked. I think that the uninstall is probably just sorting out an issue in the registry, rather it being an issue with the particular application that is being uninstalled.
I have also seen cases of people saying kill the RDP task but I don't have that and I still have the error.
I have seen cases of people saying clear the clipboard in Excel, but that doesn't work for me - nor does changing the settings in the Clipboard.
I believe that the issue is that an application has a lock on the clipboard and that application is not releasing it. The clipboard is a shared resource, so that implies that each application has to get a lock on it before changing it and then release the lock once it has completed the change, however, it looks like sometimes the lock is not released.
I found that the following cured it. Close down all MS applications including IE and Outlook. Check Task Manager processes to make sure that they are all gone.
Then restart the application where you had the Copy and Paste issue and it will probably then work.
Regards
Paul Simon