How to Recover Unsaved/Lost Excel File 2016/2013/2010/2007

Tracy King updated on May 08, 2019 to File Recovery | How-to Articles

Summary

If you have not saved the Excel file in time when encountering a sudden Excel/system crash, careless operation, or a power failure, do not worry, you can recover unsaved Excel file from Excel Document Recovery, Temporary File, and AutoRecover. Meanwhile, you can use EaseUS Data Recovery Wizard Free to retrieve the deleted Excel file in three steps.

Applied to Excel 2019, 2016, 2013, 2010, 2007 or older edition

PAGE CONTENT:
3 easy ways to retrieve unsaved Excel file
Recover deleted/lost Excel document with EaseUS file recovery software

"After almost three days of staying up at night and while I was about to finish with my wage calculations in Excel this morning, out of nowhere, my computer shut down with my Excel file unsaved. I restarted my computer and reopened Excel but to find nothing left. The Excel file disappeared. Can anyone rescue me from this disaster? Do you know how to recover an unsaved Excel document in Windows 10? "

Due to a sudden power failure, Excel not responding problem, false closure of Excel without saving, or other unknown reasons, it's quite common for users to lose Excel document unsaved. When such a disaster occurs, your best shot is to use some effective methods to retrieve the unsaved Excel. On this page, you can learn to get back unsaved Excel file from Document Recovery, Temporary File, and AutoRecover. What’s more, we also recommend you try free data recovery software - EaseUS Data Recovery Wizard to easily recover deleted or lost Excel file for free.

How to Recover unsaved Excel Document in Windows 10 (3 Ways)

The steps to recover unsaved Word, Excel, or PPT document are similar in Windows 10. Three possible solutions are given below, follow the detailed guides to make unsaved Excel file recovery.

Note: The following operations are performed on Excel 2016 edition. The processes are similar for other Excel editions.

Method 1. Recover from Document Recovery in Excel

If you have saved the Excel file earlier, but the latest changes you did are not saved because Excel/system crashed or the power went off, you can recover the unsaved edition with the Document Recovery feature.

1. Open Excel application, find "Recovered" and click "Show Recovered Files".

how to recover unsaved Excel file

2. The "Document Recovery" pane will display the unsaved files. Open and save the one you need.

how to recover unsaved Excel file

Method 2. Recover from Temporary File

Temporary files work as backups. If you lost the unsaved Excel file, you can find the temporary file and recover it.

You can go to the following path to find the unsaved Excel file:

C:\Users\[username]\AppData\Local\Microsoft\Office\UnsavedFiles

Or you can make it with the guides below.

1. Open Excel, and click "File" > "Info" > "Manage Workbook". Click "Recover Unsaved Workbooks" from the drop-down menu.

how to recover unsaved Excel file

2. Select the unsaved file and click the "Open" button. Then, on the pop-up window, choose "Save As" to recover it.

how to recover unsaved Excel file

Method 3. Recover from AutoRecover

1. Go to your Excel app, click "File" > "Open" > "Recover Unsaved Workbooks" at the bottom.

how to recover unsaved Excel file

2. Find the unsaved Excel file you lost, double-click on it to open it in Excel. Then, hit the "Save As" button to recover it.

how to recover unsaved Excel file

You can configure and change the AutoRecover Settings in the following way. 

Open Excel, and click "File" > "Options". In the left navigation pane, click "Save". Change the AutoRecover duration in "Save AutoRecover information every xx minutes" and click "OK".

how to recover unsaved Excel file

If you also need the guide on how to recover unsaved Excel file on Mac, here is the quick access.

How to Recover Deleted or Lost Excel File with EaseUS File Recovery Software

Except for unsaved Excel loss, the saved Excel document also get missing now and again because of mistaken deletion, virus attack, hard drive damage, or OS crash. At this time, you can use  EaseUS data recovery software to help you to recover lost Excel/Word/PPT document, images, videos, audios or email, etc. files for free with just a few simple clicks. You can recover data from the emptied recycle bin, formatted internal/external hard drive, camcorder, Zip Drive, Micro card, and so on.

Now, download and install this Excel file recovery software and follow the guidelines below to recover lost Excel in the simplest way.

Simple steps for Excel file recovery are as follows:

Step 1. Specify a location

Run EaseUS Data Recovery Software, firstly, you're asked to choose a location to start. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else, and then click "Scan".

select the excel file location

Step 2. Scan data

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed.

scan excel files

Step 3. Preview and recover

To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. Select the desired files and click "Recover".

select excel files and recover
 
 

100% of people found this article helful.

 

Frequently Asked Qusetions

1. 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.

2. 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.

3. 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.

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

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

5. 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.