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.

Clearing Large Clipboard Entries

by Allen Wyatt
(last updated April 25, 2015)

1

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:

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

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Understanding DATE Field Formatting

One of the most commonly used fields is the DATE field. You can specify how the DATE field displays the current date by ...

Discover More

Understanding the Hot Zone

Need to hyphenate your document? Then you need to know about the hot zone because it controls how words are hyphenated

Discover More

Differences between SEQ and LISTNUM Fields

Word provides several different fields you can use for custom numbering in a document. Two of the most commonly used are ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (ribbon)

Using More CPU Power when Calculating

Today's PCs are more powerful than ever, but you can still have slowdowns when it comes to calculating large workbooks. ...

Discover More

Arranging Workbook Windows

If you find yourself working with a number of different workbooks at the same time, you may want to arrange your desktop ...

Discover More

Changing the Color Used to Denote Selected Cells

When entering data into a range of cells, the cell in which you are working appears in a different color than the other ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight minus 3?

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??


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.