Controlling Automatic Backups

Written by Allen Wyatt (last updated November 10, 2018)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365


11

Excel includes the ability to save automatic backups of your workbooks, and this can be controlled on a workbook-by-workbook basis. If your system is configured to create backups automatically, you may want to modify whether a backup is created for a particular workbook. In order to turn it off for a specific workbook you need to follow these steps:

  1. Display the Save As dialog box. (Easiest way is to press F12.)
  2. Click the Tools option in the lower-right corner (near the Save button). Excel displays a drop-down list.
  3. Click General Options. Excel displays the General Options dialog box. (See Figure 1.)
  4. Figure 1. The General Options dialog box.

  5. Make sure the Always Create Backup check box is cleared.
  6. Click OK.
  7. Continue saving your workbook.

Following these steps affects only the current workbook; other workbooks remain unchanged in their behavior.

One thing that should be noted when working with Excel—it is easy to confuse automatic backups with AutoRecover. These are not the same. AutoRecover is a way to save temporary information, between "hard saves," so that you can recover a workbook on which you are working if the power goes out. Automatic backups are copies of your workbook saved whenever you save the workbook itself. (These backups are stored in the same folder as the original workbook being backed up.) Since AutoRecover and automatic backups are two different features of Excel, changing the settings of one feature doesn't affect the other at all.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3884) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365.

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

Shortcut for Full Screen Reading View

Want to get rid of almost everything on the screen except your document? Here's how to easily maximize what you see.

Discover More

Inserting a Paragraph from within a Macro

Macros are often used to process documents, resulting in changes of one manner or another. If you need your macro to add ...

Discover More

Changing the Underline Color

Word provides quite a bit of latitude when it comes to formatting your underlines. This tip looks at how to best change ...

Discover More

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!

More ExcelTips (ribbon)

Weird Mouse Shortcut

If you like to use the mouse in your worksheet navigation efforts, you'll want to pay attention to this tip. Here you ...

Discover More

Closing Excel when Closing the Last Workbook

Have you noticed that when you close the last workbook in Excel, the program window itself often stays open? This ...

Discover More

Understanding Relative and Absolute Addressing

In Excel you can reference a cell in a formula by entering the coordinates for the cell you want to reference. This can ...

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}] (all 7 characters, in the sequence shown) 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 4 + 0?

2020-01-17 21:06:58

Peter Atherton

Anne
This is it in Excel 2016, Click the drop-down box on Tools


(see Figure 1 below)

Figure 1. Save Tools


2020-01-17 10:07:09

J. Woolley

@Anne
I see it in my Excel 365 Version 1912.


2020-01-16 03:35:56

Anne

Was this removed in MS Excel 2019??? I don't see the box for Always create backup anymore. All of a sudden, my file isn't backing up :(


2019-05-29 16:54:54

Sharon Emmerling

Step 4 says: "Make sure the Always Create Backup check box is cleared." Shouldn't it be selected (checked)?


2018-12-16 09:10:08

Jim Foote

Thank you all for your comments. I haven't found a macro that does what I want but I did find an add-in called AutoBackup.xla and it works with my copy of Office 2007, 2013, and 2016 (365) and functions exactly the way I want, allowing me to specify the interval of each backup, the destination folder (including my flash drive), the number of days the backups will be saved and the maximum number of backups. The only limitation is that the Excel file needs to be saved with an xlsm extension, which I don't view as a problem at all.


2018-12-15 17:34:02

John Mann

I also could not find anything in the Options settings to enable or disable automatic backup in Excel 2010. Some time ago, there were some tips for saving in 2 or more places at once using macros; "Saving in Two Locations", Tip T011265; "Saving in Multiple Locations", Tip T012495


2018-11-25 11:15:04

Hazel Kohler

My copy of Excel (Office 365) does not make auto-backups. In fact, none of the versions of Excel I have ever used made auto-backups, although I seem to recall that some years ago, there was an add-on that you could install that would allow you to turn this function on. Thanks to this tip I now know how to turn on auto-backup on a file-by-file basis, but how do I make it default behaviour? I've looked in File/Options, and can't find anything that looks right in there.


2018-11-13 10:00:46

Jim Foote

I'm not looking for Autorecover since i understand that the Autorecover file is erased when Excel is closed correctly. I'm looking for a way to save a copy of an Excel file via Auto Backup on a flash drive, which would remain intact when Excel closes and would be accessible if the entire computer goes south. Currently, Auto Backup saves to the computer hard drive. If the hard drive fails, goodbye Excel file.


2018-11-12 10:51:09

David Gray

For me, this tip was a twofer. Not only did it call out the fairly well-hidden backup option, but it brought to my attention that F12 opens the Save As dialog box straight away.


2018-11-11 16:36:02

Allan

Jim,
This is for Excel 2007.
1 If you already have a folder that you want these to be placed in continue on to step 2. If you don't have a folder, create one. For instance, I have a
Desktop folder named "Al's Excel Autorecover". All of my Autosaved and Autorecover Excel items automatically go here.
2 Open your Excel Workbook
3 Office Button
4 Excel Options>Save
5 Type in "Autorecover file location:" whatever location you chose in step 1 OK


2018-11-10 07:08:12

Jim Foote

How do you save automatic backups to a folder different than the one the original workbook is in?


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.