您是否曾尝试在Excel中复制某些单元格并收到无法清空剪贴板 (Cannot empty the clipboard )错误消息(error message)?我最近是这个恼人错误的受害者,每次(EVERY time)我尝试从电子表格上的任何单元格复制数据时都会弹出该错误。
奇怪的是该副本对我仍然有效,但我必须继续单击 OK 以删除错误消息(error message)。在我自己阅读和玩耍之后,我了解到这个错误可能由于各种原因而发生,并且有许多修复程序可以尝试解决该错误。
大多数情况下,您会在Microsoft Excel 和 Word(Microsoft Excel and Word)中看到此错误,尤其是在您尝试复制任何类型的数据时。这是我能找到的所有可能的解决方案。如果您有不同的解决方案,请随时在评论中发布。
方法一:(Method 1:)
有时在Excel中,如果一个单元格已被复制并且您尝试复制另一个单元格,您可能会收到此错误。您可以尝试按ESC 键(ESC key)取消选择复制的单元格,然后再次尝试复制。
此方法可能让您复制一次,但您可能仍会在下次尝试复制时收到错误消息。(error message)这不是永久修复。
方法二:(Method 2:)
您可以尝试的另一件事是在Windows中打开剪贴板并将其保持打开状态。有时这样做可以帮助摆脱错误。这不是一个很好的解决方案,但这些是您在Windows(Windows)中必须做的奇怪事情!
您可以通过转到开始(Start)、运行(Run)并输入clipbrd.exe来打开(clipbrd.exe)剪贴板(Clipboard)。您也可以进入Windows\System32 directory and double-clickclipbrd.exe。
方法三:(Method 3:)
如果您一直在使用Remote Desktop,您可能会收到Cannot Copy to Clipboard错误,因为Remote Desktop使用剪贴板,它可能会导致(Remote Desktop)Excel出现奇怪的问题。
转到任务管理器(Task Manager),单击进程(Processes)选项卡,终止名为rdpclip.exe的进程,看看是否能解决您的问题!如果你安装了 UltraVNC,它也可能是罪魁祸首!
任何类型的远程桌面软件(desktop software)都可能导致该问题,因此请确保在其中一个程序运行时检查您是否遇到问题。
方法四:(Method 4:)
转到 Excel,单击Tools,然后单击Options,然后转到Calculation选项卡。确保从三个选项中选择自动。(Automatic)在较新版本的Excel 中(Excel),单击文件(File),然后单击选项(Options),然后单击左侧选项卡中的公式。(Formulas)
在较新版本的Excel 中(Excel),您必须单击文件(File)、选项(Options),然后单击公式(Formulas)。
方法五:(Method 5:)
如果您的计算机上安装了GetRight 或 Flashget(GetRight or Flashget)之类的程序,则必须进入并取消选中“监视剪贴板”选项。
任何其他可能尝试使用Windows 剪贴板(Windows Clipboard)的程序都可能导致问题,因此请卸载您知道使用剪贴板的任何第三方软件。(party software)
方法六:(Method 6:)
通过转到Edit并选择Office Clipboard来清除办公室(office clipboard)剪贴板。这仅适用于Office XP和 2003。现在继续并单击全部(Clear All)清除以完全清除办公室剪贴板(office clipboard)。
此外,在屏幕底部,您应该会看到一个选项(Options)按钮。单击(Click)它并选择“收集而不显示办公室剪贴板(Collect without showing office clipboard)”选项。
方法七:(Method 7:)
Microsoft已在其 KB 中写入了有关此错误的信息,并且他们有针对它的修补程序,但它可能适合您,也可能不适合您。它仅适用于Windows Server 2003,并且与终端(Terminal) 服务(Services)有关。
您可以在此处下载修补程序:http: http://support.microsoft.com/?id=840872 ?id=840872 。
这就是我无法清空剪贴板的所有解决方案!如果您有其他适合您的解决方案,请在此处发表评论!祝你好运!
Windows有很多这样的神秘消息,我之前已经写过其中的一些,例如如何修复丢失或损坏的NTFS.sys、修复Windows Search Indexer已停止工作、修复Windows中无法识别的USB 设备(USB device)以及修复主机(host process)Windows中的进程已停止工作错误。哇!
Fix for Cannont Empty the Clipboard in Office
Have you ever tried to copy some cells in Excel and gotten the Cannot empty the clipboard error message? I was recently the victim of this annoying error, which would pop up EVERY time I tried to copy data from any cell on my spreadsheet.
The strange thing is that the copy still works for me, but I have to keep clicking OK to remove the error message. After some reading and playing around on my own, I’ve learned that this error can happen for all kinds of reasons and there are a number of fixes you can try to troubleshoot the error.
For the most part, you’ll see this error in Microsoft Excel and Word, especially when you are trying to copy any kind of data. Here are all the possible solutions I could find. If you have a different solution, feel free to post it in the comments.
Method 1:
Sometimes in Excel you can get this error if a cell has been copied and you try to copy another cell. You can try to press the ESC key to deselect the copied cell and then try to copy again.
This method might let you copy one time, but you may still get the error message on the next attempt to copy. It’s not a permanent fix.
Method 2:
Another thing you can try is to open the clipboard in Windows and leave it open. Sometimes doing this can help get rid of the error. It’s not a great solution, but these are the strange things you have to do in Windows!
You can open the Clipboard by going to Start, Run and typing in clipbrd.exe. You can also go to Windows\System32 directory and double-click on clipbrd.exe.
Method 3:
If you’ve been using Remote Desktop, you may get the Cannot Copy to Clipboard error because Remote Desktop uses the clipboard and it can cause weird issues with Excel.
Go to Task Manager, click on the Processes tab, kill the process called rdpclip.exe and see if that fixes your problem! If you have UltraVNC installed, it may also be the culprit!
Any kind of remote desktop software could be causing the issue, so make sure to check to see if you have the problem when one of those programs are running.
Method 4:
Go to Excel, click on Tools, then Options, and go to the Calculation tab. Make sure that Automatic is selected from the three options. In newer versions of Excel, you click on File, then Options and then click on Formulas in the left-hand tab.
In newer versions of Excel, you have to click on File, Options and then click on Formulas.
Method 5:
If you have a program like GetRight or Flashget installed on your computer, you will have to go in and uncheck the option for “Monitor the clipboard”.
Any other program that may try to use the Windows Clipboard could be causing the problem, so uninstall any third party software that you know uses the clipboard.
Method 6:
Clear the office clipboard by going to Edit and choosing Office Clipboard. This will only work for Office XP and 2003. Now go ahead and click Clear All to clear the office clipboard completely.
Also, at the bottom of the screen, you should see an Options button. Click on that and select the “Collect without showing office clipboard” option.
Method 7:
Microsoft has written about this error in their KB and they have a hotfix for it, but it may or may not work for you. It’s only for Windows Server 2003 and it has to do with Terminal Services.
You can download the hotfix here: http://support.microsoft.com/?id=840872.
That’s all the solutions I could find for not being able to empty the clipboard! If you have another solution that has worked for you, post a comment here! Good luck!
Windows has lots of cryptic messages like this and I’ve written about a few of them before like how to fix missing or corrupt NTFS.sys, fix Windows Search Indexer has stopped working, fix USB device not recognized in Windows, and fix for host process in Windows has stopped working error. Whew!