File Sharing Problems

How to Fix Excel Co-Authoring Merge Changes Error in SharePoint

Phi Hung Vo Sep 28, 2026 870 views

Question details

Users need to resolve frequent merge change errors in a shared Excel workbook hosted on SharePoint when multiple people edit the file at the same time.

How to Fix Excel Co-Authoring Merge Changes Error in SharePoint

Product: Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Approximately 15 users are simultaneously editing a shared workbook, entering text and time values.
Observed behavior: Excel frequently reports that changes could not be merged with another user's changes, disrupting the workflow for multiple users.

Before you start

Before proceeding, verify that all users are utilizing the latest version of the Excel desktop app or Excel for the Web, as mismatched client versions can frequently trigger sync and merge conflicts.

Solution 1Recommended

Test and Re-upload a Clean Copy of the Workbook

Creating a fresh copy of the workbook can clear hidden cache conflicts and resolve underlying file corruption causing merge failures.

Over time, shared workbooks on SharePoint can accumulate metadata or sync artifacts that prevent smooth co-authoring. Uploading a clean copy forces SharePoint to establish a new sync relationship.

Save a local copy

Open the problematic workbook in the Excel desktop app. Click File > Save As, and choose a local directory (like your Desktop) to save a copy.

Rename the file

Give the copied file a slightly different name to differentiate it from the original file on SharePoint.

Upload to SharePoint

Navigate to your SharePoint document library in your web browser. Click Upload > Files and select the new copy.

Test with users

Share the new link with your team and have 2-3 users simultaneously enter text and time values to verify if the merge error persists.

Test and Re-upload a Clean Copy of the Workbook

Tip: Once you confirm the new file works seamlessly, you can delete or archive the old workbook and rename the new file back to the original title.

Solution 2

Remove Unsupported Co-Authoring Features

Certain complex Excel features can block real-time collaboration and cause merging errors.

Solution 3

Create a Microsoft 365 Support Request

If standard troubleshooting fails, the Microsoft Support team can investigate potential backend server or tenant environment issues.

Free Microsoft Office alternative

Experience Seamless Co-Authoring with WPS Office

Struggling with complex SharePoint merge errors? WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy seamless real-time cloud collaboration, a familiar user interface, and zero hassle when working on spreadsheets with your team.

1. Download and Install: Download WPS Office for free and install it on your device.
2. Open your Spreadsheet: Open your existing .xlsx workbook directly in WPS Spreadsheet without losing any formatting.
3. Collaborate via WPS Cloud: Upload the file to WPS Cloud and share the collaboration link with your team for real-time editing.

Smooth real-time co-authoring that minimizes frustrating merge conflictsFully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight application that runs extremely fast on Windows, Mac, and mobileFamiliar user interface ensuring seamless migration with zero learning curveFree to use with intuitive, built-in cloud sharing features

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say changes cannot be merged with another user?

This error typically occurs when two or more users attempt to edit the exact same cell simultaneously, when there is a temporary network sync delay, or when the workbook contains features that are incompatible with real-time co-authoring.

How many users can co-author an Excel workbook at the same time?

While SharePoint technically allows up to 99 users to open a document simultaneously, performance often degrades with larger groups. Having around 15 users actively editing at the exact same time can sometimes stretch the sync limits, leading to intermittent merge conflicts.

Are there specific Excel features that prevent co-authoring?

Yes. Features such as legacy Shared Workbooks functionality, certain types of macros (VBA) that alter workbook structure, strict worksheet protection, and unsupported ActiveX controls can prevent seamless co-authoring and cause sync errors.

Can clearing the Office cache help fix SharePoint merge errors?

Yes. Occasionally, local cache files become corrupted and conflict with the live SharePoint version. Clearing your Office Document Cache via the Office Upload Center or Excel's Save settings can force a clean sync and resolve the issue.

Document & File Issues