Fix Excel Co-Authoring Errors in Workbooks with VBA Macros
Question details
Identify the cause of co-authoring merge errors in an Excel workbook containing VBA macros.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Multiple users edit a macro-enabled workbook through Microsoft Teams or Microsoft 365.
- Observed behavior
- Excel may report that changes could not be merged during co-authoring.
Ask another user to help test simultaneous editing, and confirm that the workbook is stored in OneDrive or SharePoint and that both users have edit permission. Note which users are opening it in the desktop app and which are using Excel for the web.
Test the workbook in Excel for the web
Use the browser to check whether the merge error is associated with the desktop Excel client.
In Teams, open the workbook from the channel's Files tab and choose Open in browser, or open it from its OneDrive or SharePoint location.
Have both users open the same file in Excel for the web and make small changes in different cells at the same time.
Check whether the changes appear for both users without a merge error. If the browser test succeeds but the desktop test fails, investigate the desktop client and its co-authoring setup.

Compare co-authoring with and without a simple macro
Use controlled test files to check whether VBA content is associated with the error.
Edit Excel-Compatible Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday workbook tasks. It does not fix Microsoft Excel co-authoring errors, and VBA compatibility should be checked before migrating macro-dependent workbooks.

Frequently Asked Questions
Can I run VBA macros in Excel for the web?
No. Excel for the web can open and edit supported macro-enabled workbooks, but it cannot run or edit VBA macros. Open the workbook in desktop Excel to work with its macros.
Where should the workbook be stored for co-authoring?
Store the workbook in OneDrive or SharePoint and give each participant edit permission. A workbook shared through a Teams channel is typically stored in the channel's SharePoint location.
Does a successful browser test prove that VBA caused the error?
No. It suggests the issue may be related to the desktop client or its editing conditions. Compare a new .xlsx file with a simple .xlsm file to gather more evidence.
What file format should I use for the macro-enabled test?
In desktop Excel, select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm). Use .xlsx for the separate test workbook without macros.




