How to Recover an Excel File That Was Not Saved

Excel stores your unsaved documents

Reading time icon 2 min. read

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Key notes

  • Microsoft Excel has built-in Auto Save and Auto Recover features.
  • The Auto Recover feature allows users to retrieve unsaved documents on their devices.
  • We will show you how to turn these features on and how to use them to recover lost documents.
recover unsaved excel files

Excel is one of the most essential MS Office applications that millions of users utilize for calculating and displaying numerical data. Two of the good things about Excel are its AutoSave and AutoRecover features.

They make it easy for users to retrieve spreadsheet files that weren’t saved. However, those features need to be enabled for users to restore an Excel file not saved.

How can I recover an unsaved Excel file?

1. Make sure the Save AutoRecover information option is selected

  1. To check if AutoRecover is enabled, click the File tab in Excel
  2. Click Options to open the window shown directly belowExcel Options window recover an excel file not saved
  3. Click Save on the left of the window to open the tab in the snapshot below.The Save tab recover an excel file not saved
  4. Select the Save AutoRecover information window every x minutes option if it’s not already checked
  5. Select the Keep the last autosaved version checkbox
    • You can change how often AutoRecover saves things by entering an alternative value in the option’s text box
    • The AutoRecover file locations text box includes the folder path where you can find unsaved documents.
      • You can change that path by clicking Browse
  6. Click the OK button

Thereafter, a Document Recovery sidebar will open when you first launch Excel after it unexpectedly closed (crashed).

That shows you a list of files that it can recover. Note that the files it displays will have been saved at least once before. Nevertheless, it will enable you to recover content added to a document before the application closed.

2. Select the Recover Unsaved Workbooks option

1. Launch Microsoft Excel on your device.

2. Navigate to the File tab from the menu.

3. In newer Excel versions, click on Open. In older versions, you’ll need to click on Recent.

4. Select Recent to open a list of recent documents. If you are already here, skip to step 5.

How to recover an excel file that was not saved recent documents

5. Click the Recover Unsaved Workbooks button.

6. An Open window will then appear that includes a list of unsaved Excel documents.

7. Select an unsaved document from there.

8. Click the Open button to view the file.

To restore a file that has never been saved, you can use the built-in Recover Unsaved Workbooks option. All of your recent unsaved documents will be listed, and you will be able to select those that you want to recover.

So, that’s how you can restore an Excel file that’s not saved and lost document content.

You can also restore unsaved MS Word files much the same as that application has the same AutoSave and AutoRecover features.

What methods do you use to recover unsaved MS Office documents? Share your experiences with us in the comments section below.

More about the topics: Excel