How to Fix Excel Changes That Cannot Be Merged During Co-Authoring
Question details
Users experience an error where Excel cannot merge changes in shared workbooks stored in OneDrive, even when no active edits have been made.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users open a shared Excel workbook stored in OneDrive for co-authoring.
- Observed behavior
- Excel displays a synchronization error stating that changes cannot be merged, resulting in co-authoring conflicts.
Verify that your Excel workbook is saved in OneDrive or SharePoint and ensure that all co-authors have a stable internet connection before beginning troubleshooting.
Align Microsoft 365 Update Channels for All Users
Ensure all co-authors are using the same supported Microsoft 365 update channel to prevent version conflicts during co-authoring.
Different update channels in Microsoft 365 can introduce feature disparities between users. When one user is on a preview channel and another is on the standard release, Excel may struggle to merge real-time changes.
Open Excel, click on the 'File' menu, and select 'Account' from the bottom left pane.
Look under the 'Product Information' section, specifically next to 'About Excel', to identify your current Update Channel (e.g., Current Channel, Beta Channel).
Ask all collaborators to check their update channels. Identify any user who is on a different or preview channel.
Use the Microsoft 365 Admin Center or the Office Deployment Tool to switch users on preview channels back to the 'Current Channel' so that all versions match.
Clear the Office File Cache
Corrupted cached files can cause sync issues in OneDrive shared workbooks. Clearing the cache forces Excel to download a fresh copy.
Remove ActiveX Controls or Unsupported Features
Certain legacy features like ActiveX controls are not fully supported in Excel co-authoring and can block changes from merging successfully.
Experience Seamless Spreadsheet Collaboration with WPS Office
Tired of complicated update channel conflicts and merging errors in Microsoft Excel? WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy smooth spreadsheet collaboration and editing without the frustrating co-authoring restrictions.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Sign in for cloud collaboration: Launch WPS Spreadsheets and sign in to your WPS account to unlock real-time collaboration features.
- 3. Open and share your workbook: Open your existing Excel file and use the 'Share' button to invite team members to edit simultaneously without merge conflicts.
Frequently Asked Questions
Why does Excel say my changes cannot be merged when co-authoring?
This error usually occurs when co-authors are using different update channels of Microsoft 365 (e.g., one on Current Channel and another on Beta Channel), or if the workbook contains unsupported features like ActiveX controls.
How do I check my Microsoft 365 update channel?
Open any Office application like Excel, click on 'File', and select 'Account'. Under 'Product Information', locate the 'About Excel' section to see your current update channel and build number.
Does clearing the Office file cache delete my documents?
No, clearing the Office file cache only removes temporary files stored on your local computer to help resolve sync issues. Your actual documents saved in OneDrive or SharePoint remain safe and untouched.
Can I co-author an Excel workbook that contains macros?
Yes, you can co-author macro-enabled workbooks (.xlsm), but certain legacy elements embedded within them, such as ActiveX controls, might prevent multiple users from merging changes simultaneously.
