[2024 Guide] How to Recover Unsaved or Lost Data on Excel

Any data loss can be painful and miserable. Fortunately, there are 5 feasible ways to recover unsaved or lost data on Excel. Keep reading.

Ellie

By Ellie / Updated on January 2, 2024

Share this: instagram reddit

Help! My Excel crashes and encounter data loss

“Help! I spend a large amount of time making a graph about my work stuff, and tonight I have to give in to my boss. But what drives me crazy is that my Excel freezes and says “Microsoft Excel is not responding”. I choose “Wait for the program to respond”. After waiting for a long time it finally crashes and then my data is gone. How can I recover my Excel file data? I do need some suggestions!” – Reddit

Microsoft Excel Is Not Responding

Losing data is painful and miserable for every one of us, especially when we take pains to complete something but it is unsaved or missing. But don't worry, your data on Excel is recoverable and there are 5 ways you can try.

How to recover unsaved data on Excel

Here in this part, we’ll talk about how to recover lost data on Excel. Microsoft offers you several features, such as AutoSave, AutoRecover, recent versions, etc. You can also restore files from a backup or directly use data recovery software.

Way 1. Find recent version of Excel file

If you haven't saved the Excel file before, you can try to recover lost data on Excel by searching the recent version. 

Step 1. Start Excel, and click File. 

Click File

Step 2. In the Open tab, click Recent and choose the recent Excel version.

Click Open

You can also scroll down to the bottom right and select Recover Unsaved Workbooks

Method 2. Recover a previously saved excel file

If you previously saved the lost Excel file, you could open it again and check the “Document Recovery” pane.

Step 1. Open the previously unsaved Excel file.  You will then see a "Document Recovery" pane on the left.

Document Recovery

Step 2. Check the previous version of the excel file in the Documents Recovery pane. Double-click to open and save it.

Way 3. Recover lost data on Excel using AutoRecover

AutoRecover is a useful feature in Microsoft Office, with which you can find your lost data on Excel. But the prerequisite is that you enable the feature before. Now follow me to recover the unsaved files on Excel.

Step 1. Start the Excel on your PC. Click File > Info > Manage Workbook, and click Recover Unsaved Workbooks.

Info Recover Unsaved

Step 2. Then your unsaved files will be shown in the pop-up window. Select the lost Excel file you want to restore and click Open.

Select File to Recover

Step 3. The document will open in Excel and you are prompted to save it. Click the Save As button in the yellow bar above your worksheet and select a location to save it. 

Save as Excel

Way 4. Recover lost data on Excel files via File History

Windows 10 offers a useful tool called File History, which can assist you in recovering lost data on Excel files. It makes backups every hour, allowing you to effortlessly view several previous versions and restore them as you need. 

Step 1. Type “restore files” in the search bar to open Restore your files with File History.

open-restore-files-with-file-history

Step 2. Locate the folder that includes the deleted Excel files. Click the Restore button to recover deleted Excel files to the previous location.

restore-deleted-files

Way 5. Get back your lost data on Excel with MyRecover

Through the 4 ways above, you must have a thorough understanding of how to recover lost data on Excel. However, if you didn’t enable the backup or AutoSave or AutoRecover option, then the operation is more troublesome and difficult. At this time, resorting to recovery software is far more quick and more efficient.

Here is a professional software for data recovery-- MyRecover. With it, you can recover your lost data on Excel with a few clicks, even if you are new to computers.

Recover lost data on Excel quickly:
  • Has a high recovery rate, up to 95%, and fast speed. With its advanced scanning algorithms, you are able to find all the deleted or lost data in several minutes or longer.
  • Compatible with 200+ file formats, not only Excel, but also Word, Excel, PPT, JPG, PNG, MP3, SVG, MP4, WMV, 3FR, X3F, ZIP, etc.
  • Filter deleted or lost Excel files in Windows 7, 8, 10, 11, etc. quickly and preview them. 
  • Keep the recovered files with their original filename, format, quality, and path.
Download SoftwareWin 11/10/8/7/Server
Secure Download

Step 1. Install and run MyRecover on the computer. Then select the partition/disk that includes your deleted Excel files, and click "Start Scan". 

Select Partition to Scan

Step 2. Quick Scan and Deep Scan can search all the deleted Excel files and other lost files on your selected partition/disk. You can search, filter, and recover unsaved Excel file during the scanning process.

  • Search: Type the file name or extension in the search box. 
  • Filter: Select file type (e.g.: documents), date modified, and size. You can also combine the search feature to narrow it down.
  • Reover: Select the desired Excel file and recover it immediately without waiting for the final scanning result.

