Click on the 'Document' option on left sidebar, and then open the folders titled XLSX, XLS, HTML and more to preview all old versions of excel files. Moreover, the 'Filter' feature at top ribbon could locate to an excel files quickly. Due to Adobe's decision to stop supporting and updating Flash® in 2020, browsers such as Chrome, Safari, Edge, Internet Explorer and Firefox will discontinue support for Flash-based content.
Summary
Want to recover an excel file on your computer? Apeaksoft Data Recovery can successfully restore your previous version of excel files including XLSX, XLS, HTML and more from internal or external drives in one click.
FreeDownloadFreeDownload'I saved all the worksheets I had been working on earlier in the day so that I could shut down my computer and get off work; however, today I opened excel and one of the worksheet was gone, please tell me how to recover an excel file that was saved over.'
Generally speaking, we cannot recover an old version of an excel file using the way that we deleted files. The old version file has almost certainly been overwritten by a later version. Fortunately, there may be old versions of that excel file elsewhere. In this tutorial, we are going to share how to restore previous version of excel file simply.
Part 1: How to recover an excel file that was saved over (Undo the Changes)
When you create or open an Excel file, Office will start a temp file as well, which stores all the changes. And before you close the Excel file, the temp file allows you to undo, redo or repeat worksheet changes at any time. In another word, if your workbook is still open, you can use the Undo feature to remove mistakes and get back your data.
Step 1: When you discovered that your worksheet disappeared, keep the workbook open and locate to the very top ribbon.
Step 2: Click on the 'Undo' button with a left arrow icon repeatedly until the file reverts to the previous version.
If you cannot find the Undo button at top of the window, press 'Ctrl + Z' to undo changes. This is the easiest way to recover previous version of excel, but the prerequisite is that the file is still open.
Part 2: Restore previous version of excel file with AutoRecover feature
AutoRecover and AutoSave are built-in features in Excel. And if you have set it up, you can recover excel file saved over or unsaved. Bear in mind that AutoRecover feature only works on workbooks that have been saved at least once.
Step 1: Make sure you have configured 'AutoRecover' and 'AutoSave' features in 'File' > 'Options' > 'Save'.
Step 2: To restore previous version of excel file without saving, open the 'File' tab and go to 'Open' from left sidebar. You can click 'Recent Workbooks' to display all Excel files that you opened recently.
Step 3: Scroll down and select 'Recover Unsaved Workbooks' at the bottom. Then the previous version of workbook will open in Excel and prompted you to save it. Click on the 'Save As' button on the yellow alert bar to save the previous workbook to your computer.
Other Microsoft Office products like Word, PowerPoint, etc. are also equipped with this feature. You can easily restore your Word document, PowerPoint presentaitons, etc. in this way
Part 3: Recover Previous Excel Version to recover Excel file saved over
The AutoSave feature not only saves your workbook automatically, but also allows you to set intervals and more custom options. That makes recovering overwritten excel file possible.
Step 1: Go to 'File' > 'Info' and locate to the 'Manage Versions' section.
Step 2: Then you can look at several previous versions titled with time. Click on the desired version, the file will reopen in Excel.
Step 3: Instead of Save As, you will be prompted to 'Restore' the file since it is temporarily stored on your computer.
Part 4: Best way to restore previous version of excel file
According to our testing, the methods above are not always successful to recover old version of excel file. Plus, the AutoRecover and AutoSave features are disabled by default. Is it possible to restore previous version of excel file without built-in features? Apeaksoft Data Recovery may be the answer that you are looking for. Its key features include:
- It is able to recover previous version of excel files from internal and external drives in one click.
- This Excel recovery tool is available to various situations, like mistake operation, accidental deletion, virus attack, sudden interruptions, or format.
- It supports a variety of Excel file formats, including XLSX, XLS, HTML and more.
- The best Excel recovery software could recover overwritten excel file in original format and quality.
- Users could preview all excel files and decide to recover all of them or specific workbooks.
- It is quicker, lightweight and safer.
- Data Recovery is compatible with 10/8.1/8/7/Vista/XP.
If you cannot find the Undo button at top of the window, press 'Ctrl + Z' to undo changes. This is the easiest way to recover previous version of excel, but the prerequisite is that the file is still open.
Part 2: Restore previous version of excel file with AutoRecover feature
AutoRecover and AutoSave are built-in features in Excel. And if you have set it up, you can recover excel file saved over or unsaved. Bear in mind that AutoRecover feature only works on workbooks that have been saved at least once.
Step 1: Make sure you have configured 'AutoRecover' and 'AutoSave' features in 'File' > 'Options' > 'Save'.
Step 2: To restore previous version of excel file without saving, open the 'File' tab and go to 'Open' from left sidebar. You can click 'Recent Workbooks' to display all Excel files that you opened recently.
Step 3: Scroll down and select 'Recover Unsaved Workbooks' at the bottom. Then the previous version of workbook will open in Excel and prompted you to save it. Click on the 'Save As' button on the yellow alert bar to save the previous workbook to your computer.
Other Microsoft Office products like Word, PowerPoint, etc. are also equipped with this feature. You can easily restore your Word document, PowerPoint presentaitons, etc. in this way
Part 3: Recover Previous Excel Version to recover Excel file saved over
The AutoSave feature not only saves your workbook automatically, but also allows you to set intervals and more custom options. That makes recovering overwritten excel file possible.
Step 1: Go to 'File' > 'Info' and locate to the 'Manage Versions' section.
Step 2: Then you can look at several previous versions titled with time. Click on the desired version, the file will reopen in Excel.
Step 3: Instead of Save As, you will be prompted to 'Restore' the file since it is temporarily stored on your computer.
Part 4: Best way to restore previous version of excel file
According to our testing, the methods above are not always successful to recover old version of excel file. Plus, the AutoRecover and AutoSave features are disabled by default. Is it possible to restore previous version of excel file without built-in features? Apeaksoft Data Recovery may be the answer that you are looking for. Its key features include:
- It is able to recover previous version of excel files from internal and external drives in one click.
- This Excel recovery tool is available to various situations, like mistake operation, accidental deletion, virus attack, sudden interruptions, or format.
- It supports a variety of Excel file formats, including XLSX, XLS, HTML and more.
- The best Excel recovery software could recover overwritten excel file in original format and quality.
- Users could preview all excel files and decide to recover all of them or specific workbooks.
- It is quicker, lightweight and safer.
- Data Recovery is compatible with 10/8.1/8/7/Vista/XP.
How to restore previous version of excel file
Office 365 Excel Version
Step 1: Scan entire hard drive to look for previous versions of excel files
Download and install Data Recovery on your computer and launch it. If your excel file was stored on an external drive, connect it to your PC too. First of all, head to the data type area and check the box on the 'Document' option. Then go to the locations area and choose where you save the excel file. Data Recovery will work as soon as you hit the 'Scan' button.
Step 2: Preview excel files before recovery
After standard scanning, you will be taken to the result screen. Click on the 'Document' option on left sidebar, and then open the folders titled XLSX, XLS, HTML and more to preview all old versions of excel files. Moreover, the 'Filter' feature at top ribbon could locate to an excel files quickly. If the Excel file that you want to get back is not in the quick scanning result, click on the 'Deep Scan' button to execute a deep scan.
Step 3: Recover previous version of excel file in one click
Select all desired excel files or entire folder after preview and click on the 'Recover' button to start recovering previous version of excel file. Then you can access them as usual.
You Can also Read:
Part 5: FAQs of recovering an excel file
1. How to Recover an unsaved excel file in Excel?
Launch MS Excel application you were using. Open a new file or any existing file. Click the File tab. Find Info and then choose Manage Versions. At last, click Recover Unsaved Workbooks.
2. How do I get Excel to autosave?
Go to the File tab and choose Options from the File menu. Click Save on the left-hand pane of the Excel Options dialog. Make sure that both Save AutoRecover information every X minutes and Keep the last autosaved version if I close without saving are checked. Click OK.
3. Can I restore replaced XLS file from the previous version?
If your XLS files got replaced or saved over, relax. You can follow the step-by-step guide in Part 3 of this page, and then you can get your Excel file XLS restored without losing any saved data.
Conclusion
In this tutorial, we have discussed how to recover an excel file that was saved over. Firstly, Microsoft has introduced several features into Excel program to help users get back old versions easily, such as Undo, AutoRecover and AutoSave. They all have prerequisites, for example Undo is only available when the Excel file is still open. And if you want to use AutoRecover and AutoSave, you have to configure them first. On the other hand, we also shared a professional Excel recovery application, Apeaksoft Data Recovery. It does not require any settings. All you need to do is a single click; then your workbooks and data will restore to your computer. What's more, it can recover unsaved excel file. Don't hesitate and now make a excel file recovery.
Quick navigation for solutions to recover previous version of Excelwhether 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. Call of duty modern warfare 2019 logo. 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. Logic pro 9 manual pdf. 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. Quick movie editor. 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:UsersUserNameAppDataRoamingMicrosoftExcel
- For Windows 8/10 users: C:UsersUserNameAppDataLocalMicrosoftOfficeUnsavedFiles
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 document? Calm down and use the data recovery software 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 to help you restore the deleted Excel from your PC or other storage devices within three steps. It even enables you to recover files from emptied recycle bin.
Now, install this program and follow to see how to get your lost Excel/Word file back effortlessly.
Step 1. Launch EaseUS Office file recovery software on your computer. Choose the exact location where you lost the Office files and click the Scan button.
Step 2. The software will immediately start scanning the drive and very soon the deleted files will show up. When the process is over, you can filter the Office files by clicking 'Filter' > 'Documents'.
Excel Version 1908
Step 3. Select the Office files (e.g. Word, Excel, and PowerPoint) and click the Recover button. You can browse for a different location to save the recovered files.