Are you the one facing looking to recover an Excel file that was saved over? Well, this is a common but very irritating problem faced by the users while working on the Excel file. Here know how to recover Excel file that was save over.
Well, this is a problem faced by almost every user from time to time.
However, saving an Excel file is important as this help you save the original file and the latest changes as well.
So, Let define it best with the user experience:
I accidentally saved over a worksheet with another file. Can I recover the original? I have searched and the most recent backup is from Feb. I do not have a system that automatically backs up my files. I have tried auto recovery, restoring the system to a previous date, searching my complete
computer. Any suggestions?
Original Post from PC Review…
As I said above, saving an Excel file is important but in many cases this becomes a big problem and you pause saving the file only as you realize you have just saved the wrong file.
Or in a situation when you want to save the latest changes but want to keep the original file also.
Unluckily as you saved over the file, then how would you restore the original file?
This is really a miserable situation but the good news is that you can recover the saved over Excel file or original file.
However, it is quite challenging but Possible.
Here in this article, I will describe restore an Excel file that was saved over.
Methods to Recover Excel File That Was Saved Over
Here follow few possible working solutions for the saved over Excel file recovery.
Method 1: Undo the Changes:
Very first if your Excel file is still open, then there are chances to recover the original excel files.
Try clicking the “Undo” option in the Edit menu > until it reverts to the previous version that you are looking for.
But, if this won’t work for you and you are not having another file copy or backup then try the second solution.
You May Also Read:
- 3 Manual Ways to Recover Deleted Data from Excel Sheet
- How to Recover Unsaved/Overwritten Excel Files
- Recover MS Excel Lost Content From Temp Files
Method 2: Try the AutoRecover File
You can make use of the Excel AutoRecover feature, hope this will help you.
Follow the steps to do so:
- First click Start then > Search.
- Now choose All Files and Folders > when asked what you want to search for.
- After that Type*.xls > under All or Part of the File Name.
- And click on the arrow next to More advanced options > assure that file type reads All Files and Folders.
- Click the boxes next to Search System Folders and Search Hidden Files.
- Next Click
- Lastly, look for an earlier version of your file with the similar name.
As this appears, open it to check if it is the version you are looking for.
Method 3: Recover Previous Version
If you are using Excel 2010 and 2013, then you are having an option to restore previous versions of your Excel file.
Well, this is helpful if you can’t Undo or restore the earlier version.
Follow the steps given to restore the earlier version:
- First click on the FILE tab > on the left-hand side choose Info.
- Next, in the Manage Versions button > you can see the entire autosaved versions of your document
- Try to Recover it from there.
Excel tends to automatically saves workbook version at specific intervals but if you have made changes to the spreadsheet between the intervals > then every versions name has data and time and “autosave” note.
As you click on any of them > it opens the most current version of workbook > you can compare them and verify the changes.
Please Note: The entire earlier Autosaved versions were deleted when you close the document. So, if you want to look at the previous version, then create a backup if your data.
Well, these are some of the manual ways that might help you to recover an Excel file that was saved over.
But if none of the given solutions will help you to retrieve the saved over Excel file then make use of the automatic solution.
Automatic Solution: MS Excel Repair Tool
You can make use of the professional recommended MS Excel Repair Tool; this is the best repair utility to fix all sorts of issues, errors and corruption in the Excel file. This not only helps you to repair the corrupted Excel file but also recovers the entire data saved in it. With the help of this, you can easily restore lost Excel data such as a cell, comment, charts, worksheet properties and other related data. This is compatible with both Windows as well as Mac operating system.
Steps to Utilize MS Excel Repair Tool:
Hope the given solutions will help you to recover Excel file that was saved over.
I tried my best to put together the possible manual solutions that might work in your case.
So, make use of them and check if this helps you to restore the Excel file data.
Or else you can also make use of the automatic solution if none of the manual solutions worked in your case.
Also, I love to hear from you, so if you have any additional questions concerning the ones presented or related information or workarounds that I missed out then do tell us to know in the comments section below or you can also visit our Repair MS Excel Ask Question Ask Question