[Hot] How to Recover Unsaved/Deleted/Crashed Excel File 2016

menu_default hide_default


Hi, please I need all the help I can get, a few days ago I was instructed to draw up a statistic report for the company I work for which I was able to finish up a few hours ago, but I mistakenly exited the page without saving the file, the thought of starting all over is creeping me out, please is there any way I can recover unsaved excel file 2016?

Situations like the above can sometimes happen, either by a power cut, system shut down or accidentally exiting without saving or for any other reason, an unsaved excel file may leave you feeling drained, all your hour's work, down the drain. Is there any way to recover unsaved Excel file 2016? The short answer is yes. This page includes solutions on how you can recover unsaved Excel file 2016 and also how to recover data if you deleted them.

Part 1. How to Recover Unsaved Excel File 2016?

1. Recover Unsaved Excel File from Autosave Folder

Before using this method, click to see if you enabled the AutoRecover feature, this method will not work if you haven't enabled the Auto Recover feature before losing the excel file.

Step 1: Start Office file or open a new excel document in Windows.

Step 2: Select "File" and "Recent", search on the recent used excel documents and find the one written - unsaved Excel document.

search file and recent

Step 3: Select "Recover Unsaved Workbooks", the document should be restored.

recover unsaved workbooks

Step 4: On the home interface, open the lost excel and click "Save As" to save it on your computer.

recover unsaved file

2. Recover Unsaved Excel from the Previous Version

In case you didn't enable the AutoRecover feature, another way to recover unsaved Excel file 2016 is to restore it from a previous version using the following steps:

Step 1. Create a new Excel file using the same name as the last excel file.

Step 2. Open the file and select the "Files" tab, then click on "Info”.

Step 3. On the Right of "Manage Versions" you should see all autosaved versions of your excel file, double click on the most recent version and view the content. Then save it as a new Excel document if it’s the lost document.

manage versions

Part 2. How to Recover Deleted Excel File 2016?

We've stated above how to recover unsaved Excel file 2016.  What if you deleted the file and want to recover it? Below are two efficient methods to recover deleted Excel files.

1. Recover Deleted Files with AnyRecover (Windows 11 Supported)

AnyRecover is a highly trusted file recovery software that can restore all deleted/lost or corrupted data, be it documents, photos, videos, music, and so on, from any device. It’s very reliable and trusted by many. Simply put, when you think of anything data recovery, AnyRecover should pop up in your head.


Features of iMyFone AnyRecover:

  • Restores data even if your operating system crashes, you deleted the file, formatted your device or just any scenario.
  • It supports more than a thousand file types.
  • It’s very secure, only if you have access to recovered files, plus it is risk-free.
  • It supports any storage media, from your Laptop/PC to your USB flash drive, music player, etc.
  • AnyRecover guarantees a 98% recovery rate. You have little or no chance of not recovering your files.

Steps to Recover Deleted Excel Files with AnyRecover

Step 1. Open AnyRecover on your computer and click on the "Deleted Files Recovery" mode.

deleted files recovery

Step 2. Go on to choose the location where you deleted the file, e.g. your internal hard disk, eternal removable device, then hit "Next".

deleted files recovery select path

Step 3. To find the specific files, you want to recover, choose the type of file.

select file type

Step 4. The program will begin scanning the disk to find your files.

deleted files recovery scan

Step 5. When the scanning is finished, you can preview them to choose the specific files you want to restore and click "Recover" to retrieve the files.

deleted files preview

Step 6. If you still don't see your deleted files, then choose "All-Round Recovery" mode.

all round scan


Ensure you don't save the file to the same partition where you deleted them.

2. Undelete Excel File 2016 from Recycle Bin in Windows 11/10

Another easy way to recover deleted Excel files is by undeleting them from the default recycle bin in the system.

Step 1: Open the Recycle bin on your computer and search for the excel files you deleted.

Step 2: Right-click on the file(s) and select "Restore".

That's it! The deleted file(s) will be retrieved.

Part 3. How to Restore Crashed Excel File 2016?

Restore Crashed File by Open and Repair

Step 1. Open the file on the File tab.

Step 2. Click on the location where the spreadsheet is loaded, then select "Browse".

Step 3. Under "Open", click on the corrupted excel file you want to view.

Step 4. Select the arrow next to the open button then choose "Open and Repair".

open and repair


So, that’s how to recover unsaved Excel file 2016. Also, if you deleted an excel file (or any other file type) mistakenly and want to restore it, you can trust iMyFone AnyRecover data recovery software to restore it easily, or you can use any of the ways we mentioned above. If you have any suggestions or complaints about this or related topics, feel free to contact us or use the comment box.

Download NowDownload Now


By Alva Doris , to Deleted Files Recovery

Updated: Jul 21, 2021

Related Articles: