Recover Unsaved Excel File on Windows

Microsoft offers a diverse set of apps to its customers. Excel is the most widely utilized native program for storing and processing critical data among all MS Office apps by a variety of businesses and people.

Excel is also a go-to data analysis tool with a lot of capabilities, dependability, and convenience of use. However, human and system failures are not unavoidable.

You may restore unsaved Excel files on Windows 10 using the techniques that are discussed in this article.

Use the Search Option

If you know the name of the Excel file, use the Search option to locate it.

Go to Windows Search Box and type the name of the file.

If you find the file there, click Open or Open file location.

If you click Open file location, it will take you to the exact location of the file, and you’ll be able to regain access to lost/unsaved Excel file easily.

Use AutoRecover Feature

AutoRecover is a built-in function in Microsoft Excel that saves copies of all open Excel files at a user-defined set interval.

If you neglect to save the file and shut it by mistake, or if it closes automatically due to a system malfunction or power outage, you may retrieve it.

Open a new Excel file and go to File then select Options.

Navigate to Save and look for Save workbooks.

Ensure that the ‘Save AutoRecover information every’ and ‘Keep the last autosaved version if I close without saving’ option is already selected.

Copy the file path given against the AutoRecover file location.

Open the File Explorer, paste the Menu Bar file path there, and hit Enter.

The unsaved file will appear with the .xlb extension.

Double-click the file and choose Excel from apps to open the .xlb file.

Finally, save the file to the desired location.

Use Recover Unsaved Workbooks Option

Open Excel and go to File then Open.

On the lower corner, select Recover Unsaved Workbooks.

The list of unsaved files will show in the Document Recovery pane.

Locate the file you lost and double-click on it to open.

Right-click on the version of the file you want to restore and click Save As.

Restore File with Previous Versions Utility

Open Excel and go to File.

Click on File and select Manage Workbook and Recover Unsaved Workbooks.

It will show the previously saved versions.

You can choose the one you want to restore and click Save or Save As to store the file with a different name.

Hopefully, you’ve learned how to restore unsaved Excel files from this blog. Any of the approaches listed above may be used.


Commerce major. My training enabled me to fully use the various Microsoft Applications while also allowing to work around problems. I spent my high school years working as a campus writer and researcher, as I get older, I want to broaden my horizons and live life to the fullest.

You may also like...