'%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 Workbook Saved at a Specific Time
Question details
The user needs to restore an Excel workbook to a specific previous version saved at a particular time during the day.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user has saved an Excel file multiple times throughout the day and needs to revert to a specific time, such as 3:30 p.m. or 4:30 p.m.
- Observed behavior
- The user wants to locate and restore a historical version of the workbook corresponding to the exact time they need.
Ensure you know where your Excel file was saved, as the recovery method differs between locally saved files and those stored on OneDrive or SharePoint. Close any unsaved documents to prevent overwriting your current progress.
Use Version History for Cloud-Saved Files
If your file is saved on OneDrive or SharePoint with AutoSave enabled, this is the most reliable way to recover a file from an exact time.
Launch Excel and open the workbook. Click on 'File' in the top-left corner, go to 'Info', and select 'Version History'.
A panel will appear on the right side of your screen displaying past versions with their save times. Scroll through the list to find the version saved around your target time.
Click 'Open version' to view the historical file. You can then click 'Restore' to replace your current version with this one, or simply copy the needed data to paste into your current working file.
Check Excel AutoRecover for Locally Saved Files
If your file is stored on your local drive and Excel closed unexpectedly, you might find a recently autosaved version.
Restore Using Windows File History
If you have Windows File History or Windows Backup configured for your local folders, you can retrieve earlier timestamps of your file.
Easily Manage File Versions with WPS Office
WPS Office provides a robust Local Backup and File Roaming feature, making it incredibly easy to track your document's history and restore spreadsheets to a specific time without relying on third-party cloud services.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your current document.
- 2. Access Backup Center: Click on 'Menu' (or the 'File' tab), navigate to 'Backup and Recovery', and select 'Backup Center'.
- 3. Find Local Backups: Click on 'Local Backup' to view a comprehensive list of automatically saved versions of your files.
- 4. Restore specific time: Locate the file with the exact time stamp you need, double-click it to preview, and save it to restore your data.
Frequently Asked Questions
Why is the Version History button greyed out in Excel?
The Version History feature in Microsoft Excel is only active for files saved in cloud storage solutions like OneDrive or SharePoint with AutoSave enabled. If your file is saved locally on your computer's hard drive, this option will be disabled or unavailable.
Does Excel keep hourly versions of locally saved files?
No, Excel does not automatically retain hourly historical versions for locally stored files. To recover older versions of local files, you must rely on system-level backups like Windows File History or manually save distinct versions throughout the day.
Can I recover an overwritten Excel file without a backup?
If the file was saved locally and overwritten without AutoRecover or Windows File History enabled, it is highly unlikely to be recovered. It is recommended to always ensure AutoSave or Local Backup features are turned on to prevent permanent data loss.
