'%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 Deleted Excel Data After Saving a File
Question details
The user needs to recover data that was accidentally deleted from an Excel file which was subsequently saved.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accidental data deletion followed by saving the workbook, requiring version recovery.
- Observed behavior
- The saved file no longer contains the deleted data, and the standard undo function is no longer available to restore it.
Immediately stop editing the file and make a copy of its current state to prevent further overwriting of any recoverable data fragments.
Restore Previous Version using Excel Version History
Use this method if your file is synced to OneDrive or SharePoint, as it automatically keeps track of previous versions.
Cloud-synced files on OneDrive or SharePoint retain a robust version history, allowing you to seamlessly roll back to a point before the deletion occurred.
Click on 'File' in the top ribbon, navigate to 'Info', and select 'Version History'.
Browse the list of previous versions displayed in the right pane, looking at the timestamps to find one right before the data was deleted.
Click 'Open version' on the target timestamp, review the data to ensure your deleted content is present, and then click 'Restore' to overwrite the current file.
Check Excel AutoRecover Files
If you don't use cloud storage, Excel's built-in AutoRecover feature might have saved an earlier snapshot of your workbook.
Restore from File Explorer Previous Versions
Ideal for business users connected to a network drive or those with Windows File History enabled locally.
Prevent Data Loss with WPS Office's Built-in Backup Center
Tired of losing data when accidentally saving over your Excel files? WPS Office offers a powerful, built-in Backup Center that automatically saves local versions of your spreadsheets. It's a free, lightweight, and highly compatible alternative to Microsoft Office.
- 1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files directly; your formatting and formulas will remain intact.
- 3. Enable Local Backup: Go to Menu > Settings > Backup Setting to configure automatic local backups, ensuring you can always roll back to an earlier version.
Frequently Asked Questions
Can I recover an overwritten Excel file if I don't use OneDrive?
Yes, if you have Windows File History enabled or your file is saved on a backed-up network drive, you can right-click the file in File Explorer and select 'Restore previous versions'. Alternatively, you can check Excel's AutoRecover folder for temporary background saves.
Where are Excel AutoRecover files stored on my computer?
By default on Windows, Excel AutoRecover files are stored in C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can check this folder for temporary files that might contain your lost data.
Are third-party data recovery tools effective for overwritten Excel files?
Third-party tools excel at recovering completely deleted files from a hard drive, but they are generally less effective for recovering specific data that has been overwritten and saved within an existing file. They should only be considered as a last resort.
How can I prevent losing overwritten data in the future?
You can prevent data loss by enabling AutoSave via OneDrive or SharePoint. Alternatively, you can configure Excel to always create a backup copy by going to 'Save As', clicking 'Tools', selecting 'General Options', and checking the 'Always create backup' box.
