You may come across a “Picture is too large and will be truncated” error message when trying to copy and paste rows, columns or tables in Microsoft Excel. This is quite a common issue that is not directly attributed to Excel – rather it’s caused by a running 3rd party application that’s interacting with the Windows clipboard.
An example of such software may be a clipboard manager utility or remote desktop software. Given that any software that hooks into your clipboard may cause the issue, the only way to identify the specific application is by method of trial and error. The most straightforward method for this would be to close each application running on your taskbar one by one, and trying to copy/paste the Excel rows. If the problem persists, the next step would be to individually close each application running in your system tray.
Looking for an easy solution to fix Windows issues remotely? SetMe is a remote support powerhouse that allows you to securely connect to any remote PC in just 3 easy steps.
As soon as you identify the software that’s causing the error, contact its developer and share the below instructions with them:
Information for developers:
If your application interacts with the Windows clipboard using OLE technology, this indicates that somewhere your source code calls of the IDataObject interface. This interface contains the GetData method, which can result in the described Excel error when it tries to receive clipboard content in CF_METAFILEPICT format.
How to fix:
Skip the GetData call if the requested format is CF_METAFILEPICT.
Did you find this article helpful? See more Windows tips & tricks on our blog and join us on Facebook, Twitter or LinkedIn to receive all the latest news, posts and updates.
Check out SetMe, our brand new remote desktop solution that makes connecting to remote computers easier than ever before, and be sure to sign up for a fully-featured 30-day free trial:
Learn More About SetMe