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.
Disabled web download manager running in the background (e.g. EagleGet), which is monitoring the clipboard.
Angie Iloilo commented
I keep getting the “There’s a problem with the clipboard, but you can still paste your content within this workbook” message in excel, even when I drag content from one cell to another, super annoying when you are a heavy excel user!!
Microsoft doesn't give a $h!t
So Microsoft have deliberately created a fault in Excel to annoy users! Wonderful!!
god yes please disable this stupid message
The suggestion to turn off live preview has been made repeatedly in this thread.
While this relieves the symptoms of this useless message, it actually turns off other features that may be desired. As such, this is not a fix, but a bit of "redirection" better suited for magicians.
Microsoft - please FIX this!!
While dans suggestion is good it isn't the fix :(
Will Robinson commented
Thanks Dan.. Genius.. Worked a treat!
this problem went away for me when I unchecked "Enable Live Preview" on the "General" tab in "Options" under the "File" menu.
Will Robinson commented
This drives me insane.. any copy or paste function, short cut, paste special etc.. then locks up, the cursor vanishes, and takes an age to sort itself out.. make it stop!
This did NOT work for me. It's been posted before. Microsoft needs to fix!!
Denise Indoung commented
This did the trick for me:
Yeah! Nothing now works for me either – it had disappeared for a while but came back with last update.
I can only think that there is a would-be hacker/anarchist sitting in Microsoft getting a malicious enjoyment from our posts.
They sure aren’t listening.
Bobby Davison commented
I have Office 2019 on my home computer and Office 365 on my work computer. Both seem to work differently. I get the stupid error message on Office 2019, but I can Ctrl-c, Ctrl-v, Ctrl-v, etc. On Office 365 (which I dislike intensely) I don't get the error, but I have to Ctrl-c, Ctrl-v, Ctrl-c, Ctrl-v, I cannot multi-paste! Don't know if its related, but come-on Microsoft, fix this stupid message!!
Nothing in this thread has worked for me. Bottom line, Doug Pelland is right. Microsoft needs to fix this.
I have always had live preview disabled and I get this message all the time.
Also, I do not use drag and drop. I have it turned off so I don't accidentally do it.
Turning off live preview did NOT work for me. I get the error when dragging and dropping a range of cells. It only happens on some worksheets...unpredictable.
Doug Pelland commented
Turning off live preview might be one option, but it is not the best solution. The best solution is for Microsoft to fix this annoying issue.
Best solution is to uncheck enable live preview under options --> general
I tried solutions suggested here. Either they didn't apply to me, or the solution didn't work. In my case it usually happens with drag and drop. I'm running Win10 and Office 365. Please fix, Microsoft. Just get rid of the message.