Recover Deleted, Unsaved, and Crashed Excel 2016

Tracy King updated on Dec 11, 2020 to File Recovery | How-to Articles

This page includes solutions on how to recover deleted Excel 2016, recover unsaved excel files, and restore crashed Excel on saving or opening files. If you are facing one of the problems in Windows 10/8/7, follow solutions here to perform Excel recovery and bring your lost Excel 2016 files back now.

On this page, EaseUS software will offer complete solutions to help you perform Microsoft Excel 2016 file recovery with ease.

If you accidentally deleted important excel file, lost Excel 2016 by mistake, Excel crashed on saving or opening files in Windows 10/8/7, follow offered methods here to bring your lost Excel files back now:

Workable Solutions Step-by-step Troubleshooting
Fix 1. Recover deleted Excel 3 ways available: use Excel file recovery software; undelete Excel 2016 from recycle bin and temp...Full steps
Fix 2. Recover unsaved Excel Recover unsaved Excel from AutoRecover folder or restore unsaved Excel from previous versions...Full steps
Fix 3. Restore crashed Excel Restore crashed Excel 2016 by using Microsoft Repair Office and Open and Repair...Full steps

Recover Deleted Excel 2016

Applies to: Recover deleted, lost Excel files on Windows PC.

Method 1. Use Excel File Recovery Software

Professional file recovery software - EaseUS Data Recovery Wizard supports you to effectively recover deleted, lost Excel file in Windows 10, 8 or 7 within 3 simple steps. 

Just download, install this file recovery software and apply it to restore excel file now:

Step 1. Specify a location.

Run EaseUS Data Recovery Software. Choose the drive X: or a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".

select a location and click scan

Step 2. Scan for data.

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. Wait for the scanning process finishes. To quickly find the Excel files from the scan results, click on the "Filter" on the top area and choose "Excel". Or, search .xls or .xlsx in the Search box. 

scan excel files

Step 3. Preview and recover.

You can double click on the Excel file to preview its integrity. Finally, select the desired Excel files and click "Recover".

preview and recover excel files

If you prefer to manually restore lost Excel files in Windows PC, try the next two methods below to restore your Excels.

Method 2. Undelete Excel 2016 from Recycle Bin

If you deleted or removed Excel files from Desktop or file folders in your PC, undeleting Recycle Bin may help you get the deleted Excel file back:

Step 1. Open Recycle Bin and find deleted Excel 2016 files with .xlsx extension.

Open Recycle Bin and find lost Excel 2016 file.

Step 2. Right-click on lost XLSX files and select "Restore".

Restore deleted Excel 2016 file.

Then deleted Excel file will be restored back to the original location on your PC.

Method 3. Recover Deleted Excel 2016 from Temp Files

If you've emptied the Recycle Bin, you may also try to find deleted excel files from the .temp files in Windows PC:

Step 1. Follow the below-listed temp file folder location on your PC and find the Excel temp files with .TMP extension:

  • For Windows 8/10 users: C:\Users\name\AppData\Local\Microsoft\Office\UnsavedFiles\
  • For Windows 7 users: C:\Users\name\AppData\Roaming\Microsoft\Excel\ 

Recover deleted Excel file.

Step 2. Locate and find the temporary excel files begin with "$" or "~" and end with ".TMP".

Step 3. Copy these files and save to another safe spot by changing the extension from ".TMP" to ".XLS" or ".XLSX".

Recover Unsaved Excel 2016

Applies to: Restore unsaved Excel files due to a sudden close, virus attack or even power supply accident, etc.

To restore unsaved Excel 2016 files in Windows 10/8/7, there are two methods that you may also follow either one below to get your problems solved:

Method 1. Recover Unsaved Excel 2016 from AutoRecover Folder

Note that this method only works when you have enabled the AutoRecover feature in advance. If you didn't enable this feature, move to try the next method for help.

Step 1. Open Office file or a new Excel document in Windows PC.

Step 2. Click "File" and "Recent", check recent used Excel documents and find the exact one - unsaved Excel document.

Recover unsaved Excel 2016 from AutoRecovery.

Step 3. Click "Recover Unsaved Workbooks" and then wait till the Excel document is retrieved.

Recover unsaved Excel 2016.

Step 4. On the Open dialog, open the exact lost Excel and click "Save As" to save the document into a safe spot on PC.

Save unsaved Excel file to safe location on your PC.

Method 2. Recover Unsaved Excel from Previous Versions

If you didn't enable the AutoRecover feature and you want to bring the unsaved Excel file back, you can follow below tips restore part of the lost or unsaved Excel from its previous version. 

Step 1. Create a new Excel file with the same name as your lost Excel file or find your present Excel file.

Step 2. Open the excel file and click on the "Files" tab, click on "Info".

Step 3. Next to the "Manage Versions", you'll be able to see all autosaved versions of your Excel file. 

Find unsaved Excel file.

Step 4. Double click the most recent version and check the Excel content. If it's the lost unsaved Excel, save it as a new Excel document.

Then you'll get Excel 2016 file restored from previous/saved versions.

Restore Crashed Excel 2016 on Saving or Opening Files

Applies to: Restore crashed Excel while saving or opening a file.

If your Excel files or Word documents crashed on saving or opening files, don't worry. Here below two methods will help you out and restore your crashed Excel 2016:

Method 1. Repair Office to Restore Crashed Excel 2016

Step 1. Restart your PC and open Control Panel.

Step 2. Click Programs and Settings, then find and click Office.

Step 3. Right-click on "Change", a repair dialog will appear.

Repair crashed Excel.

Step 4. Check "Quick Repair" and click "Repair". Then open Excel to see if problems got fixed or not.

Make Crashed Office work.

Step 5. If not, select "Online Repair" and wait for the repair process to complete.

After this, you can open the crashed Excel file and it shall work by then.

Method 2. Restore Crashed Excel by Open and Repair

Step 1. On the File tab, click Open.

Step 2. In Excel 2016, click on the location where the spreadsheet is loaded, and click Browse.

Step 3. In Open dialog, select the corrupted or crashed Excel file that you want to open.

Step 4. Click the arrow next to the Open button, and then click Open and Repair.

Restore Excel by Open and Repair.

  • If you want to recover as much of Excel data as possible, click "Repair".
  • If you want to extract values and formulas from the Excel when an attempt to repair the Excel is not successful, click "Extract Data".

Was This Page Helpful?


Frequently Asked Questions

1. Why choose EaseUS Data Recovery Wizard?

"EaseUS Data Recovery Wizard is the best we've seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past, but it's fast and efficient..."PCMag

"The first thing you'll notice about EaseUS Data Recovery Wizard Pro is that its interface is very clear and uncluttered, with only a small collection of self-explanatory controls. You won't find lots of extra options hidden in a system of hidden menus, either; what you see really is what you get."techradar

"Recover lost files, even after deleting a partition or formatting your drive."Macworld

2. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

3. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

4. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

5. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files, so verify the recovery quality of our product before purchase.

6. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.