See all How-To Articles

How to Recover a File That Was Not Saved in Excel

In this tutorial, you will learn how to recover a file that was not saved in Excel.

 

excel document recovery pane

 

If you don’t manage to save your file before closing Excel, and the AutoRecovery option is turned on, your backup file will be saved, and you can access it again. There are a few ways to get your file back using AutoRecovery.

Recover via Document Recovery Pane

When you open Excel again after closing an unsaved file, the Document Recovery pane will appear on the left side of the window. Here, you can find all files that were automatically saved in the time frame specified in Excel Options. In our case, there are two versions of the file available.

 

excel document recovery pane

 

We can choose to Open, Save, or Delete these files, by clicking on the down arrow to the right of each file.

 

excel document recovery pane 2

 

If you don’t see the Document Recovery pane when you open Excel, you can display it by going to File > Home > Recover unsaved workbooks.

 

recover unsaved workbooks excel

 

The same can be achieved by using the path: File > Info > Manage Workbook > Recover Unsaved Workbooks.

 

recover unsaved workbooks 2

 

Restore a File From the AutoRecover Location

Alternatively, go to File > Options > Save, and find the AutoRecover file location. This is the location where all files that are automatically saved are stored.

 

autorecover file location

 

The default location is C:\Users\*user*\AppData\Roaming\Microsoft\Excel\

If we go to that location, we’ll see the backup file there.

 

autorecover file location excel