File Sharing Problems

Fix OneDrive Excel Viewers Not Seeing Real-Time Changes

Ayan MasoodAyan Masood Nov 13, 2026 868 views

Question details

A user wants a view-only recipient to see Excel workbook changes in real time through OneDrive.

Fix OneDrive Excel Viewers Not Seeing Real-Time Changes
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.
Before you start

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.

Solution 1Recommended

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.

1
Open sharing settings

In OneDrive, select the workbook, choose Share, and open Manage access.

2
Change the permission

Find the recipient under people with access and change their permission to Can edit. If needed, share the workbook again with Can edit selected.

3
Reopen and test

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.

Give the Recipient Edit Permission for Excel Co-Authoring
Edit access allows changes: Can edit lets the recipient modify the workbook; it is not a view-only setting. Use a screen-sharing method instead if edit access is inappropriate.
Free Microsoft Office alternative

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.

Open and work with Excel workbooks in WPS SpreadsheetCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.