SharePoint Document Issues

Fix SharePoint Marking Excel Files as Modified After Viewing

Anum MushtaqAnum Mushtaq Nov 3, 2026 870 views

Question details

SharePoint spreadsheets receive new Modified timestamps and version-history entries when users merely open them to view the content.

How to Stop SharePoint from Marking Excel Files as Modified After Viewing
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Workbook

Open the affected Excel file from your SharePoint library in the Excel desktop application.

2
Navigate to Calculation Options

Go to the 'Formulas' tab on the top ribbon and locate the 'Calculation Options' button in the Calculation group.

3
Set to Manual

Select 'Manual' from the drop-down list to prevent formulas from recalculating automatically just by opening the file.

Disable Automatic Recalculation for Volatile Formulas
Manual Calculation Reminder: When Calculation Options are set to Manual, you will need to press F9 or click 'Calculate Now' to manually update your formula results.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly to continue working with zero formatting loss.
Seamlessly compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight design ensures fast file opening and saving timesCompletely free to use with a familiar, easy-to-navigate interfaceAvoids unexpected cloud syncing glitches with highly reliable local and cloud document saves
microsoft office alternative - wps office

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.