How to Recover Unsaved or Lost Excel Workbook Document Free

Excel document is one of the most used utilities for daily work. Just like the recovery of Word document, however, it is more often than not an urgent need to recover unsaved or lost Excel Workbook files. Don’t worry if you’re facing this problem. We are going to explain how to recover unsaved or lost Excel documents step by step in this tutorial.

How to Recover Unsaved or Lost Excel .xls/.xlsx File

Part 1. How to Configure the AutoRecover Settings in Excel

It is a very common but useful method to recover the lost file in Excel. Follow these simple guidelines for more assistance:

  1. Open any excel file, and go to the top menu section.
  2. Choose the File tab and then go with Options.
  3. Now, Select the Save tab.
    How to Configure the AutoRecover Settings in Excel
  4. Configure Excel AutoRecover with the following settings:
    • Make sure the box next to “Save AutoRecover information every N minutes” and the one below it are checked.
    • Set the frequency to a proper threshold so that your file will be saved automatically and in time.
    • Attention to the AutoRecover location which will be important for Excel file recovery.
    • AutoRecover exception can disable this feature for selected files, which might play a role in certain cases.
  5. Now, click the OK button to save the settings.

With these setting, you will be able to get the Excel file after the clang. You will get the last autosaved file in the desired folder.

Note: This method is only applicable to that file that you have saved at least for one time. But if you have not saved the file for at least one time, then this is method will not work.

Part 2. How to Recover Unsaved Excel File

It is an important and most useable method for the recovery of unsaved Excel file. Do follow these steps given below:

  1. Open any Excel file, and go to the top menu section.
  2. Choose File > Open > Recent.
    How to Recover Unsaved Excel File
  3. Scroll down until you see the option “Recover Unsaved Workbooks” button. Click on the button to get the list of unsaved documents.
  4. From the list search out the document that you have lost.
  5. If you have found that one, then double click on it to open it.
  6. Now, your document will appear. Save it to your desired location to make a permanent copy.
  7. Your unsaved worksheet or document is recovered now.

Part 3. How to Recover Overwritten Excel File

This method is applicable only for those files that were created in the new versions of the MS Office. If you are using the versions older than 2010 or 2013, then you may skip the instruction below, and go to some other choices.

Whenever you made the new changes in the previous document and then realized that you have done the wrong thing and want to recover the original document, this method is surely for you. To recover the original copy from the overwritten document, do follow these easy guidelines:

  1. Open the Excel file with overwritten content, click the File on the top menu.
  2. Click Info to enter the tab.
  3. Choose the Manage Workbook option to see all versions of this document. The versions of the document contain the data since the beginning.
    How to Recover Overwritten Excel File
  4. Select the desired copy from the available versions and save it.

Note: This method shows you all the AutoSaved versions of the document, which exist until you have permanently saved it in some location. Once you have manually saved the Excel document, all AutoSaved versions will be lost. In that case, it’s recommended take the backup of the file before manipulating it.

Part 4. How to Always Save a Backup of Excel File

If you are using the computer or laptop than it is recommended to take the backup of your data. So, that you can retrieve it back in case of crash or data loss.

Note: This method is applicable when you hit the Save button and make a copy of the original file in a separate location. It is supported in Excel 2010, 2013, 2016 and newer versions.

  1. Open the excel file, click File > Save As.
  2. Scroll down and click Browse option.
  3. A pop-up window will appear. At the downside, there is a “Tools” option. Click on it and then go for “General Options”.
    How to Always Save a Backup of Excel File
  4. Check the “Always create backup” option and set the path where you want to save the backup file.
  5. With this setting all, you excel files’ backup will be created.

Note: All your backup files will be saved in .xlk extension. Please look for this type of file in case the restoring from backup is needed.

In this article, we have learnt how to recover unsaved or lost Excel file with several easy steps. Moreover, there is also a method for making automatic backups for your Excel documents, which is very convenient to avoid accidental loss of Excel works. After all, it is just as important as recovering lost photos and videos. Feel free to share your experience or problems with us in the comment.

Related Articles