How to Use Excel AutoRecover and AutoBackup Features

It’s always a terrible tragedy when someone loses something critical they were operative on since they didn’t save their request properly. This happens some-more mostly than we would cruise to Excel and Word users!

Luckily, Microsoft has combined a lot of facilities in a final integrate of versions that assistance revoke a chances of losing information due to crashes, energy outages, random deletions, etc. One underline is called AutoRecover and a second, less-commonly famous feature, is called AutoBackup.

In this article, I’ll speak about how to configure both options so that your information is as protected as possible. we would also like to discuss that a latest versions of Office concede we to save papers directly to OneDrive, that is a good choice to cruise since you’ll still be means to entrance your work even if your tough expostulate fails.

Excel AutoRecover

The Auto Recover underline is incited on by default and fundamentally saves your request automatically into a proxy plcae after a set time interval. To view the AutoRecover settings, click on File and afterwards Options.

file options excel

Click on Save in a left-hand menu and you’ll see a AutoRecover choice under Save Workbooks.

autorecover options excel

By default, AutoRecover information is saved each 10 minutes. In further to a interval, Excel has to be idle for 30 seconds before a information will be saved. Also, a autosaved information is saved in a AutoRecover record location listed here. So how does it work? Basically, let’s contend we have a worksheet like a one next and we have it saved.

test information excel

Now let’s contend we supplement a following information to a Excel spreadsheet and wait about 10 mins though saving my document. Since a AutoRecover interlude is set for 10 minutes, we need to wait during slightest that prolonged for a information to be saved.

added information excel

In my case, we unnatural an Excel pile-up by opening a charge manager and murdering a Excel process. After that, we reopened Excel and immediately saw an choice called Show Recovered Files.

show recovered files

If we click on that, it will move adult a list of Excel files that can be recovered. In my case, it had a strange file, that had information in only A1 and A2, and it also had a AutoRecovered file, that enclosed a information that we had not saved to disk.

document recovery

Clicking on any of a equipment in a list will open another instance of Excel display a information in that sold file. Overall, this is a unequivocally useful underline for those times when we didn’t save all your work, though Excel ends unexpectedly.

The vital downside to this underline is that a AutoRecover information is stored on a same tough expostulate as your file, so if something happens to your tough drive, all will be gone. You can change a plcae in a settings above to a apart tough expostulate or even to a network location, that we rarely recommend.

Note that AutoRecover information is also deleted automatically by Excel in a following circumstances:

  1. You save a record manually or by regulating FileSave As.
  2. You tighten a record or quit Excel (whether we save a record or not)
  3. You spin off AutoRecover totally or for only a workbook

So basically, whenever we save a file, it gets absolved of a AutoRecover data. In addition, if we manually quit Excel and select not to save a data, it will undo a AutoRecover data. Just keep that in mind when regulating this feature. If we are a complicated Excel user, we would advise environment a AutoRecover interlude to something like 2 or 3 mins instead of 10.


Another underline that not many people unequivocally know about it is AutoBackup. To use it, we have to initial go and save your record to get to a Save dialog box. If we already have a saved Excel document, go to File and afterwards Save As and select a location. When we do this, it’ll move adult a Save As dialog.

save as excel

In a dialog, click on a Tools symbol that is to a left of a Save button. You’ll see a integrate of options, one of that is General Options. When we click on that, a tiny window will seem with some some-more options.

general save options

Go forward and check a Always emanate backup box. Click OK and now when we save a file, an Excel backup record will also be combined with a .XLK extension. Note that a initial time we do this, a files will be accurately a same. If we make edits to a strange record and afterwards save it again, a backup record will still sojourn a same (the strange data). The third time we save it, however, a backup record will be updated with information adult to a second save.

Basically, a backup record is always one chronicle behind a stream version. So if we done a garland of changes, saved your record and afterwards wanted to go behind to a chronicle that didn’t have those changes, we could only open a backup file.

The record is saved in a same plcae as a strange record and there doesn’t seem to be a approach to change that. This underline doesn’t supplement a whole lot of reserve to your document, though it’s good in certain circumstances.

Enabling these backup and liberation facilities in Excel will hopefully save we from losing critical data. It’s always a good choice to use cloud storage (like OneDrive) as an additional reserve net in box your mechanism catastrophically fails. If we have any questions, feel giveaway to comment. Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *