How to Access Older Excel Version History
Question details
The user wants to access or recover older versions of an Excel workbook that are no longer displayed in the standard version history pane.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to retrieve a past version of a workbook that has been heavily edited, overwritten, corrupted, or deleted.
- Observed behavior
- The desired older version does not appear in Excel's native Version History pane because it exceeds the retained limit of the storage service.
Ensure you are logged into the Microsoft account associated with the OneDrive where your Excel file is saved. Note that personal accounts retain the last 25 versions, while Microsoft 365 accounts offer broader recovery options up to 30 days.
Check OneDrive Web Version History
Directly check the OneDrive web interface, which may display versions not visible within the Excel desktop application.
Excel relies on OneDrive to store and manage file versions. By accessing OneDrive directly through your web browser, you can view the complete list of available retained versions for your document.
Open your web browser, navigate to the OneDrive website, and sign in with your Microsoft account.
Browse your files or use the search bar to find the specific Excel workbook you need to restore.
Right-click the Excel file and select 'Version history' from the context menu.
Review the list of available versions. Click on the three dots next to the desired version and choose 'Restore' to replace the current file, or 'Open File' to view it without overwriting.

Use 'Restore your OneDrive' (Microsoft 365 Subscribers)
Use this feature to roll back your entire OneDrive to a previous state if the file is severely corrupted or the specific version is missing.
Manage Your Spreadsheets Safely with WPS Office
If managing versions and recovering files in Microsoft Excel feels restrictive, try WPS Office. It provides a lightweight, highly compatible alternative with excellent local backup and document safety features, allowing you to easily recover and manage spreadsheet versions without complex cloud limitations.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open any existing Excel files seamlessly without losing formatting.
- 3. Enable Auto-Backup: Go to Settings > Backup Settings to customize your local version history and backup frequency for added security.

Frequently Asked Questions
Can I change a setting in Excel to keep more version history?
No, Excel does not have a built-in setting to increase the number of retained versions. The version history limit is controlled entirely by your storage provider, such as OneDrive or SharePoint.
How many versions does a personal Microsoft account retain?
A personal Microsoft account typically retains the 25 most recent versions of a file. Once this limit is reached, older versions are automatically deleted to save cloud storage space.
What if the version I need is older than 30 days?
If the version is older than 30 days and you are using OneDrive, it may be permanently lost unless you have saved a separate local copy. In corporate environments, contact your IT administrator to check if SharePoint retention policies allow for deeper recovery.
Why does my Excel file show no version history at all?
Version history requires the file to be actively synced and saved in a supported cloud service like OneDrive or SharePoint. If your file is saved strictly on your local hard drive, Excel cannot track or display its version history.




