'%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)
Why View-Only Users Cannot See Live Changes in Shared Excel Workbooks
Question details
Users want to know if individuals with view-only access can see real-time updates and cursor positions when others edit a shared Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook in real-time.
- Observed behavior
- Users with 'View Only' permissions are unable to see live changes or the cursor positions of other co-authors.
Verify your internet connection and ensure the shared Excel workbook is saved in a supported cloud location like OneDrive or SharePoint Online.
Grant Edit Permissions to Enable Live Co-Authoring
To allow users to see real-time changes, cursor positions, and participate in co-authoring, they must be granted 'Edit' access.
This behavior is by design in Microsoft Excel. 'View Only' mode disables real-time syncing of edits and cursor tracking to optimize performance and prevent unauthorized modifications. Enabling live co-authoring requires the user to have full editing capabilities.
Open the shared workbook in Excel Desktop or Excel for the Web, then click on the 'Share' button located in the top-right corner of the window.
In the sharing pane or dialog box, find the specific user or group in the list of people who have access to the file.
Click the dropdown menu next to their name and change their permission level from 'Can view' to 'Can edit'.
Click 'Apply' or 'Save' to update their access. Have the user close and reopen the workbook to refresh their permissions and enable live tracking.
Experience Seamless Co-Authoring with WPS Office
Looking for a smoother collaboration experience without the complex permission hurdles? WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. With WPS Cloud, you can effortlessly share spreadsheets, manage permissions, and collaborate with your team in real time.
- 1. Download and install: Download WPS Office for free from the official website and install it on your device.
- 2. Upload your file: Open your existing Excel file in WPS Spreadsheet and save it directly to WPS Cloud.
- 3. Share with your team: Click 'Share' in the top right corner, set the permission to 'Editor', and send the collaboration link to your teammates.
Frequently Asked Questions
Why can't I see other people's cursors in my shared Excel file?
To see other people's cursors and live edits, you must have 'Edit' permissions. If you only have 'View' access, Excel disables live tracking. Additionally, the file must be saved on OneDrive or SharePoint.
Do I need a Microsoft 365 subscription for live co-authoring?
Yes, real-time co-authoring in the desktop version of Excel requires an active Microsoft 365 subscription, though it is free to use on Excel for the Web with a free Microsoft account.
Can view-only users download a copy of the shared workbook?
Yes, users with view-only access can usually download a local copy of the workbook via 'File' > 'Save As' or 'Download a Copy', unless the file owner has explicitly blocked downloads in the sharing settings.
