Fix Excel SharePoint Viewers Not Seeing Real-Time Changes
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.

- 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.
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.
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.
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.
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.

Adjust Permissions to Allow Co-Authoring
If instantaneous updates are critical for your workflow, you may need to grant users edit access, which enables the native real-time co-authoring feature.
Test with a New File and Contact Support
If changes fail to sync even after refreshing the page, or if editors are also not seeing real-time updates, there may be a service or tenant configuration issue.
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. Download WPS Office: Visit the official WPS website and download the free desktop application for your operating system.
- 2. Open your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx files seamlessly with zero formatting loss.
- 3. Collaborate and Share: Use the built-in WPS Cloud features to easily share document links with your team for viewing and collaboration.

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.




