How to Undo Multiple Changes in a Shared Excel Workbook
Question details
The user needs to reverse or review major changes made earlier in a shared Excel workbook after refreshing clears the normal Undo command.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook where multiple changes were made, and the workbook was recently refreshed or synced.
- Observed behavior
- The standard Undo command is no longer available to revert major changes made earlier in the day.
Ensure your shared Excel workbook is saved to OneDrive or SharePoint, as modern collaborative features like Show Changes and Version History require cloud storage to function properly.
Review and Revert Edits Using the Show Changes Feature
Use Excel's built-in Show Changes pane to track who made specific edits and identify what needs to be manually reverted.
When co-authoring an Excel workbook, the standard Undo action may clear after a sync. The Show Changes feature provides a detailed log of recent edits, allowing you to see exactly what changed, who changed it, and when.
Open your shared workbook in Excel for the Web or Microsoft 365 and navigate to the Review tab on the main ribbon.
Click on the Show Changes button to open the changes pane on the right side of your screen.
Review the list of recent edits. You can narrow down the history by highlighting a specific cell, range, or worksheet to only see changes made in that area.
Using the detailed before-and-after values provided in the pane, manually type in the previous data to revert the unwanted changes.
Restore an Earlier File Version
If too many unwanted changes were made to correct manually, reverting the entire workbook to a previous version is the most efficient solution.
Use WPS Office for Seamless Collaboration and Version Control
If you frequently encounter issues managing shared workbooks and version histories in Microsoft Excel, consider WPS Office. It provides a lightweight, highly compatible, and free alternative with robust cloud collaboration features to keep your team's edits organized.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your Windows, Mac, or mobile device.
- 2. Upload to WPS Cloud: Save your spreadsheet to WPS Cloud and share the collaboration link with your team to enable real-time co-authoring.
- 3. Track and Restore Versions: Access the Historical Version feature in WPS Spreadsheet to easily track team edits and restore earlier file states whenever needed.
Frequently Asked Questions
Why is the Undo button grayed out in my shared Excel workbook?
In co-authoring mode or older legacy shared workbooks, the local Undo history is often cleared whenever the file syncs or refreshes to pull in changes from other users. This prevents conflicting actions but disables the standard Undo button.
Can I use the Undo shortcut to reverse changes made by another user?
No, you cannot use the standard Undo shortcut (Ctrl+Z) to reverse someone else's changes. You must use the Show Changes pane to identify the edit and manually correct it, or restore a previous version of the workbook.
How long does Excel keep the version history for shared workbooks?
For files stored on OneDrive or SharePoint, Microsoft typically retains version history for up to 30 days, allowing you to view and restore any changes made within that timeframe.
Does the legacy Track Changes feature still work in modern Excel?
The legacy Track Changes feature has been largely replaced by co-authoring and the Show Changes pane in Microsoft 365. However, it can still be accessed by customizing the Quick Access Toolbar if it is required for older workflows.
