Clipboard problem in Excel 2016

Anonymous
2016-04-16T23:39:19+00:00

I am running Excel 2016 on a Windows 10 Machine.

When I copy a cell (or cut a cell, or move a cell) I get one of two error messages:

"Cannot open the Clipboard"

"We couldn't free up space on the Clipboard.  Another program might be using it right now." 

I am then able to successfully paste what Excel told me it could not copy.  To restate for clarity...Excel throws error messages, but I am able to successfully copy and paste.

The problem is that it throws the error messages every single time I try and copy or cut or whatever.

Things I have tried:

I've ensured all other programs are not running (or using the clip board)

I've cleared the %temp% folder

I've cleared the Clipboard within Excel

Word does not have this problem...

Please help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2017-02-28T16:18:02+00:00

Hello,

I have an update on this error dialog: “There's a problem with the clipboard, but you can still paste your content within this workbook."

When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard.  In this situation you can still paste within Excel.  However you cannot paste to another app like Word or Outlook which uses the clipboard.

Last year 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. 

We hope this helps shed some light on this error message.  For any design suggestions or new ideas on improving the Excel copy-paste experience, please post to Excel UserVoice.

Was this answer helpful?

70+ people found this answer helpful.
0 comments No comments

255 additional answers

Sort by: Newest
  1. Anonymous
    2018-03-11T17:05:25+00:00

    But how does this help solve the problem? I get a message every time I try to make an Excel entry. Today I have to do hundreds, and you are explaining to me your improvements to Office 365!!!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-03-08T16:16:39+00:00

    Now I am getting this error every once in a while. I have saved the spreed sheet. Maybe have opened another one, because I need both for right now. Then I go to close the first spreed sheet and I get "The picture is too large and will be truncated." Hit the ESC key a couple of time to close the error & the spreed sheet.

    I would post the picture but I do not see anyplace to do that.

    Microsoft Excel, WHY don't you get this program fixed???

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-02-23T16:14:12+00:00

    I posted input to this about a year ago -- just refreshing for the folks who visited here recently.

    While we wait for Microsoft to address this (I think we will be waiting a long time), I have found a solution to "my" instance of this. I say "my" because it could be different for others -- but the root cause will probably be similar.

    I use Beyond Compare to conduct file/folder comparisons. This program has a feature to "monitor the clipboard." Beyond Compare's monitoring of the clipboard causes Excel to misbehave as described in this thread. I do not believe this is Beyond Compare's fault -- there are other clipboard monitoring programs that cause the same problem with Excel as evidenced in this thread. 

    The trick is to find the one that you are using (It seems Outlook is a frequent one as is Beyond Compare) -- the "trigger" program/service.

    Finding the "trigger" program is a trial and error process -- close everything and turn off any background services you can until Excel behaves. Then one by one bring other programs and services back until Excel misbehaves.

    Once you find the "trigger" program -- look for a feature within it to "turn off clipboard monitoring" -- Beyond Compare has this whereas I don't believe Outlook does.

    If you have the option to turn off monitoring, then doing that should solve the problem -- it did for me with Beyond Compare. I don't use Outlook.

    If you can't turn off the clipboard monitoring, then you will have to either shutdown the offending program when you are using Excel or switch to an alternative program that does not monitor the clipboard (e.g. move from Outlook to another mail client program). 

    Or you can continue to live with the frustrating behavior if it is not impacting you terribly -- I could not live with it.

    Fred

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-02-23T15:33:53+00:00

    I switched from Outlook to Thunderbird and it helped.  The error still pops up every once in a while, but with Outlook open, it happened every time.  Thunderbird is not nearly as robust as Outlook, but Excel is more important for me, so I had to make the switch.

    Was this answer helpful?

    0 comments No comments