Fix OneDrive Excel Viewers Not Seeing Real-Time Changes
Question details
A user wants a view-only recipient to see Excel workbook changes in real time through OneDrive.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- A workbook is shared with collaborators who have Edit permission and a recipient who has View-only permission.
- Observed behavior
- Editors see collaborative changes in real time, but the view-only recipient sees updates only after closing and reopening the workbook.
Ask the workbook owner to check the affected recipient's permission in the file's sharing settings. Decide whether the recipient can be trusted with edit access or must remain view-only.
Give the Recipient Edit Permission for Excel Co-Authoring
Use this option when the recipient is allowed to modify the workbook and needs to see collaborative changes as they happen.
In OneDrive, select the workbook, choose Share, and open Manage access.
Find the recipient under people with access and change their permission to Can edit. If needed, share the workbook again with Can edit selected.
Ask the recipient to open the shared workbook in Excel while another collaborator makes a change. Check whether the change appears without reopening the file.

Share the Excel Screen Without Granting Edit Access
Use an approved screen-sharing method when the recipient must remain view-only but needs to watch changes live.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Excel format compatibility for an easier move between office suites. It does not change OneDrive or Microsoft Excel sharing permissions.

Frequently Asked Questions
Why does the view-only recipient have to reopen the workbook?
View-only access does not provide the same co-authoring experience as Edit permission, so live updates may not appear reliably. Reopening the OneDrive file lets the recipient load the saved version.
Where can I check someone's Excel sharing permission?
In OneDrive, select the workbook, choose Share, and open Manage access to see the recipient's current permission.
Can someone watch changes without being allowed to edit?
An editor can share the Excel window through an approved conferencing app while keeping the recipient's OneDrive permission set to Can view.
Does granting Can edit only let the recipient watch live changes?
No. Can edit also allows the recipient to modify the workbook. Grant it only when that access is appropriate.




