'%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 Lost Excel Data from a Previous Version
Question details
The user needs to recover data from an Excel workbook that was lost after copying worksheets, accepting a merge warning, or accidentally overwriting the file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Data disappeared or was overwritten during routine spreadsheet tasks, requiring a rollback to an older file state.
- Observed behavior
- The current Excel file is missing crucial data or has been replaced, and the user must locate and restore a previous version of the workbook.
Determine whether your Excel workbook was saved locally on your computer's hard drive or synced to a cloud platform like OneDrive or SharePoint, as the recovery steps differ significantly based on the storage location.
Recover Excel Data Using OneDrive Version History
Use this method if your Excel file was saved to OneDrive or SharePoint and AutoSave was enabled.
Microsoft 365 automatically saves versions of your files when they are stored in OneDrive or SharePoint. This allows you to easily look back and restore a specific snapshot before the data loss occurred.
Launch Microsoft Excel and open the affected workbook from your OneDrive or SharePoint folder.
Click on the file name at the very top of the application window (the title bar) and select 'Version History' from the dropdown menu. Alternatively, click 'File' > 'Info' > 'Version History'.
A Version History pane will appear on the right side of the screen. Review the list of available versions sorted by date and time.
Click 'Open version' under the timestamp that contains your lost data. Once the older version opens, click the 'Restore' button below the ribbon to replace the current file with this previous version.
Recover an Earlier Version of a Local Excel File
Use this method for local workbooks that rely on AutoRecover or Windows File History backups.
Restore the Entire OneDrive or Contact Administrator
If individual file version history fails, you may need to perform a bulk restore or seek administrative assistance.
Prevent Data Loss with WPS Office's Built-in Backup
Don't let accidental overwrites ruin your hard work. WPS Office is a highly compatible, free alternative to Microsoft Office that includes robust Auto Backup and Local Version History features, ensuring your spreadsheet data is always safe without requiring complex cloud configurations.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and easily open your existing Excel workbooks without losing any formatting.
- 3. Enable Auto Backup: Navigate to Menu > Settings > Backup Setting to activate local Auto Backup, guaranteeing that every version of your work is securely saved.
Frequently Asked Questions
Why is my Excel Version History greyed out?
Version History is only available if your Excel workbook is saved and synced to a Microsoft cloud service like OneDrive or SharePoint. If the file is stored locally on your hard drive, the Version History button will be inactive.
Where are AutoRecover files saved in Windows?
By default, AutoRecover files in Windows are saved in a hidden system folder located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can paste this path into File Explorer to manually check for temporary backups of your lost workbooks.
Can I recover an Excel file that was completely overwritten without OneDrive?
Yes, but it depends on your system settings. If you have Windows File History or System Restore enabled, you can right-click the overwritten file in File Explorer, select 'Properties', and check the 'Previous Versions' tab to restore a snapshot taken by Windows.
Does WPS Office have a version history feature?
Yes, WPS Office includes a robust Backup Center. You can easily access previous iterations of your spreadsheets by navigating to Menu > Backup and Recovery > Local Backup or Cloud Backup, allowing you to restore data even if you aren't using OneDrive.
