How to See Which Collaborator Changed Cells in Excel Version History
Question details
The user wants to track specific edits made to an Excel workbook stored in OneDrive, including finding out the user, timestamp, previous cell value, and new cell value.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared spreadsheet and needing to review specific historical cell modifications made by different team members.
- Observed behavior
- Standard version history compares entire saved versions but does not clearly identify individual cell edits, authors, and previous values at a granular level.
Ensure your Excel workbook is currently saved and synced to OneDrive or SharePoint, as detailed cell-level tracking features require active cloud storage to function.
Use the Show Changes Feature in Excel
The most effective way to identify exactly who changed specific cells, along with the timestamps and previous values, is by using the dedicated Show Changes pane.
Unlike the general Version History, the Show Changes feature provides a detailed, cell-by-cell audit trail of modifications made to your workbook by any collaborator.
Launch your workbook in Excel for the Web or a supported Microsoft 365 desktop version of Excel.
Click on the Review tab located in the main ribbon at the top of the application window.
Click the 'Show Changes' button. A pane will appear on the right side of the screen.
Scroll through the pane to see a chronological list of changes, displaying the changed cells, the previous and new values, the user responsible, and the date and time.
Use Version History to Compare Saved Versions
If you need to view the overall state of the document at a specific point in time rather than individual cell edits, use the standard Version History.
Easily Track Collaborator Edits in WPS Spreadsheet
WPS Office provides robust Track Changes and document collaboration features, allowing you to easily see who edited your spreadsheets, review modifications, and accept or reject changes.
- 1. Open your spreadsheet: Launch WPS Office and open your shared spreadsheet.
- 2. Access Track Changes: Navigate to the Review tab on the main ribbon interface.
- 3. Enable Highlight Changes: Click on Track Changes and select Highlight Changes to begin monitoring edits.
- 4. Set tracking criteria: Specify the criteria (Who, When, Where) in the dialog box to filter and see exact modifications made by specific collaborators.
- 5. View cell history: Hover your mouse over any highlighted cell to instantly view a tooltip containing the author's name, timestamp, and the original value.
Frequently Asked Questions
Why is the Show Changes button grayed out in Excel?
The Show Changes feature requires the workbook to be saved in a cloud location like OneDrive or SharePoint. If your file is saved locally on your computer's hard drive, this button will be disabled.
How long does Excel keep the record of changes in a shared workbook?
Excel typically retains the detailed change history for up to 60 days for files stored in OneDrive or SharePoint. If you need a permanent record of the document's state, it is recommended to periodically save backup copies.
Can I see changes made to charts or formatting using Show Changes?
No, the Show Changes pane primarily tracks edits made to cell values and formulas. It does not currently track visual formatting changes, hidden rows, or modifications made to charts, images, and shapes.
How can I filter the changes to only see edits made by a specific person?
In the Show Changes pane on the right side of your screen, click the Filter icon (funnel shape) at the top of the pane. From there, you can select specific collaborators to only display the cell edits made by those users.
