File Sharing Problems

Fix Excel SharePoint Viewers Not Seeing Real-Time Changes

Olivia MillerOlivia Miller Oct 19, 2026 868 views

Question details

Excel users with view-only permissions do not see workbook updates instantly in SharePoint, whereas users with editing permissions experience real-time co-authoring.

How to Fix Excel SharePoint Viewers Not Seeing Real-Time Changes
Product
Excel / SharePoint
Device & OS
not provided
Scenario
Users with read-only access are trying to view live updates being made to a shared Excel workbook hosted on SharePoint.
Observed behavior
Real-time changes made by editors are not automatically visible to view-only users. These users must manually refresh the page or reopen the document to see the latest updates.
Before you start

Ensure that the editor has a stable internet connection and that their changes are successfully synced to the SharePoint server before expecting viewers to see them.

Solution 1Recommended

Manually Refresh the Browser or Reopen the Workbook

Since real-time co-authoring is primarily designed for users with editing permissions, the most straightforward workaround for view-only users is to manually fetch the latest version of the workbook.

In Excel for the web or desktop via SharePoint, real-time sync connections are not persistently maintained for view-only users in the same way they are for editors. Manual refreshing is currently the expected behavior for read-only access.

1
Refresh the web browser

If you are viewing the Excel file in a web browser, click the refresh button in your browser's address bar or press the F5 key on your keyboard to reload the page and fetch the latest changes.

2
Reopen the desktop file

If you are using the Excel desktop application with view-only permissions, close the workbook entirely and open it again from the SharePoint directory to download the most recent saved version.

Manually Refresh the Browser or Reopen the Workbook
Expected Behavior: There is no built-in setting to force Google Sheets-style instantaneous real-time updates for view-only Excel users.
Free Microsoft Office alternative

Try WPS Office for Seamless Document Collaboration

If Excel's limitations on real-time syncing for read-only users disrupt your workflow, consider using WPS Office. It is a highly compatible, free alternative that makes sharing, viewing, and managing spreadsheets effortless without complex permission hurdles.

  1. 1. Download WPS Office: Visit the official WPS website and download the free desktop application for your operating system.
  2. 2. Open your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx files seamlessly with zero formatting loss.
  3. 3. Collaborate and Share: Use the built-in WPS Cloud features to easily share document links with your team for viewing and collaboration.
100% compatible with Microsoft Excel (.xlsx) formatsLightweight application with rapid file loading and renderingFree to use with a familiar, user-friendly interfaceSupports seamless cloud collaboration and simple link sharing
microsoft office alternative - wps office

Frequently Asked Questions

Why do view-only users not see real-time updates in Excel?

In Excel and SharePoint, real-time co-authoring is optimized for users with editing permissions. View-only users do not maintain the same persistent background sync connection, meaning changes aren't pushed to their screen instantaneously.

Can I enable Google Sheets-style real-time updates for view-only Excel users?

No, there is currently no standard setting in Microsoft 365 or SharePoint that forces instantaneous real-time updates for view-only users. Manual refreshing via F5 or reloading the browser is required.

Will granting comment access enable real-time syncing in Excel?

Depending on your organization's setup, giving users comment permissions might require granting them limited edit access. If they are recognized as editors, real-time syncing will activate, but it compromises the strict read-only requirement.