You may have accidentally deleted a critical formula or overwritten a section of your workbook. This data loss often happens during collaborative editing or when you forget to save a copy. Excel’s version history feature automatically saves snapshots of your file. This article explains how to access these past versions and restore your lost information.
Key Takeaways: Recovering Data with Version History
- File > Info > Version History: Opens a panel showing all auto-saved versions of a workbook stored in OneDrive or SharePoint.
- Restore button in the version panel: Replaces your current workbook file with the selected older version.
- Open Version in a new window: Lets you view and copy specific data from a past version without altering your current file.
How Excel Version History Works
Version history is a feature for files saved to Microsoft’s cloud services like OneDrive, OneDrive for Business, or SharePoint Online. It does not work for files stored only on your local computer’s hard drive. When AutoSave is turned on, Excel automatically saves changes to the cloud file. Each significant edit creates a new entry in the version history log.
These versions are not full copies of the file. They are incremental snapshots that record changes. This system allows you to browse and restore from many points in time without using excessive storage space. You can see who made changes and when, which is essential for team projects.
Prerequisites for Using Version History
Your Excel file must be saved to a supported cloud location. Check the file name in Excel’s title bar. It should show “OneDrive” or your organization’s name, not a local path like “C:\Users”. You must also be signed in with the Microsoft account that owns the file or has permission to edit it. The AutoSave toggle in the top-left corner should be On, indicated by a green slider.
Steps to View and Restore a Previous Version
Follow these steps to recover deleted data from an earlier version of your workbook.
- Open the workbook and go to File
Open the Excel file where data was lost. Click the File tab in the top-left corner to go to the Backstage view. - Select Info and click Version History
In the left-hand menu, select Info. On the right, you will see a button labeled Version History. Click this button. A new panel will open on the right side of your Excel window. - Browse the list of saved versions
The version history panel shows a list of auto-saved versions, sorted by date and time. Each entry shows the timestamp and the name of the person who saved that version. Hover over a version to see a preview thumbnail. - Open the version you want to inspect
Click on the timestamp for the version you believe contains your lost data. This opens that version in a new, separate Excel window. The window’s title will say “[Read-Only]” to prevent accidental changes to the historical file. - Copy the data or restore the entire file
In the read-only window, select and copy the cells, charts, or sheets you need. Switch back to your current workbook and paste the data. To revert the entire file to that older version, click the Restore button at the top of the yellow banner in the read-only window.
Method for Restoring via OneDrive.com
You can also restore versions directly in your web browser. This is useful if Excel is not installed on your current device or if the file won’t open.
- Navigate to your file on OneDrive.com
Open a web browser, go to onedrive.live.com, and sign in. Browse to the location of your Excel file. - Open the file’s version menu
Right-click on the Excel file and select Version history from the context menu. Alternatively, click the file once to select it, then click Version history in the toolbar at the top of the page. - Review and restore
A panel will list all saved versions. You can click a version to download it as a separate file, or select a version and click Restore to make it the current file.
Common Mistakes and Limitations
Version History Option is Grayed Out or Missing
This means your file is not stored in a cloud location that supports this feature. Save a copy of your file to your OneDrive or SharePoint folder first. Open the local file, go to File > Save As, and choose your OneDrive as the location. After saving, the Version History button should become active.
AutoSave Was Turned Off
If the AutoSave toggle was off, Excel only saved versions when you manually clicked Save. The version history will be much less frequent, and you may not have a snapshot from the moment before your data was deleted. Always ensure AutoSave is on for important collaborative work.
Recovering Data From a Very Old Version
OneDrive and SharePoint retain a finite number of versions for a limited time. Typically, you can access many versions from the last 30 days, but older ones may be automatically cleaned up. For long-term, point-in-time recovery, you should use File > Save As to create manual backup copies with different names.
Version History vs. Other Recovery Methods
| Item | Version History (AutoSave) | Recover Unsaved Workbooks |
|---|---|---|
| Primary Use | Recover past versions of saved cloud files | Recover files that were never saved |
| Storage Location | OneDrive or SharePoint Online | Local temporary folder on your PC |
| Access Path | File > Info > Version History | File > Open > Recover Unsaved Workbooks |
| Data Retention | Many versions over approx. 30 days | Unsaved files for up to 4 days |
| Best For | Rolling back changes or recovering deleted data from a saved file | Restoring work after a crash before first save |
You can now recover deleted formulas, tables, or text by restoring a previous version from your cloud storage. For critical work, periodically use Save As to create a named backup in a different folder. An advanced tip is to use the Compare and Merge Workbooks feature under the Review tab to integrate changes from a restored version into your current file, instead of fully replacing it.