'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can Read-Only Excel Users See SharePoint Changes in Real Time?
Question details
The user wants to know if participants with read-only access can view real-time updates in a shared Excel workbook hosted on SharePoint.
- Product
- Microsoft Excel / SharePoint
- Device & OS
- not provided
- Scenario
- Collaborating on an Excel workbook in SharePoint where some users have read-only access.
- Observed behavior
- Read-only users cannot enable AutoSave or reliably see live updates made by other users in real-time.
Verify the current permission levels of the users accessing your shared SharePoint Excel workbook to understand their editing and viewing capabilities.
Understanding Excel Co-authoring Permissions
Clarify why read-only users cannot see real-time changes and what permissions are actually required.
Excel AutoSave and real-time co-authoring features are deeply integrated with the editing experience in SharePoint. These features rely on a continuous synchronization protocol between the client and the server.
Currently, users must have Edit permissions to participate in the live co-authoring session. Without Edit permissions, the real-time syncing mechanism remains disabled, preventing read-only viewers from seeing changes as they happen.
Navigate to your SharePoint document library, select the Excel file, and click 'Manage Access' to verify if the user has View or Edit rights.
Acknowledge that 'View Only' or 'Read-Only' access prevents the live data connection required for real-time updates.
Since there is currently no supported workaround, submit this requirement through the Microsoft Feedback Portal if it is critical for your workflow.
Alternative Workaround: Grant Edit Access and Protect Sheets
Grant users edit access to enable real-time syncing, but use Excel's native protection to prevent unwanted changes.
Collaborate Smoothly with WPS Office
If you are looking for a highly compatible, lightweight, and cost-effective office suite, WPS Office provides excellent document tools, a familiar interface, and seamless compatibility with Microsoft Excel formats.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package for your operating system.
- 2. Install and launch: Follow the on-screen instructions to install the software, then open WPS Spreadsheets.
- 3. Open your Excel files: Simply drag and drop your existing .xlsx files into WPS Office to continue working without formatting loss.
Frequently Asked Questions
Why doesn't AutoSave work for read-only Excel files?
AutoSave requires a continuous sync connection to the cloud, which is only established when a user has Edit permissions to write changes back to the server.
Can I manually refresh a read-only Excel file in SharePoint to see changes?
Yes, users with read-only access can manually reload the webpage or re-open the workbook to fetch the latest saved version, but this does not provide a live, real-time feed.
Does Excel Online support real-time viewing for read-only users?
No, the web version of Excel shares the same limitation. Real-time co-authoring indicators and live cell updates only appear for users actively editing the document.
