Excel Autorecover How To Find Recover Unsaved Excel Files

Excel AutoRecover

For example, suppose an instant digital disaster strikes and the program that contains important information closes unexpectedly. Microsoft Excel addresses the problem through an AutoRecover feature that allows Excel to capture the snapshots of your workbook while you work. These work-related snapshots contain workbook data and states that make it possible for Excel to reopen your workbook later after a crash takes place.

Built-in AutoRecover & AutoSave Options in Excel

In Excel, we have two important features. One is “Autosave,” and another is “Auto Recovery.” Do not get confused with both. I will tell you the differences.

AutoSave in ExcelAutoSave In ExcelAutosave in excel is a function/facility to save the changes or progress of work automatically. This helps us reduce the impact of risk of data loss in any crash situation in the system. We can manually set the time to save the progress automatically.read more: As the name suggests, it automatically saves the file or workbook. It keeps every specific minute according to the settings we make.Auto Recovery: This is slightly different than the previous one. Unlike autosave, we cannot save anything. Instead, retrieves the unsaved if it is closed due to a sudden computer crash, power loss, Excel not respondingExcel Not RespondingWhen the Excel software hangs or freezes in the middle of a task, the “Excel no responding” message pops. There are multiple reasons which leads to such errors and there are multiple ways to troubleshoot his problem as well.read more, etc.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: AutoRecover in Excel (wallstreetmojo.com)

Condition for Auto Recovery in Excel

There is a condition to auto-recovery in an Excel option. It only recovers saved files only. One should save the workbook at least once in the system or computer. If the file is saved and crashed when you open the new or existing workbook, it will show you the Document Recovery Pane in ExcelDocument Recovery Pane In ExcelWhen an Excel document crashes unexpectedly while being worked on, certain amazing Excel workbook recovery techniques such as ‘Recover Unsaved Workbooks‘ and ‘Autosave‘ options come to the rescue of users.read more on the left-hand side of the newly opened Excel sheet. It will list out all the crashed Excel workbooks.

You can select which one to recover and which ones to ignore by clicking on that workbook.

How to Enable AutoRecover & AutoSave Options in Excel?

Go to the “File” tab. Next, go to “Options.” Under “Option,” go to the “Save.” You may see ” Auto Recovery ” options under “Save” on the right-hand side. In addition, you may see “Auto Recovery” options.

Recover Unsaved Excel Files

Suppose you have worked on a file for some time and forgot to save it in the first go but closed down the workbook by accident. Do not worry. We can recover unsaved workbooks in ExcelRecover Unsaved Workbooks In ExcelRecovering unsaved Excel files means recovering the unsaved files after any accidental closure or crash and allowing to restore the last saved version displayed in the Document Recovery pane on the Excel next time.read more. Follow the below steps to recover unsaved workbooks.

Step 1: First, we must click on the “File” tab.
Step 2: Next, we must select the “Open” option. Under this, choose a “Recent Workbooks.”
Step 3: We could see all the recently opened workbooks’ names on the right-hand side. We could see about 25 to 30 recently opened workbooks in chronological order.
Step 4: We will scroll down and select “Recover Unsaved Workbooks.”
Step 5: Now, we can see the unsaved workbook lists. We will select the required workbook.
Step 6: As soon as we click on the file, it will show the prompt as “Recovered Unsaved File” just above the formula bar. Then we will click on the “Save As” option to save it.

Recover Older Versions of Excel

Assume that you are working from 5.00 a.m. to 5:50 p.m. And you realized that you had made some mistakes in the report. However, you are not aware of where the real error is. In these cases, if the Excel auto-recovery is at every 1 minute, this will help us.

We can recover older versions of the Excel workbook.

Step 1: First, we will open the workbook we wish to recover. Then, go to “File.” Under this, we will go to “Info.”
Step 2: Under “Info,” we could see “Manage Versions.” We would see all the recent auto-saved versions with time next to it.

Recover Unsaved Work of Excel

Assume you have worked for 2 minutes in Excel but forgot to save it and closed the workbook. We need not redo it again for 2 minutes; we can also recover that.

Step 1: Open the unsaved workbook. Then, we will go to “File.” Under this, we will go to “Info.”
Step 2: Under “Info,” we can see “Manage Versions.” Under this, we can see the last version with special remarks called (when you closed without saving).

Things to Remember

Give less time duration to get more versions of backup.In the case of large data, it will take some time to recover information every 1 minute.Manage a 5-minutes time interval for auto-recovery for large workbooks. For small workbooks, maintain 1 minute.