'%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)
Fix Excel Version History Not Available or Showing Error
Question details
The user is unable to access previous versions of an Excel file and encounters an error stating there was a problem getting the version history.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to restore or view a previous version of an Excel document to recover lost data or reverse recent changes.
- Observed behavior
- Excel displays the message 'There was a problem getting the version history' or the version history option is completely unavailable or greyed out.
Verify that your computer is connected to a stable internet network, as accessing cloud-based version history requires an active connection to Microsoft servers.
Access Version History Through OneDrive Online
If the desktop app fails to load the history due to synchronization issues, accessing the file directly through OneDrive on the web often bypasses local app errors.
Excel's Version History relies heavily on the OneDrive synchronization client. When the local client encounters a sync error or temporary glitch, the desktop application fails to retrieve previous file states. By logging directly into the web interface, you can access the server-side copies directly.
Open your preferred web browser, navigate to the official OneDrive website, and log in using the Microsoft account associated with your Office subscription.
Navigate through your online folders to find the specific Excel spreadsheet you want to restore.
Right-click the Excel file and select 'Version history' from the context menu. A side panel or new page will open showing all saved iterations.
Click the three vertical dots next to the version you want, then choose 'Restore' to overwrite the current file, or 'Download' to save a separate copy to your local drive.
Ensure the File is Saved to a Supported Cloud Location
Excel's Version History feature exclusively works for files saved in Microsoft's cloud storage. Moving your local file to OneDrive will enable this feature for future edits.
Check Your Microsoft Account Sign-in Status
You might be signed out of your Office applications or experiencing an account authentication error, which blocks Excel from retrieving your cloud data.
Try WPS Office for Seamless File Management and Auto-Backup
If you are frustrated by Microsoft Excel's cloud sync issues, account errors, and unavailable version history, WPS Office offers a powerful, lightweight, and highly compatible alternative. Enjoy built-in local and cloud auto-backups without the expensive subscription fees, ensuring your data is always safe and recoverable.
- 1. Download and Install: Visit the official WPS website, download the free installer, and complete the quick installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open any existing Excel files.
- 3. Enable Local Auto-Backup: Go to Menu > Options > General and Save to customize your automatic backup intervals, ensuring you never lose your progress again.
Frequently Asked Questions
Why is the Version History button greyed out in Excel?
The Version History button is greyed out if your file is saved locally on your computer instead of on a supported cloud service like OneDrive or SharePoint. It can also appear greyed out if you are currently signed out of your Microsoft 365 account in the Excel application.
Can I recover previous versions of locally saved Excel files?
Excel's native Version History only works for cloud-hosted files. However, you might be able to recover local files using Windows File History. Right-click your Excel file in Windows File Explorer, select 'Properties', and check the 'Previous Versions' tab to see if Windows has saved an older copy.
Does AutoRecover work if Version History is unavailable?
Yes, AutoRecover is a separate built-in safety feature designed to save temporary backup copies of your active files in the event of a sudden app crash or power loss. You can find these temporary files by navigating to File > Info > Manage Workbook > Recover Unsaved Workbooks.
How long does OneDrive keep version history for Excel files?
For personal Microsoft accounts, OneDrive typically retains file version history for 30 days. For enterprise or business accounts using SharePoint, the system can retain up to 500 versions depending on the retention policies configured by your organization's IT administrator.
