How to See Who Edited an Excel Workbook
Question details
The user needs to identify which collaborators made specific edits or modifications to a shared Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared spreadsheet and needing to review, approve, or reject team edits to maintain data integrity.
- Observed behavior
- Wants to identify individual edits, track cell changes, and view version history to manage document revisions effectively.
Before attempting to view edits, check if your workbook is a legacy shared file stored locally or a modern co-authored file saved in OneDrive or SharePoint, as this determines which tracking features are available to you.
Enable and Use the Legacy Track Changes Feature
Use the built-in Track Changes feature to monitor, highlight, and accept or reject edits made by other users in a shared workbook.
The Track Changes feature is the traditional method for tracking edits in locally shared workbooks. It highlights modified cells and logs who made the change, what the change was, and when it occurred.
Open your Excel workbook and click on the 'Review' tab located in the top ribbon menu.
Click on 'Track Changes' in the Changes group, then select 'Highlight Changes' from the drop-down menu.
In the dialog box, check 'Track changes while editing. This also shares your workbook.' Ensure the 'Who' dropdown is set to 'Everyone' or 'Everyone but me', then click 'OK'.
Once enabled, edited cells will display a small triangle in the corner. Hover over the cell to see who made the edit. To finalize, go back to 'Track Changes' and click 'Accept/Reject Changes'.
Use Version History and Show Changes for Cloud Files
For modern workbooks saved in OneDrive or SharePoint, use the Show Changes and Version History features to see recent collaboration edits.
Easily Track and Manage Workbook Edits with WPS Office
WPS Spreadsheets provides a comprehensive and user-friendly way to track changes, collaborate with your team, and review document history. It is highly compatible with Microsoft Excel formats, ensuring seamless workflow transitions while remaining lightweight and free to use.
- 1. Open Your Spreadsheet: Launch WPS Office and open the spreadsheet file you want to monitor for edits.
- 2. Navigate to the Review Tab: Click on the 'Review' tab located on the top navigation ribbon.
- 3. Enable Track Changes: Click on 'Track Changes' to activate the feature. Any modifications made by collaborators will now be highlighted.
- 4. Manage Modifications: Use the 'Accept' or 'Reject' buttons in the Review tab to systematically approve or discard edits made by your team.
Frequently Asked Questions
Why can't I see the Track Changes option in my Excel ribbon?
In newer versions of Microsoft 365, the legacy Track Changes feature is hidden by default in favor of the modern 'Show Changes' feature. To get it back, go to File > Options > Customize Ribbon, select 'All Commands' from the 'Choose commands from' dropdown, find 'Track Changes (Legacy)', and add it to your Review tab.
Does Version History show exactly what cell was changed?
Version History primarily allows you to open previous iterations of the entire file to compare against the current version. For exact cell-by-cell edits, including previous and current values, the 'Show Changes' feature in modern Excel or the legacy 'Track Changes' feature is much more effective.
Can I track changes in an Excel workbook offline?
Yes, the legacy Track Changes feature works completely offline for shared local workbooks. However, modern collaboration features like 'Show Changes' and live co-authoring require the file to be saved on OneDrive or SharePoint with an active internet connection.
