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.
Mine is cause by virtual box. I've copy paste bidirectional enabled
Lorein Watson commented
You can export them to the Settings > Options tab with the "Export Settings" button.
or else use this: http://www.repairmsexcel.com
When do you fix this, Microsoft?
The clipboard surveillance It is a feature of the telephone program (probably). How can I know about your telephone's features?
"Not everyone is lucky as I am to identify the cause (telephone) and be also able to switch off its feature "clipboard surveillance"
How do you do this? You could make a lot of peoples lives much much better! LibreOffice is okay but I'd still like to go back to Excel.
This is such a bug! I am amazed that Microsoft has not pulled the plug on the code that causes this! It is a totally worthless message that NEEDS to be removed so you don't have to constantly - yes constantly click the ok because it does it multiple times in a single session! In the above message it says, "Not everyone is lucky as I am to identify the cause (telephone) and be also able to switch off its feature "clipboard surveillance"." - Microsoft should at least - at least - provide instructions on how to turn off Clipboard Surveillance...
I'm having trouble with this too. Now I have to use LibreOffice as my spreadsheet software but would rather use Excel. Microsoft, listen to these comments. No one other than Microsoft has defended this feature. Take it off NOW!!!
I tried closing Outlook and all other open apps to no avail. After closing Excel and not being able to re-open, I ended up having to restart my computer and it opened. I was then able to copy correctly. Very irritating, though.
Tom Fort commented
It stopped happening for me when I closed Outlook 2016, which was running at the same time.
seriously ridiculous you must not use excel, Microsoft, or you wouldnt tolerate this annoying popup every time
I have this error when cutting and pasting primarily.
However Excel crashes whenever the error appears, losing all work. This is a serious irritant.
No. It doesn't affect the problem triggered by a telephone programm, surveiling the clipboard.
I did go to options > General and uncheck the box "Enable Live Preview" and has seemed to solve the problem for now.
I have the same problem, Excel won't operate properly (not responding) after this error message and I have to close/restart. I spend EVERY DAY copying and pasting in Excel. Microsoft wake up and fix this nonsense
I also have the problem that after the error the active cell or cells no longer are highlighted, I have to save, close and reopen the file to fix it. I did go to options > General and uncheck the box "Enable Live Preview" and has seemed to solve the problem for now.
Update. My solution of 5 June 2017 was short-lived. The problem has returned.
C. Weeks commented
I just started getting this problem today, everything was working fine yesterday. Now it is taking me ages to use Excel. I can copy and paste in all other programs OK, even other office progs. This MUST be a bug with Excel.
Microsoft, WAKE UP!
Over 4 years of sleep are enough.
This is the most annoying error in Excel. When I am moving cells around instead of it taking 2 minutes I have to spend 15 minutes on a simple task because I have to wait for an error prompt AFTER EACH MOVED CELL!
G. Dennis Long commented
Had power supply and memory problem. Microsoft Office was remove. Windows updated. Then Microsoft Office reinstalled to Version 1705 (Build 8201.2102). This happened on 14 June 2017.
Opened an Excel file that I always am working on every day. Started a cut to paste in a different part of the spreadsheet and got the dreaded error box, "There's a problem with the clipboard, but you can still paste this content within this workbook."
Windows 10 64 Pro / Office 365 Personal
Microsoft, PLEASE fix this annoying problem. Unfortunately, I am stuck with Microsoft.