Fix Excel Co-Authoring When Shared Changes Stop Updating
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.

- 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.
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.
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.
Look at the top-left corner of the Excel window and ensure the 'AutoSave' toggle is turned on.
Confirm that all users are opening the exact same file directly from OneDrive or SharePoint, rather than a downloaded local copy.
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.
Have all users close the desktop Excel application, wait for OneDrive to display 'Up to date', and then reopen the file.

Create a Clean Copy to Fix File Corruption
If synchronization remains broken on a large file, the workbook cache might be corrupted. Creating a fresh copy resolves hidden errors.
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.

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.




