SharePoint Reports Excel File Changes Without Visible Edits
Question details
SharePoint or Excel File Activity reports that a user updated a workbook, but the Show Changes feature displays no actual modifications.
- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Reviewing file activity and checking for recent guest contributor updates in a shared Excel workbook.
- Observed behavior
- File Activity indicates a change was made, but opening the workbook reveals no visible changes, and the Show Changes pane is empty.
Ensure you have the appropriate permissions to access the SharePoint document library's version history and the Microsoft 365 unified audit log.
Compare Versions Using SharePoint Version History
Differentiate between non-visible activities and actual content modifications by checking the document's version history in SharePoint.
File Activity and Show Changes track completely different types of events. File Activity can record actions that do not produce visible cell changes, such as a user merely entering edit mode or making an unsupported change.
Navigate to the SharePoint document library where your shared Excel workbook is stored.
Right-click the Excel file in the list and select "Version history" from the context menu.
Review the list of saved versions. Open a previous version and compare it with the current workbook to determine whether any actual content was modified.
Review the Microsoft 365 Unified Audit Log
Use the administrative audit log for a detailed breakdown of specific user activities on the file.
Experience Transparent File Collaboration with WPS Office
Tired of confusing file activity reports and tracking issues in SharePoint? WPS Office offers a seamless, free alternative with built-in cloud collaboration, clear version history, and full compatibility with Microsoft Office formats.
- 1. Download WPS Office: Install the free, lightweight WPS Office suite on your preferred device.
- 2. Upload to WPS Cloud: Save your spreadsheet to WPS Cloud to enable seamless collaboration and automatic version tracking.
- 3. Track Changes Clearly: Access "History Version" directly from the file menu to see exactly who made concrete edits to your document without the clutter of background events.
Frequently Asked Questions
Why does File Activity show an update when Show Changes is empty?
File Activity records broad interactions like entering edit mode, opening the file, or making unsupported background changes. These events do not necessarily modify cell contents, which is why the Show Changes pane remains empty.
How can I see the exact changes made by a guest contributor?
The most reliable method is to review the version history in your SharePoint document library and compare the previous version with the current one to spot exact cell modifications.
Does entering edit mode without saving create a file activity record?
Yes, simply opening a file and entering edit mode can trigger a file activity event in SharePoint, even if no content is actually altered or saved by the user.
Who can access the Microsoft 365 unified audit log?
Accessing the unified audit log requires specific administrative permissions within your Microsoft 365 organization, typically granted to IT administrators.
