'%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 View Excel for Web Edit History Beyond the 60-Day Limit
Question details
The user wants to know if there is a way to retain, extend, or download workbook edit history in Excel for the Web beyond the default 60-day limitation.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to access, review, or export workbook edit history that occurred more than 60 days ago.
- Observed behavior
- The 'Show Changes' feature strictly limits visible edits to the last 60 days and lacks a built-in option to extend the retention period or download the edit log.
Ensure your Excel workbook is saved and fully synced to OneDrive or SharePoint, as these cloud platforms manage the underlying version history of your files.
Use SharePoint or OneDrive Version History
Since the Show Changes feature is restricted to a 60-day window, rely on SharePoint or OneDrive's built-in versioning to access and restore older iterations of your workbook.
While the 'Show Changes' pane provides a convenient way to track recent cell-level edits, it systematically removes records older than 60 days. To view older states of your file, you must access the broader file version history managed by SharePoint or OneDrive.
Open the SharePoint document library or OneDrive folder where your Excel workbook is currently saved.
Right-click the Excel file and select 'Version history' from the context menu.
Browse the list of saved file versions. Click the ellipsis (three dots) next to an older date, and choose 'Open' to view the historical file or 'Restore' to revert to it.
Try WPS Office for Seamless Spreadsheet Management
If you frequently encounter limitations with web-based editors, consider switching to WPS Office. It provides a robust, lightweight desktop alternative with excellent offline performance, integrated cloud backups, and comprehensive file management tools.
Frequently Asked Questions
Does editing a file near the 60-day limit extend the Show Changes history?
No, editing a workbook near the 60-day limit does not extend the retention period for older changes. Any edits older than 60 days will systematically drop off the Show Changes pane regardless of recent activity.
Can I download the Show Changes history to a local file?
Currently, Excel for the Web does not provide a built-in feature to export or download the Show Changes history log as a separate document or spreadsheet.
How can I keep track of changes permanently?
To keep a permanent record, you can periodically 'Save As' to create copies of your workbook with date stamps, or rely on SharePoint's version history by configuring it to retain an unlimited or high number of major versions.
