How can you recover the excel file that was accidentally overwritten?
“I accidentally overwritten an Excel file and saved it, if there’s any way I can help myself recover it? “
Replacing an excel or word file on a PC is no longer a new problem for most Windows users. However, it is still a difficult problem to solve for most common users, so… what can you do if you overwrite an excel or word file?
In the next part you will have 2 reliable methods to try to recover the overwritten excel file, also applies to recovering a word document that has been replaced.
It does not make any operation to your PC once you have overwritten your excel or word file. Try method 1 or 2 first to recover your overwritten excel file.
Method 1. Search for and recover overwritten excel files from temporary files
Generally when editing an excel file, the Excel application will automatically create some temporary files in a specific location on your computer. Then, we can try to find the excel file overwritten from these temporary files, for this:
1.Locate the location of the temporary excel files
For Windows 7 users:
Use me, AppData, Microsoft Excel.
For users of Windos 8/10:
How do you use the local Microsoft Office? Files.
2.Change temporary files from excel to normal
Look for temporary excel files that start with “$” or “~” and end with “.TMP”, select the correct excel file by date, copy it and save it to another safe place, then change the extension from .TMP to .XLS / .XLSX. ( . DOC / .DOCX when dealing with a Word file)
Method 2. Retrieve the Excel/Word file overwritten from the previous version
- Create a new excel file with the same name as your lost excel file;
- 2. Right-click the excel file and select Properties;
- 3. Go to Previous Versions, search and select the latest version before overwriting your Excel file, then click Restore.
Then you will have restored your excel file from the previous version.
Extra tip: Recover lost/removed/overwritten excel file with file recovery software
The other option you can try is to use a powerful data recovery software to recover lost excel or word documents.
Here you can try EaseUS Data Recovery Wizard to scan your PC finding unsaved, deleted, lost or overwritten excel files.
Start this EaseUS data recovery software and select the location where the lost excel file is, then click “Scan“.
Step 2. EaseUS Data Recovery Wizard will start a quick scan to find deleted excel files, then run another deep scan automatically to find more lost excel files.
Step 3. After you finish scanning, you can preview the files you’ve found, and search for what you want by different types or by using the custom search box.
In the last step you must save the recovered excel file in a different place from the original to avoid overwriting data again.