How to AutoRecover Excel File in Excel 2019 or Office 365?

It can be very shocking to lose important data or a file while working. And, more disappointing is that you didn't save that document before losing it. Unfortunately, this situation often occurs when you work in Excel or Word. This is where AutoRecover Excel comes handy.

Fortunately, Microsoft has introduced various features to help you. These features allow you to reduce the possibilities of data loss because of a system crash, accidental deletion, power outrage, etc.

It has some exciting and helpful features, such as AutoRecover and AutoBackup. So, you must configure both of them so that you can save your data. In addition, the latest Microsoft Office versions save your files directly to the Onedrive.

As a result, even if your hard drive crashes, you still have access to your documents through Onedrive. Let us understand some more about these features.

Part 1: AutoRecover Excel 2019/365 - Excel Saved At Least Once

Suppose you save a file once while working, but you accidentally close it and click on the "Don't Save" button. Or your excel crashes when you are working on any document.

 Clicking on Don't Save Button

In such a case, follow the steps mentioned below to auto recover excel on windows 10:

Step 1: First, open the Microsoft Excel file.

 Opening the Excel File

Step 2: Go to the "File" tab and look for the "Info" option. Then, click on it.

 Clicking on Info Option

Step 3: Look for the "Manage Workbook" option, and click on the last autosaved File.

 Clicking on Last Autosaved File

Part 2: AutoRecover Excel 2019/365 - Excel That Was Never Saved!

 Accidental Click on Don’t Save Option

Note: Microsoft Excel will notify you if there is a recent copy available or not.

Suppose you never saved a file you are working on, but it accidentally crashes, or you mistakenly click on the “Don’t Save” option. To recover the last autosaved File, follow the steps below:

Step 1: Open the Excel document on your system.

 Open the Excel Document

Step 2: Clik on the “File” tab and look for options. There click on the “Info” option.

 Click on the Info Option

Step 3: Go to the “Manage Workbook” tab and click on the “Recover Unsaved Workbooks” option.

 Clicking on Recover Unsaved Workbooks

Step 4: Then, click on the last autosaved excel file.

Versions

While working on an Excel file, you can look for all previously auto-saved documents below Manage Workbook.

Step 1: Press on the "File" tab and look for the "Info" option.

Step 2: You can go to all the previous versions of your Excel file at any time.

 Looking for Previous Versions

Note: All previous versions get automatically deleted once you close the Excel file.

Options

If you want to change the AutoRecover options, follow the steps below:

Step 1: Go to the "File" tab and click on the "Options." Then, find the "Save" option and click on it.

 Clicking on Save Option

Part 3: Bonus Tips- How to Auto-Backup Excel?

Accidental deletions or crashes can ruin your hard work, especially if you do not have file backup. Excel's Auto Backup feature will allow you to keep data safe by saving all the previous spreadsheet versions. Lets us understand how to use it.

Tip 1: Ctrl+S

In Microsoft Excel, the Auto Recover is by default o. So, it saves your files automatically after a specific time interval in the temporary location. To find and see the AutoRecover settings, follow the steps below:

Step 1: Go to the File tab and click on the “Options” list.

 Clicking on Options

Step 2: You can look for the “Save” option in the left-hand side list under Options. Click on the “Save” and find the “AutoRecover” option under Save Workbooks.

 Finding AutoRecover Option

Step 3: In Microsoft Excel, your File automatically gets saved after every 10 minutes. You can see the autosaved data under the AutoRecover file location.

 Looking AutoSaved Data

Step 4: Once you add the data to the spreadsheet, wait for 10 minutes without saving the document. As auto recover time interval is by default set for 10 minutes, you have to wait for atleast that long to get data saved.

 Adding Data to Spreadsheet

Step 5: You can also simulate the crash of an Excel file by opening the task manager and ending the Excel process. Then, reopen the spreadsheet and see the “Show Recovered Files” option.

 View Recovered Files

Step 6: Once you click on the “Show Recovered Files,” it will display a list of Excel files that you can recover.

 Looking at Excel Files List

If you tap on any of the items on the list, it will open an Excel instance representing that particular file's data. Overall, it is a great feature to solve problems when you didn’t save your work, but Excel crashes unexpectedly.

The major drawback of this feature is that the AutoRecovered data gets stored in the same hard drive. So if something occurs to the hard drive, you will lose all files.

It would be best to change the location in the settings to separate the hard drive location.

Note: AutoRecover information gets deleted automatically by Microsoft Excel under the following scenarios:

  • You manually save the File or by using the option “Save As.”

  • You close the Excel file without checking whether you save it or not.

  • You turn off AutoRecover just for the workbook or wholly.

Therefore, when you save a file, it automatically deletes the AutoRecover information or data. In addition, if you close the spreadsheet manually without saving the document, it will destroy the AutoRecover data.

Tip 2: Perform Auto-Backup

Most of you do not know about the AutoBackup feature. To use it, follow the steps below:

Step 1: First, save the file to see the Save dialog box. If you have already saved the Excel sheet, go to the File and then to Save As. After that, choose a location. Once you do this, it will show the “Save As” dialog.

 Looking at Save As Dialog Box

Step 2: In the dialog box, click on the “Tools” button on the left side of the “Save” button. You will find some options. Next, click on the “General Options” to open a small window with some more options.

 Looking at More Options Under General Options

Step 3: Now, check the “Always create backup” box. Then, click on the “OK” button. Now, when you save a spreadsheet, it will create a backup file with a .xlx extension.

Note: When you first time saves a spreadsheet, files will be the same. If you make editions in the original document and then again save it, the backup sheet will remain the same.

However, the third time after saving the file, it will update the backup sheet with data up to the second save.

So, the backup document is one version behind the current one. Therefore, if you make some changes and save your file, then wanted to go to the version without the changes, you can open the backup document.

You can see the saved spreadsheet in the exact location as the original one, and there is no way to change that.

Conclusion

When you enable the backup and recovery features in Microsoft Excel, it will save you from losing some critical data or files. So, it would be best to use cloud storage, such as OneDrive. You can find autorecover excel files from there.

It acts as an extra safety net whenever your computer crashes or catastrophically fails. Moreover, you can quickly open and save the OneDrive documents from Excel. In addition, Microsoft Excel and OneDrive work together to sync files faster with autorecover excel file feature.

In addition, they allow you to work with different people at the same time on shared documents. For example, when you and someone else make changes in a spreadsheet, OneDrive tracks the versions automatically. So you do not have to store multiple copies of the same file.

Other popular Articles From Wondershare