Easily restore unsaved Excel files

Nothing is more annoying than working on an Excel spreadsheet for hours and then either the entire PC or even Excel just crashes. Certainly some of you have already had to go through this scenario and many of you then had to repeat the entire work completely.

But this is not absolutely necessary, because Excel offers a very good function to get back to such crashed Excel files . As this Recover unsaved Excel files is going on, we will describe below.

Recover unsaved workbooks

First you simply click on in Excel

File / Open

Then the possible storage locations such as ” Last used “, “OneDrive”, This PC “, ” Add location ” and ” Browse ” are displayed. In our case, the restore function is hidden under the point

Last used

We have shown you this below in an Excel 2016 version.

Recover unsaved workbooks

At the bottom right you will find the function to restore lost Excel files . The option is called

Recover unsaved workbooks

If you press this, the Excel recovery folder will automatically be displayed in an Explorer window. The path is usually

C: Users USERNAME AppData Local Microsoft Office UnsavedFiles

Here you can find all files that have been cached since the last Excel crash and you have the option to reload them here and edit them further.

AutoSave in Excel

The fact that Excel stores the files here is due to the Excel setting ” AutoSave “. You can find this option at

File / Options / Save

AutoRecover information is saved every minute

The corresponding option is called:

AutoRecover information is saved every minute

By default, this value is set to 10 minutes , which is usually sufficient. However, if you want, you can adapt it to your needs at any time.

You can find more Excel tips in these articles:

– Create a continuous diagram of an Excel table with missing values
– Simply import CSV files into Excel