How to Fix Excel Co-Authoring Changes Cannot Be Merged Error
Question details
Users are unable to sync their collaborative edits because the application fails to merge local changes with the online version of the workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple co-authors are simultaneously editing a large or highly complex shared Excel workbook.
- Observed behavior
- An error message appears stating that changes cannot be merged with the online file, forcing users to either discard their edits or save a disconnected local copy.
Before attempting any fixes, have all users immediately use the 'Save a Copy' function to store their current edits locally, ensuring no critical data is lost during the troubleshooting process.
Reduce File Complexity and Move to SharePoint or OneDrive
Optimize the workbook to ensure smooth synchronization by removing unsupported features, reducing size, and hosting it on a stable cloud environment.
Large file sizes and complex formatting (such as excessive conditional formatting or heavy macros) can overwhelm Excel's co-authoring merge engine. Streamlining the file reduces these conflicts.
Open the affected workbook in the Excel desktop app. Remove unnecessary hidden sheets, clear empty rows/columns, and delete unused complex formulas or conditional formatting rules.
Click on 'File' > 'Save As' and select your organization's SharePoint or OneDrive account. Avoid saving to local network drives if you want co-authoring to function properly.
Click the 'Share' button in the top right corner and send the new cloud link to your team. Ask them to verify if the synchronization works smoothly.

Edit the Workbook Using Excel for the Web
Bypass desktop sync conflicts entirely by having all collaborators edit directly within the browser.
Rebuild the File by Copying Worksheets
Transfer data into a fresh workbook to eliminate underlying file corruption causing merge issues.
Experience Seamless Collaboration with WPS Office
If you are tired of dealing with complex Excel sync errors and file size limitations during co-authoring, try WPS Office. It provides a lightweight, highly compatible spreadsheet environment integrated with WPS Cloud for smooth and reliable real-time collaboration.
- 1. Download and Install: Visit the official WPS website to download WPS Office for free and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file. Your formatting and data will be perfectly preserved.
- 3. Collaborate in Real-Time: Save the file to WPS Cloud and use the 'Share' feature to invite your team for a seamless co-authoring experience.

Frequently Asked Questions
Why does Excel say my changes cannot be merged with the online file?
This usually happens when the workbook is too large, contains unsupported complex features (like legacy macros or heavy conditional formatting), or multiple users are trying to edit the exact same data range simultaneously, causing a sync conflict between the desktop app and the cloud.
Can I recover my edits if they won't merge?
Yes. When the error occurs, immediately select the option to 'Save a Copy' or save the file locally. Once the online file is stabilized or rebuilt, you can manually copy and paste your unmerged edits into the shared document.
Does Excel co-authoring work better on the web or desktop?
For large files with multiple users, Excel for the Web is generally more reliable for real-time co-authoring. The browser version processes edits directly on the server, heavily reducing the local sync conflicts common to the desktop version.
What features are not supported in Excel co-authoring?
Features like Shared Workbooks (the older legacy sharing method), absolute file encryption with passwords, and certain complex macro executions can disable or disrupt modern real-time co-authoring.




