File Sharing Problems

Fix Excel Co-Authoring Errors with Protected Sheets and Macros

Kushani NimanthikaKushani Nimanthika Oct 29, 2026 869 views

Question details

Users experience synchronization and upload failures when attempting to co-author Excel workbooks in Teams that utilize worksheet protection and VBA macros.

Fix Excel Co-Authoring Errors with Protected Sheets and Macros
Product
Microsoft Excel
Device & OS
not provided
Scenario
Collaborating on shared Excel workbooks in real-time through Microsoft Teams.
Observed behavior
The Excel workbook displays 'Upload failed', 'Could not merge', or VBA-related error messages, interrupting the real-time co-authoring session.
Before you start

Ensure you have a local backup copy of your Excel workbook before removing worksheet protection or altering macro settings to prevent accidental data loss.

Solution 1Recommended

Test the Workbook Without Protection and Macros

Temporarily disabling worksheet protection and macros isolates the root cause of the co-authoring conflicts.

Real-time co-authoring in Excel frequently conflicts with traditional worksheet protection and VBA macros. By stripping these elements, you can determine if they are the direct cause of the merge failures.

1
Unprotect Worksheets

Open the affected Excel file, navigate to the 'Review' tab on the ribbon, and click 'Unprotect Sheet' for any locked worksheets.

2
Save Without Macros

Go to 'File' > 'Save As' and choose the standard 'Excel Workbook (*.xlsx)' format to temporarily strip macros from the file.

3
Upload and Retest

Upload the newly saved .xlsx file back into Microsoft Teams and invite a colleague to edit simultaneously to check if the 'Upload failed' error is resolved.

Test the Workbook Without Protection and Macros
Macro Limitations: Excel's real-time co-authoring does not fully support VBA macros running concurrently. Consider transitioning to Office Scripts for cloud-friendly automation.
Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

Tired of frustrating merge errors and macro conflicts? WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy robust spreadsheet formatting and smooth collaboration without the constant synchronization glitches.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
  2. 2. Open Your Workbook: Launch WPS Spreadsheets and easily open your existing .xlsx or .xlsm files without losing formatting.
  3. 3. Collaborate Freely: Use WPS Cloud to share secure links with your team and edit spreadsheets simultaneously without merge conflicts.
Seamless real-time document collaboration and file sharing via WPS Cloud.Outstanding compatibility with Microsoft Excel formats (.xlsx, .xlsm).Lightweight application that runs smoothly on a variety of devices.Free to download with a familiar, user-friendly interface.
QA img-9

Frequently Asked Questions

Why do I get an 'Upload failed' error when co-authoring in Excel?

This error occurs when multiple users edit a workbook in Teams or SharePoint that contains features unsupported by live co-authoring, such as traditional worksheet protection or certain VBA macros.

Can I co-author an Excel file that contains macros (.xlsm)?

While you can open and co-author .xlsm files, actively running the macros while others are editing can trigger sync errors or 'Could not merge' conflicts. It is highly recommended to run macros only when you are the sole active editor.

Does removing worksheet protection solve all merge errors?

Removing worksheet protection resolves many conflicts, but other factors like active data filtering, complex data validation, or network latency can still cause co-authoring issues.

Is there a way to protect cells without breaking Excel co-authoring?

While standard 'Protect Sheet' features frequently disrupt real-time collaboration, utilizing 'Sheet Views' allows users to filter and sort data independently without interfering with others' views.