Fix Excel Co-Authoring Errors with Protected Sheets and Macros
Question details
Users experience synchronization and upload failures when attempting to co-author Excel workbooks in Teams that utilize worksheet protection and VBA 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.
Ensure you have a local backup copy of your Excel workbook before removing worksheet protection or altering macro settings to prevent accidental data loss.
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.
Open the affected Excel file, navigate to the 'Review' tab on the ribbon, and click 'Unprotect Sheet' for any locked worksheets.
Go to 'File' > 'Save As' and choose the standard 'Excel Workbook (*.xlsx)' format to temporarily strip macros from the file.
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.

Submit Feedback for Persistent Co-Authoring Bugs
If removing protection does not fix the merge errors, escalating the issue to Microsoft helps report underlying synchronization bugs.
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. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Open Your Workbook: Launch WPS Spreadsheets and easily open your existing .xlsx or .xlsm files without losing formatting.
- 3. Collaborate Freely: Use WPS Cloud to share secure links with your team and edit spreadsheets simultaneously without merge conflicts.

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.




