"There is a large amount of information in the Clipboard". No, there isn't.
After copying a smallish range to the Clipboard, if we try to close Excel we get a "There is a large amount of information in the Clipboard, do you want to empty it?" dialog. This is the most unnecessary dialog in the history of computing. It might have made sense back in Excel 5.0 times, but most desktop computers now have at enough ram to comfortably fit way more than 40 cells in the clipboard. I'd suggest a significant increase in this threshold, or completely doing away with it.
This message is a good way of allowing a program to completely close. There are many programs that do not clean up after themselves, so this message is an OK way to close - maybe they could delete the "large amount." I do not see this as a "bug," but was wondering why the commenters need to close Excel so often as to be annoyed by this; perhaps there is another underlying problem?
David Rodarm commented
I will frequently copy a row (which does NOT have a large amount of data) and then get this warning (oh my! oh my! what to do?) when I close the workbook. And if I'm not exiting Excel, why not just shut up and keep the data on the clipboard? Waste of my time, 99.99% of the time!
My major complaint with this message is that it's an example of something which originally was intended to help the user (by saving their computer's resources) but which now has the effect of hindering them (by wasting their time asking a completely unnecessary question).
It's annoying, probably a bug in most instances and yet another example of bad MS UI
Larry Tavares commented
Since this is a bug in the system not sure why it needs votes to fix. I read earlier workaround things to do but they were all hocus pocus including reinstalling office outlook. And what would that have to do with an excel bug?
Larry Tavares commented
There is a bug in the copying and pasting especially if you use paste special (width). I'm constantly using this feature and it locks the file inconsistently and I cannot continue unless I save and exit the file to continue. I waste lots of time in doing such a simple task. Never had this problem in earlier versions of excel. Earlier versions would flag/warn you about the clipboard but you could ignore it and it would continue to work correctly.
Kenneth Barber commented
Is the issue about freeing RAM or is it about retaining/losing potentially important information? But yeah, that dialog can be annoying sometimes.
If you want something more useless than that, see this:
Desktops and laptops.