Fix SharePoint Marking Excel Files as Modified After Viewing
Question details
SharePoint spreadsheets receive new Modified timestamps and version-history entries when users merely open them to view the content.

- Product
- SharePoint, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing an Excel file stored in a SharePoint document library without intentionally making any edits.
- Observed behavior
- Opening the file automatically triggers an update to the 'Modified' and 'Modified By' values and creates a new version history entry, likely due to background recalculations or check-in/out actions.
Verify whether your Excel workbook contains volatile formulas like TODAY() or NOW(), and ensure you have the correct administrative permissions if you need to view SharePoint audit logs.
Disable Automatic Recalculation for Volatile Formulas
Volatile formulas such as TODAY() automatically recalculate whenever the file is opened, which SharePoint registers as a modification to the file's data.
If your workbook contains formulas that depend on the current time or date, Excel recalculates them upon opening. When auto-save is enabled or the file syncs back to SharePoint, these recalculations are saved as edits.
Open the affected Excel file from your SharePoint library in the Excel desktop application.
Go to the 'Formulas' tab on the top ribbon and locate the 'Calculation Options' button in the Calculation group.
Select 'Manual' from the drop-down list to prevent formulas from recalculating automatically just by opening the file.

Check SharePoint Audit Logs for Background Actions
Sometimes background processes or check-in and check-out actions update the modified timestamp without visible user edits.
Try WPS Office for a Streamlined Spreadsheet Experience
If complex SharePoint synchronization bugs and Microsoft Excel auto-recalculation issues are slowing down your team's workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, ensuring smooth spreadsheet management without unexpected background changes.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly to continue working with zero formatting loss.

Frequently Asked Questions
Why does the TODAY formula change the modified date in SharePoint?
The TODAY() function is volatile, meaning it is designed to recalculate the current date every time the file is opened. SharePoint detects this recalculation as a change to the file's underlying data, which consequently updates the modified timestamp and creates a new version.
Does purely viewing an Excel file on SharePoint create a new version?
Normally, purely viewing a file does not create a new version or change the modified date. However, if the file contains volatile formulas, has active automated workflows, or if a user checks the file out and back in without editing, SharePoint will register these actions as a modification.
How can I check who modified the SharePoint file if no visible changes were made?
You can review the file's activity through SharePoint Audit Logs located in the Site Collection Administration settings. This log tracks all actions including opening, downloading, editing, checking in, and checking out, helping you pinpoint what triggered the update.




