'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Recover an Excel File Saved Over by Mistake
Question details
The user needs to recover a previous version of an Excel workbook after accidentally saving over the original file with new data.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Accidentally overwriting an existing Excel spreadsheet and saving the changes.
- Observed behavior
- The original data is replaced by the newly saved changes, and standard undo options are no longer available.
Stop making further changes to the overwritten file and close it if possible, as continued editing may overwrite temporary files or version history caches needed for recovery.
Restore Using Excel Version History
If your file is synced with OneDrive or SharePoint, Excel automatically saves previous versions of your document.
Cloud-synced files natively support Version History, allowing you to easily browse and restore older iterations of your workbook. This is the most reliable method if AutoSave was turned on.
Open the overwritten Excel file. Click on 'File' in the top-left corner, then select 'Info'. Click on 'Version History'.
A side panel will appear on the right side of the screen displaying past versions organized by date and time.
Click 'Open version' under the specific timestamp you want to recover. Once it opens, click the 'Restore' button at the top of the window to overwrite the current file, or 'Save a Copy' to create a new file.
Recover Using Windows File History
If you have Windows backup or File History enabled, you can restore previous file states directly from File Explorer.
Check Manage Workbook and Document Recovery
Excel's built-in recovery tools might have retained a temporary copy of the file before it was fully overwritten.
Easily Manage File Versions with WPS Spreadsheet
WPS Office offers robust auto-backup and version history features, ensuring your spreadsheets are continuously saved and easily recoverable even if accidentally overwritten.
- 1. Open Backup Management: In WPS Spreadsheet, go to 'Menu' in the top left, click 'Backup and Recovery', then select 'Auto Backup'.
- 2. Browse local backups: Click 'Local Backup' to open the backup directory and browse folders for previous automatic saves of your overwritten file.
- 3. Use Cloud Version History: If you use WPS Cloud, click 'File', go to 'File Information', select 'Version History', and choose an earlier backup timestamp to restore.
Frequently Asked Questions
Can I recover an overwritten Excel file if I don't use OneDrive?
Yes. If you have enabled Windows File History or Windows System Restore, you can right-click the file in File Explorer, select 'Properties', and check the 'Previous Versions' tab to find an older copy.
Why is my Excel Version History empty?
Version History is generally only available for files saved to cloud services like OneDrive or SharePoint. If the file is saved purely on your local hard drive without a backup system enabled, the history will be empty.
Does the Undo command work after saving the Excel file?
In standard desktop Excel, saving a file and closing it clears the Undo history. If the file is still open, you might be able to press Ctrl+Z to undo changes, but once closed and reopened, the previous state is lost.
Where are Excel temporary files stored?
Excel temporary files are typically stored in 'C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles'. You can check this folder for potentially recoverable drafts if the system created an autosave prior to overwriting.
