How to recover unsaved Excel file

By |2019-02-08T13:52:11+00:00January 7th, 2019|

Are you looking for a way to recover unsaved Excel file?

It happens to people all the time. Maybe a system crash or you forgot and close the window without saving, or maybe the power went out and your hours of unsaved work is lost.

recover unsaved Excel file

This is when regrets start kicking, making you realize that it is always a good practice to save your data early and often. Sometimes things fall apart so quickly and before you even had the chance to back up.

The good news is that Excel has an invaluable safety net called the AutoRecover /Recover Unsaved WorkBooks

Excel use these features to periodically save backup copies of your spreadsheet as you work. For any reason, if you encounter a problem with an unsaved Excel file on the line, you can retrieve the last backup even if you never save the file yourself.

The trick is that Excel automatically saves your data every 10 minutes as you work. As a result, the AutoRecover backup won’t contain every information you entered before the problem occurred. You’ll lose 10 minutes or less worth of work.

If any of the above problems do occur, and there were unsaved Excel files, you can easily retrieve any unsaved workbook or the last AutoRecover backup of these files.

The steps below shows you how you can recover your unsaved Excel files.

Option 1: Use AutoRecover

If the file you want to recover has been saved before, you can use the AutoSave version to get the file back.

If you mistakenly close an already saved workbook without saving recent changes, or even a new workbook that has never been saved, an AutoSave version of that file is kept until your next editing session.

In the next time you open Excel after it has been shut unintentionally, it automatically checks the backup folder and if it finds a backup, it adds a link named Show Recovered Files to the Excel’s welcome page.

recover unsaved Excel file

When you click the link, you will see a panel named Document Recovery to the left side of the Excel window.

See screenshot:

recover unsaved Excel file

This Document Recovery pane allows you to either save or open an AutoRecover backup just as in an ordinary Excel file. Thus, to recover a file in the list, simply click on it or click on the arrow attached to it to either save or open the file.

See screenshot:

How to recover unsaved Excel file

Option 2 – Recover Unsaved WorkBooks

This option is used to recover Excel files which have never been saved at all (i.e. it is still called Book1 or something like that).

Follow the steps below to recover unsaved Excel workbooks.

  • Launch Excel. The Excel’s welcome page appears.
recover unsaved Excel file
  • Choose Open Other Workbooks at the bottom in the left panel.
recover unsaved Excel file
  • In the center panel, at the bottom of the recent file list, click Recover Unsaved Workbooks.
recover unsaved Excel file

At this point, Excel shows you all the unsaved workbooks in a folder called UnsavedFiles.

  • Select a file and choose Open. If it is the wrong file you’ve opened, go back to the folder and scroll down to the list.
  • After you find the right file, click the Save As button to save the workbook.

Pro-Tip: Unsaved workbooks are saved for up to four days before they’re automatically deleted. Thus, if you fail to save a workbook for the past 5 or more days, just consider it gone forever.

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

I Know You Better!
Subscribe To My Newsletter
Be the first to get latest Excel updates and
exclusive content straight to your email inbox.
Yes, I want to receive updates
No Thanks! I Don't Want to Learn Excel.
close-link

Not Sure What to Learn in Excel?

Sign Up For My Actionable Excel Techniques You Can Use Right Away!
Send me Updates
You'll Get One Email Every Week!
close-link