Fix the "There's a problem with the clipboard" issue
The issue with "There's a problem with the clipboard..." while copy and pasting is still as issue. I was using Office 2010 and there was no problem. I am now using Office 365 and this issue is prevalent. It manifests itself when pasting a value from a cell containing a formula and disappears when disabling Live Preview. I was able to copy and paste "normal" cell contents fine before the error message appears so the official response of "another program has locked the clipboard" doesn't really hold up. It looks more like Excel has locked the clipboard from itself.
There is no reason for this issue to have hung around as long as it has and it really should be fixed, especially if Microsoft wan't to keep selling Office as a subscription.
Please fix this ASAP. The fact that I am not able to use a clipboard to copy content between separate instances of Excel or between Excel and other applications is just ridiculous. It is unbelievable that fixing such a basic functionality takes so long. I am running the latest Win10 (1903) and the latest Office365 (1905). Thank you.
Please Fix This.
Stephen Goodman commented
The explanation provided at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/theres-a-problem-with-the-clipboard-but-you-can/6720299f-1084-4104-93cc-abee9dcf7469 is that another application locks the clipboard:
"When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard."
This is easily disproved by not using the clipboard in other applications. I know for a fact that when this issue occurs only excel is using the clipboard, therefore excel "has a lock on the system clipboard" preventing itself from using it.
Someone provided guidance on why this is happening at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/theres-a-problem-with-the-clipboard-but-you-can/6720299f-1084-4104-93cc-abee9dcf7469 Unfortunately, "Last year we made some improvements to Office365 users so that this error message only shows once per Excel instance" simply isn't true. I am moving a whole block of cells one at a time and I sometimes get the error 3 times in a row, every other time, or some other random interval. So far I've seen the warning message ~10 times! This regression to functionality that started in Windows 1.0, 2.0, 3.0 is maddening. I'm running Excel 365 (current version as of 4-18-19) on Win10 1809. Both Win10 clipboard features are turned Off.
I also see this continuously. Even with the feature where one drags the cell to copy it. I get a warning that the clipboard is full even if I just cleared it. I agree with the Stephen Goodman comment Nov 26 2018, Excel is in conflict with itself. This conflict effectively removes the drag-cell-to copy feature. I find the only solution is to "cut" and "insert cut cells" to obviate this issue. Please look into this. I have no perspective on when this was introduced. This is an issue on my personal Office 365 account and the Office Standard 2106 product.
At first, I was encountering this issue occasionally, and I really could continue pasting within the spreadsheet. Now the problem happens every 10 to 15 minutes, and the only thing that I can do is close down Excel and reopen it. It won't allow me to continue working at all, much less copy/paste. I despise Office 365, would get rid of it in an instant if I could go back to a desktop version. This software defect causes me an incredible amount of lost time and irritation. Microsoft, if you don't fix it, some other enterprising company will fill the void with a new solution. Your customers are clearly fed up with your inability or lack of prioritization to fix this defect.
I concur with what everyone is saying here and elsewhere. Fix the **** problem, Microsoft. I tried the "disable live preview" trick and the stupid error still pops up on 70 to 80% of my copy and paste operations. I have literally lost at least an hour in lost productivity to this error just in the one spreadsheet I'm working on over the course of the last day and a half.
Oh, and the message posted in the forum that was locked on this topic is bs as well. The error does not just pop up once per Excel instance and then go away. As I noted above, it shows up on 70-80% of my copy/paste operations.
Here's a simple fix...and I don't know why the software developers at Microsoft can't come up with this on their own. If you want to hold to your bs line about some users finding it useful and therefore needing to keep the stupid error in the program, how about adding a little check box to allow the user to say "Never show this error message again". Problem solved!
I agree - Microsoft needs to address this problem. I've searched everywhere for a solution. My Office 365 is completely up to date - Gee, I sure am glad I spent the extra money on Office 365 instead of just keeping my old Excel 2010 which worked just fine!
"Perhaps someone could direct to a discussion where this has been tackled, but I keep getting this error "there's a problem with the clipboard, but you can still past this content within this workbook " with simple cut/copy and paste actions in Excel. The error box pops up and an alert sounds (which is super annoying) after every paste. I can still perform the actions however my selection is not highlighted and I can't be sure that I have selected the correct information until I do a paste in the same,or another, worksheet. I have Excel 2016 in Office 365 on a machine running Windows 10."
I posted this in November 2016 in the appropriate Microsoft Community and to this day there are regular responses and comments at the issue not having been resolved (over 35,000 views and over 200 responses. It is still happening. However today someone called 'Nathan Roberts (SunkNath) apparently a moderator, has decided to lock the thread deciding that coming here was the only way forward. Is there anyone here who has a clue about this? Two years on and Stephen Goodman is posting the same problem. Want to know how to improve Excel for Windows? Come up with a solve for this problem.