Remove the pointless message “There's a problem with the clipboard, but you can still paste your content within this workbook."
The message shows up if you run in the background a program that keeps a peek into the clipboard, as for example the "Skype web plugin" and other telephone programs. A possible cause can also be the software "Audials".
You can find a thread with lots of complaints and a few flimsy justifications and non-answers here:
The message shows up with Ctrl+C, Ctrl+X, using the Format Painter and only taking whole cells. It does not show up if you copy a part of a cell content.
Contrary to some Microsoft officials’ posts, the error message shows up multiple times per Excel session. Usually it shows up at the second Ctrl+C after opening an Excel instance, sometimes on the third Ctrl+C and rarely on the first Ctrl+C. And after that randomly every few usages of Ctrl+C. That can be several hundred times a day!
Not everyone is lucky as I am to identify the cause (telephone) and be also able to switch off its feature "clipboard surveillance".
There is no reasonable reason for this message at all.
1. The message is incorrect in 100% of the cases. The copying operations in Excel are not affected by the access of any third-party program to the clipboard. After clicking the message away, all insertion processes in 100% of the cases worked absolutely as expected and error-free. I've tested this with many different contents (formulas, validations, formatting, connected cells, etc.), from and into Excel.
2. The message is pointless in 100% of the cases, because it shows neither causes nor solutions. Just as helpful as a message "There's a light on in the basement."
3. If there was any case where the access of a third-party program to the cache was actually an impairment to the copying process in Excel, one would notice this anyway by missing the insertion. But the message would be as well unnecessary because it only would have reported the obvious and does not reveal any causes or solutions.
4. If the access of any third-party program on the clipboard would actually be a problem, then why don't you also ‘protect’ Word, Outlook, PowerPoint, etc.?
This problem is discussed and complained in forums for about 4 years (since Excel 2013). Why don’t you comment out that one line of code, that calls the message? Or add a code bracket, issuing automatically “User has clicked OK”. No big work, I assume.
As mentioned in the answer to the post on Answers.Microsoft.com linked above, we made some improvements to Office365 users so that this error message only shows once per Excel instance. This is based on customer feedback – the design change prevents it popping up multiple successive times when the clipboard is locked. We have also considered never showing the error dialog, but there was user feedback that this message is informative and helpful in some cases.
The comments here about disabling BeyondCompare clipboard comparison worked for me! Hallelujah! I love BeyondCompare and use it all the time, but never the clipboard comparison. Problem solved :)
It'll be back greg.
Greg Shaw commented
Turned off Live Preview and that didn't work. Saw someone's post below about restarting Windows Explorer and noticed I had two instances of Windows Explorer open and closed them. After that, the message and the aggravating pause before the message went away.
Turning off live preview didn't work.
8 GB Ram don't work.
Turning off any other programm didn't work.
Running 25 other programs didn't work neither.
The only thing that works ist: Uninstall MS Office and use any other freeware/open source office programs.
Good ole microsoft, so many problems and errors when anyone could really spot these with just one eye.
Turning off live preview worked for a few days, but now the problem is back.
Excel 2016 is such a backward step from 2010 - it's awful in so many ways
David Danson commented
turning off live preview also worked for me.
1. Run clipbrd.exe (for win10, you need download it) and keep it running.
2. Clear excel's clipboard.
There is a comment from Brian saying to 'turn off Live Preview' in Excel Options/ General. This worked for me - finally after years of stupid frustration with this problem someone came up with a simple solution. Why has this taken so long ??
I will second the below comment, i would like to put my years wage on his years to find any single person that finds the error message of any use at all.
If the app knows a problem has happened how about invoking something that fixes the problem rather than just shrugging and saying "yeah theres a problem just deal with it" how about automatically fixing it or keep copying until the problem has gone because when you copy and paste the next time the problem isn't there.
This error message needs removing without a doubt.
Still waiting on a solution for this useless "feature".
I feel like enough time and enough complaints have come to spur some sort of movement from Microsoft. I would really like to see the scenario where people find this message useful. I would bet a year's salary this scenario is a vast minority to every situation where it is burdensome.
Yes they need to scrap this message it is pointless.
This is driving me crazy because I sometimes have the program freeze with this. I only have other Office programs open at the time. Come on. This is expensive program folks. Basic functionality!
I have this problem all the time - drives me nuts!
...even if Excel is the only app running.
After opening Excel, cutting and pasting cells works the first time but after that, I get this pointless and time wasting message every time.
Spent ages with Microsoft support and got nowhere - even reinstalled my whole OS but still have the same problem.
Finally they said it's a known issue and pointed me here to vote for it - what a fantastically unsatisfactory solution!
Just fix it Microsoft!
I get the error when I have the Popgame Bejeweled 3 open! I've tested this over and over and sure enough, when Bejeweled 3 is closed, I don't get the error. If I have Excel and Outlook open, and Bejeweled 3 closed, I don't get the error. But as soon as I open Bejeweled 3, whether Outlook is open or not, I get the clipboard error in Excel every time I try to copy/paste cells. It makes no sense to me as to why this error is happening when I open the game, but it is!
@UweHa Sorry to hear that. It worked for me, and I am using a clipboard manager (which I imagine is why I was having the problem in the first place.) It seems like the solution to this issue depends upon which particular program you have accessing your clipboard.
just it solved with me thru the task manager>restart windows explorer
Continues to be an absolute irritant - does nobody in Microsoft give a **** anymore?
@Anonymous (February 13, 2018)
i also have beyond compare.
i stopped the clipboard comparison running on background (which i didn't even know was running in the first place)
and low and behold, that very annoying message disappeared!
i can now move cells, copy and paste, and merge (i also had the issue while mergeing cells!)
thank you for pointing this solution
i suppose that for people not using beyondCompare, they have to look for an application that continuously accesses the clipboard... and prevent it from starting.
@ Brian: that has no effect on the above mentioned problem of Excel running amok when another program peeks into the clipboard.
Just tested it and got the bad outcome only when dragging cells around.
Not anymore with Ctr+C or Ctrl+X or the Format Painter.
I don't know since when it is this way, because I have the clipboard surveillance of my telephone program shut off since I identified it as the trigger for this Excel bug.
MS Office Professional Plus 2016, Ver 1802, Build 9029.2253 click and run