Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Clearing Large Clipboard Entries.
Have you ever noticed that after you've copied a large amount of data to the Clipboard, and then you close Excel, you see a dialog box stating that "A large amount of data is present in the Clipboard. Do you want to save it before quitting?" You may get tired of seeing this message. If so, then there are a couple of things you can do.
First, you can replace the "large amount" with a "small amount." (Excel never asks if you want to discard a small amount.) To do this, just select a single cell in your worksheet and copy it to the Clipboard. The contents of the single cell replace the large amount of data on the Clipboard, and you can exit Excel without seeing the message.
If you'd rather have a macro approach, you can do the exact same thing in a macro—just select cell A1 and have your macro copy it to the Clipboard:
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Sub GoAway1()
ActiveSheet.Range("A1").Copy
End Sub
Another approach is to use a single-line macro that basically "disables" the Clipboard by canceling any current copy operation:
Sub GoAway2()
Application.CutCopyMode = False
End Sub
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10696) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Clearing Large Clipboard Entries.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you ...
Discover MoreIf your worksheet gets big enough, it is easy to spend a lot of time navigating back and forth between different areas. ...
Discover MoreNeed to understand who is using a particular workbook? There are a number of ways you can find out, as discussed in this tip.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-11-16 08:46:07
askahy
hi the message doesnt show up but did you notice there is a big amount of change in the size of the workbook ? i mean, i have two workbooks, one working fine and the other showing the dialog box of large amount of data... the one working fine (still the message is prompting though) which consists of 18 pages and 3 sheets and the other (which is my concern) have only 4 pages and 3 sheets but the size increases a lot when i copy one page to make a new page below it. (increase - im talking about is almost 35-40 KB) where as in the first one if i do copy and pasteing it increases only by 2 KB (content to copy in both workbooks are almost same) so that increase makes the workbook open late and it lags a lot. any suggestion??
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Comments