Scan Lost Data

Step 3. Check your scanning results, select all the lost Excel files and click "Recover x files".  You will be asked to select a location to save it. Please select a new location to avoid data overwriting. 

Recover Lost Data

⚠️Notes:
  • MyRecover currently supports recovering unsaved or lost data on Excel for free, up to 30MB. Once exceeds, you will be asked to upgrade MyRecover

  • In addition, you still can MyRecover to recover PDF files, PPT documents, MP3, MP4, X3F, 3FR, WMV, KDC, RW2, etc.

How to Repair the damaged Excel files

Sometimes if you run into an Excel crash then you may get damaged Excel files, causing data loss on Excel file. Therefore, we could repair the damaged Excel files to recover the lost data.

Step 1. Open the Excel app and click on File and then select Open.

Step 2. Select the file that has been corrupted and then click on the small downward triangle in the Open button (as shown below).

Open Excel

Step 3. Click on Open and Repair.

Open and Repair

Step 4. Excel will show you a prompt as shown below. Click on Repair.

Repair Excel

How to avoid data loss on Excel

After knowing how painful it is to get through the data loss on Excel, I guess you don’t want to get through it again. Therefore, here are some operations that could help you avoid data loss on Excel again. And even if you accidentally delete the Excel, you could Excel restore deleted sheet easily.

Method 1. Enable AutoSave and AutoRecover

In the ways are shown above, we could get the lost data on Excel if we enabled the AutoSave and AutoRecover features. Therefore, it is of significance to enable them to kill data loss in the bud.

Step 1. Start Excel, click File > Options.

Click Option

Step 2. Click Save in the left panel.

Click Save

Step 3. Tick Save AutoRecover information every x minutes, and minimize the interval to 1 or any length you need or prefer. Then Tick Keep the last autosaved version if I close without saving.

Tick AutoRecover

Method 2. Enable Always Backup options

If the Always create Backup option is enabled, then we could get back the lost data on Excel, too. Now follow me to know how to operate.

Step 1. Go to File > Save As. For Excel 2016, click "More options…" under the save location.

Save as

Step 2. Click the Tools > General Options.

Step 3. Check the box next to Always create backup. Then click OK.

Always Create Backup

Step 4. Finally, click Save to save your settings.

Method 3. Get a professional way to back up your PC

To back up your Excel files, here is also a professional backup software for Windows - AOMEI Backupper to help you. With it, you can backup any files, not only Excel, but also Word, PPT, PDF. SVG, etc. More surprisingly, you can set a schedule task (e.g.: Daily, Weekly, Monthly, etc.) and backup only changed files, greatly reducing backup time and space.  

Step 1. Download, install and open AOMEI Backupper Standard. At the main interface, click Backup, and select File Backup.

Download FreewareWin 11/10/8.1/8/7/XP
Secure Download

File Backup

Step 2. At the next window, click Add File or Add Folder.

Add File or Folder

Step 3. In the popup window, choose the Excel files you want to backup and a path to save them. 

Step 4. To back up Excel automatically, click Schedule Backup and choose Daily, Weekly, Monthly, Event triggers, or USB plug in. Finally, click Start Backup

Schedule Settings

FAQs

1. Why is my data lost in Excel?
 
This may be caused by a sudden crash, power failure, unexpected shutdown, etc. Also, it may be hidden or accidentally deleted.
2. Where are unsaved Excel files stored?
 
Open your Excel. Click File at the upper left, and select Option. In the Excel Options window, click Save, and go to the AutoRecover file location. It usually is C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles.
3. How do I recover an Excel file I saved over?
 
You can right-click the folder and choose Properties > Previous Versions. Then, go to the Folder versions section and select a previous version, click Restore.

Conclusion

Here in this post, we introduce 5 ways for you to recover unsaved or lost data on Excel and 3 ways to help you back up your excel files. We could try AutoRecover,  the recent version of your Excel files, documents recovery pane, etc. If they didn’t work for you, then try a professional data recovery software - MyRecover to get your data back.

And for the ways to backup Excel files, enabling some useful features like AutoSave and AutoRecover, Always backup could stop you from getting into Excel file loss anymore. But considering the data security and reliability, AOMEI Backupper suits you the best.

Ellie
Ellie · Editor
Ellie, a professional and experienced writer who is good at solving iOS-related problems and writing iOS backup/transfer tips.