File Sharing Problems

Fix Excel Co-Authoring When Shared Changes Stop Updating

Algirdas JasaitisAlgirdas Jasaitis Nov 10, 2026 870 views

Question details

Users experience a synchronization failure during Excel co-authoring where participant selections are visible, but workbook edits do not update for other users.

How to Fix Excel Co-Authoring When Shared Changes Stop Updating
Product
Microsoft Excel
Device & OS
not provided
Scenario
Collaborating on a large shared Excel workbook hosted on OneDrive or SharePoint.
Observed behavior
Multiple users can open the workbook and see each other's cell selections in real-time, but applied changes and cell edits fail to synchronize across sessions.
Before you start

Ensure that you have a stable internet connection and that all collaborators are signed into their respective Microsoft accounts with edit permissions for the shared file.

Solution 1Recommended

Verify AutoSave and Resolve OneDrive Sync Issues

Ensure AutoSave is active and OneDrive is fully synced to allow real-time collaboration.

Real-time co-authoring requires the file to be hosted on OneDrive or SharePoint and opened with AutoSave enabled. When sync gets stuck, user presence may still show, but the actual file data stops transferring.

1
Check AutoSave

Look at the top-left corner of the Excel window and ensure the 'AutoSave' toggle is turned on.

2
Verify cloud location

Confirm that all users are opening the exact same file directly from OneDrive or SharePoint, rather than a downloaded local copy.

3
Force OneDrive sync

Click the OneDrive cloud icon in your system tray or menu bar to check for sync errors. Pause and resume syncing if it appears stuck.

4
Close stale sessions

Have all users close the desktop Excel application, wait for OneDrive to display 'Up to date', and then reopen the file.

Verify AutoSave and Resolve OneDrive Sync Issues
Excel for the Web: Opening the file in Excel for the Web can bypass local cache issues and confirm if the cloud file is updating correctly.
Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

Tired of complicated sync errors and file corruption? WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office. With built-in WPS Cloud, you can easily share spreadsheets and collaborate without the hassle of broken synchronization.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in WPS Cloud for stable and secure file sharing and co-authoring.Lightweight installation with a familiar, user-friendly interface.Free to use for essential spreadsheet creation and data analysis.
microsoft office alternative - wps office

Frequently Asked Questions

Why can I see other users in the Excel workbook but not their edits?

This usually happens when AutoSave is disabled or a local OneDrive sync issue prevents data from being uploaded. The Microsoft co-authoring presence service (which shows who is in the file) uses a different connection than the actual file data sync, meaning you might see their selection but not their changes.

Does a large number of rows cause Excel co-authoring to fail?

Not directly. While a single Excel worksheet can hold up to 1,048,576 rows, having hundreds of thousands of rows (like 130,000) creates a much larger file size. A larger file can slow down the sync process over a weak internet connection, increasing the chances of version conflicts or caching errors.

How do I merge changes if Excel co-authoring stops syncing?

If co-authoring breaks, have each user save a local copy of their current state. You will then need to manually compare the files, copy the missing data into a single 'master' workbook, and upload this new consolidated version to the cloud to resume sharing.

Can clearing the Office Document Cache fix co-authoring issues?

Yes. Sometimes corrupted cached files prevent Excel from syncing with OneDrive. You can resolve this by navigating to the Office Upload Center or Excel's Options menu and clearing the document cache, which forces Excel to download a fresh copy from the cloud.