[Fixed:] Unsaved Excel File Not in Recovery

Let’s assume a situation when you’re working in Excel and it is closed unexpectedly. Then, you obviously rely on the Document Recovery pane of Excel that auto recovers your unsaved Excel file. What if this useful feature doesn’t work properly? It’s really a pathetic situation. Well, I’ll cover the 5 issues for the unsaved Excel file not in recovery with their solutions in this instructive session.


Download Practice Workbook


Reasons for Occurring Unsaved Excel File

Several reasons are responsible for occurring unsaved Excel files. These are-

  • When Excel stops automatically and fails to run properly.
  • If users close Excel files without saving.
  • Error in your PC.

5 Issues and Solutions for Unsaved Excel File Not in Recovery

Let’s understand the problem first.

Assuming that you have an Excel file namely Sales.xlsx with blank cells. Later, you add information. Suddenly, it stops working.

Dataset

Now, if you open an Excel workbook, you’ll see the Document Recovery pane first on the left side of the Excel program. Then, you’ll be able to auto recover your unsaved excel file.

Doccument Recovery Pane in Excel

Think of the same situation again but this time you’re not watching the pane. What should you do in such a case if you face it?

Unsaved Excel File Not In Recovery

Let’s explore such issues and the way of fixing them.


1. If AutoRecover Is Disabled

Undoubtedly, you won’t see the Document Recovery pane by default if you turn off the AutoRecover feature. To check whether the feature is activated or not, do the following steps.

  • Initially, go to File > Options.
  • In the Excel Options dialog box, click the cursor on the Save option.

Unsaved Excel File Not In Recovery If AutoRecover Is Disabled

If you have a close look at the above picture, you’ll find that the box before the AutoRecover feature is unchecked.

So, if you want to get the Document Recovery pane first, just check the box before the AutoRecover feature as shown in the below screenshot.

If AutoRecover Is Disabled

Read More: How to Recover Previous Version of Excel File (4 Easy Ways)


2. When Timing to AutoRecover Is Set by Default

Besides, you cannot recover the document by default edited within 10 minutes. For example, I add B2:F11 cells in the blank Sales.xlsx file.

When Timing to Recover Is Set by Default

After being crushed Excel program, you’ll see the Sales.xlsx [Original] which is the row file. That means you’re not able to recover the file that is edited within 10 minutes.

When Timing to Recover Is Set by Default

  • To fix the problem, you need to put 1 instead of 10 in the time of the AutoRecover feature, and press OK.

Unsaved Excel File Not In Recovery When Timing to Recover Is Set by Default

Now, if the situation happens again, you’ll get the last added dataset i.e. Sales (version1).xlsb in the pane.

Unsaved Excel File Not In Recovery When Timing to Recover Is Set by Default

If you click on the file, you’ll get the dataset.

When Timing to Recover Is Set by Default

Read More: How to Auto Backup Excel File (2 Easy Methods)


Similar Readings


3. If You Don’t Save Excel File

Moreover, if you forgot to save the Excel file, you won’t see the Document Recovery feature automatically. In that case, you have to recover the file manually.

Let’s say, you don’t save the file Book1 or close the file forcefully (Book1-default name).

If You Don't Save Excel File


3.1. Unsaved File Recovery from Excel Options

  • Primarily, go to File > Open > click on the Recover Unsaved Workbooks option.

Unsaved Excel File Not In Recovery If You Don't Save Excel File

  • Then, you’ll see the Book1 file, and press the Open button for recovering the file.

Unsaved Excel File Not In Recovery If You Don't Save Excel File


3.2. Unsaved File Recovery from File Explorer

Another way to recover the unsaved Excel file is to go to File Explorer and go to the UnsavedFiles folder. The path would be like the following one-

C:\Users\Abdul Kader\AppData\Local\Microsoft\Office\UnsavedFiles

 Remember, you have to turn on Hidden items from the View tab in the File Explorer to get the AppData folder.

If You Don't Save Excel File

Read More: How to Undo Changes in Excel after Save and Close (2 Easy Methods)


4. Previous Version of Unsaved Excel File Recovery

Sometimes, you might have more than one version. Let’s say, in the previous version of the Sales.xlsx file, there were blank cells only. But I add the dataset (B2:F18 cells). So, this is the newer version. In the case of closing Excel unexpectedly, you’ll get the previous version in the pane. But it is quite difficult to find the expected file especially if you have numerous files.

When You Need to Restore Previous Version

To recover the previous version, follow the steps.

  • Just, go to File > Info > look at the Manage Workbook option.

Then, you’ll see the version history. So, click on the version to open the file. For example, I click on the first version.

Unsaved Excel File Not In Recovery When You Need to Recover Previous Version

So, the output would be like the following.

  • Next, you have to click on the Restore and save as .xlx format if you want to work with the version.

When You Need to Restore Previous Version

Read More: How to Recover a Deleted Excel File (5 Effective Ways)


5. Excel Files Recovery Using AutoSave Feature

A dynamic solution to deal with document recovery is to utilize the AutoSave feature of the Excel program. Certainly, this is a time-saving feature that is available in Microsoft 365.

Let’s say you want to open version history easily using this feature.

In the Sales1 file, there is a dataset covering B2:B11 cells.

  • To turn on the AutoSave feature, you have to click on the button showing Off, located in the upper-left corner of Excel.

Using AutoSave Feature

  • Next, choose the OneDrive account.

OneDrive Account

  • Later, add information about new products (B12:F18 cells).

Unsaved Excel File Not In Recovery Recovering Excel Files Using AutoSave Feature

  • Then, go to your OneDrive account and you’ll see the file namely Sales1.xlsx.

Unsaved Excel File Not In Recovery Recovering Excel Files Using AutoSave Feature

  • Moreover, right-click and choose the Version History option.

Version History Using AutoSave Feature

Immediately, you’ll see the following versions.

Unsaved Excel File Not In Recovery Recovering Excel Files Using AutoSave Feature

  • Furthermore, click over the version and choose the Open File option.

Unsaved Excel File Not In Recovery Recovering Excel Files Using AutoSave Feature

Eventually, you’ll get the first version as shown below. So, choose the Restore option if you want to work with the file.

Using AutoSave Feature

Read More: How to Backup Excel Files to a Flash Drive (4 Useful Methods)


Conclusion

This is how you can recover the unsaved file that is unable to recover by default. Surely, I believe this article would be highly beneficial for you. Anyway, don’t forget to share your thoughts.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo