by Allen Wyatt
(last updated March 17, 2018)
When Rod is working with Excel, he sometimes receives an error message stating "There's a problem with the clipboard, but you can still paste this content within this workbook." He wonders what causes this message and how he can get rid of it.
This is an odd little error message that, it seems, doesn't have a lot of purpose in Excel. As noted in the error message, if you can still paste the contents of the Clipboard, then the message is nothing but purely informational (as it doesn't really impede Excel). Even though it seems informational, it still slows down the use of Excel.
The message is apparently caused if you try to use Ctrl+C, Ctrl+X, the Format Painter tool, or a drag-and-drop operation and Excel detects that the Clipboard is locked by a non-Office application or, in some cases, simply accessed a non-Office application. You can find through a search of the Web that this problem has affected many users. (I did a search for "there's a problem with the clipboard, but you can still paste"—with the quote marks—and found lots of discussion about the issue.)
It also appears that this problem has been around for quite some time and that Microsoft has been playing whack-a-mole trying to track it down and fix it. Different reports indicate that it first cropped up in Excel 2013, but most experienced it beginning with Excel 2016. A potential fix that has worked for some people is to follow these steps:
Figure 1. The Excel Options dialog box.
If you experience the error and the above steps don't fix it, we may need to be content to know that Microsoft is aware of the problem and is trying to get it fixed. (I know that knowledge doesn't provide a whole lot of contentment to those experiencing the problem; it can be very frustrating.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10691) applies to Microsoft Excel 2013 and 2016.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Jumping to the last cell in a worksheet should be easy, but you may not always get the results that you expect. This tip ...Discover More
Excel displays, by default, a row label or heading at the left side of each row on the screen. As you scroll down the ...Discover More
Reports and other formal documents are often distributed in PDF format so that they can be read and printed on a variety ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.