Table of Contents
About the Author
Reviews and Awards
- Video Recovery
- SD Card Recovery
- Recycle Bin Recovery
- Recover Data from USB
- Recover Deleted Emails
- Hard Drive Not Showing Up in Windows
- Recover Unsaved Word Documents
- Recover Deleted Files
- Recover Files from Virus Infected Hard Drive
- Best Free Photo Recovery Software
- Recover Files from Formatted Hard Drive
Quick navigation for solutions to recover previous version of Excel whether the Excel file is saved or not:
|Workable Solutions||Step-by-step Troubleshooting|
|Fix 1. Restore from Previous Version||To recover saved over Excel file, right-click on the saved Excel > "Properties" > "Previous Versions"...Full steps|
|Fix 2. Recover previous saved Excel||To recover overwritten Excel file, open Excel > "File" > "Info" > "Manage Documents" > "When I closed"...Full steps|
|Fix 3. Recover from AutoRecover||Recover unsaved Excel file, open Excel > "File" > "Info" > "Manage Workbook" > "Recover Unsaved..."...Full steps|
|Fix 4. Recover from .TMP File||Restore Excel previous version, Find Excel temp file with .TMP extension > Copy and change extension...Full steps|
Q: How to recover a previous version of an Excel spreadsheet after saving it?
"Is it possible to recover a saved-over Excel to a previous version? I got a very important two-sheet Excel file, but it was saved by mistake, and there was only one spreadsheet left with much useful data loss. I don't know how it happened without me knowing it. I need the lost data back. So, I'm hoping someone will be able to help and tell me if I can recover a previous version of this spreadsheet before the deletion occurred? If so, how do I do this?"
Recovering an Excel file that was saved over is a long-standing hot issue for many users. How you can restore earlier Excel depends on whether you've saved it or not. If the Excel file is still open, you can directly use Ctrl + Z or the Undo option to revert the Excel file to an earlier state.
However, if the edited Excel is saved and closed, recovery is not so easy. In the following content, we will discuss how to recover previous version of Excel file 2016, 2013, 2010, and 2007 in two cases. One is restoring older Excel version if you've saved the file, the other is recovering the previous version of Excel if you haven't saved it. Besides, in the end, we highly recommend you try EaseUS Data Recovery Wizard to recover lost saved Excel file without effort.
How to Recover Previous Version of Excel File After Saving
Two ways are available to help you restore previous version of Excel file by using Windows backup feature and Excel's Manage Wordbook feature.
1. Recover Earlier Version of Excel File from Previous Versions
Windows can automatically save old versions of your data files when you have enabled the File History and system backup and restore.
Step 1. Open File Explorer and locate the Excel/Word file.
Step 2. Right-click on the Excel file and select "Properties".
Step 3. Click the "Previous Versions" tab and select the version you would like to get back and then hit "Restore'.
2. Restore Excel File to Previous Version with Excel's Built-in Tool
Step 1. Open the file you are working on;
Step 2. Go to "File" and click "Info". Under "Manage Documents", click the file labeled "When I closed without saving".
Step 3. Click "Restore" in the bar at the top of the file to overwrite any previously saved versions.
How to Restore Previous Version of Excel File Not Saved
If you haven't saved the file, try below two approaches to get an Excel file earlier version back.
1. Recover Unsaved Excel File from AutoRecover
If the AutoRecover option is turned on, Windows can automatically save versions of your file while you're working on it. You can recover previous version of Excel that is not saved by following steps below.
Step 1. Click "File" > "Info" > "Manage Workbook" > "Recover Unsaved Workbooks" .
Step 2. Select the file and click "Open".
Step 3. In the bar at the top of the file, click "Save As" to save the file.
2. Recover Old Version of Excel File from .TMP file
Microsoft Office has this feature that it would automatically save temp files for the file that you are editing. So you can try to find the .TMP file to get an earlier version of Excel or Word file back:
Step 1. Follow the temp file folder location on your PC and find the Excel/Word temp files with .TMP extension.
- For Windows 7 users: C:\Users\UserName\AppData\Roaming\Microsoft\Excel\
- For Windows 8/10 users: C:\Users\UserName\AppData\Local\Microsoft\Office\UnsavedFiles\
Step 2. Locate and find the temporary excel or word files begin with "$" or "~" and end with “.TMP”, select the right version of Excel/Word temp file by date, then copy and save to another safe spot by changing the extension from .TMP to .XLS/.XLSX or .DOC/.DOCX.
Conclusion: If your Excel file got overwritten accidentally with data loss, you could use the four methods in total to recover previous version of the Excel file. In addition to Excel getting saved over, users also have trouble with Excel loss caused by mistaken deletion, storage device formatting, OS crash, virus attack, recycle bin emptying, and so on. Under these circumstances, the above approaches are not useful any longer. Then, how to recover deleted Excel documents? Calm down and use the EaseUS Data Recovery Wizard demonstrated below to get back lost Excel easily.
How to Retrieve Deleted/Lost Excel File with Data Recovery Software
If you've already deleted the earlier version of Excel file, or if the saved Excel gets lost due to careless deletion, hard drive formatting, and other reasons, you can use EaseUS Data Recovery Wizard to help you restore the deleted Excel from your PC or other storage devices within three steps.
EaseUS Data Recovery Wizard
- Recover lost or deleted photos, documents, videos, audio files, emails, and other 1000+ file types effectively
- Recover files from emptied Recycle Bin, HDD, SSD, memory card, USB flash drive, digital camera, and camcorders
- Repair corrupted files after the data recovery, support repairing corrupted Excel, Word, PPT, and PDF Documents
Now, install this program and follow to see how to get your lost Excel/Word file back effortlessly.
Step 1. Run EaseUS Data Recovery Wizard. Choose the drive where you lost files and start scanning. This software allows you to recover lost data from all devices, including HDD, SSD, USB drive, SD card, pen drive, camera, etc.
Step 2. Browse the full scan results. You can choose the file type you need by clicking on the file type filter. EaseUS data recovery software supports 1000+ file types like photos, videos, documents, emails, audio files, and many more.
Step 3. Select the files you want to preview. Click "Recover" and set a storage location to save the recovered data.
Was This Page Helpful?
Cedric Grantham is one of the senior editors of EaseUS who lives and works in Chengdu, China. He mainly writes articles about data recovery tutorials on PC and Mac and how-to tips for partition management. He always keeps an eye on new releases and loves various electronic products.
Written by Tracy King
Tracy joined in EaseUS in 2013 and has been working with EaseUS content team for over 10 years. Being enthusiastic in computing and technology, she writes tech how-to articles and share technical solutions to resolve Windows & Mac data recovery, data backup, partition management, data transfer, Windows update issues, etc.
EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition. Read More
EaseUS Data Recovery Wizard is the best we have 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. Read More
EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair. Read More
Excel Recovery Tool Full Version Free Download: Recover Corrupted Excel File
5 Free Excel Password Remover Online to Unprotect Excel Workbook
[Unsaved & Deleted] How to Make Photoshop File Recovery
Recover Lost/Hidden Users Folder in C Drive