VBA & Macro Problems

Fix Excel Co-Authoring Errors in Workbooks with VBA Macros

Adam DavisAdam Davis Nov 20, 2026 869 views

Question details

Identify the cause of co-authoring merge errors in an Excel workbook containing VBA macros.

Fix Excel Co-Authoring Errors in Workbooks with 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.
Before you start

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.

Solution 1Recommended

Test the workbook in Excel for the web

Use the browser to check whether the merge error is associated with the desktop Excel client.

1
Open the shared file

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.

2
Edit with another user

Have both users open the same file in Excel for the web and make small changes in different cells at the same time.

3
Compare the result

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.

Test the workbook in Excel for the web
Browser test limitation: Excel for the web cannot run or edit VBA macros. A successful browser test does not establish that the macros themselves work correctly.
Free Microsoft Office alternative

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.

Edit spreadsheet data with familiar tools.Open and save common Microsoft Excel formats, including .xlsx.Use a free, lightweight office suite for everyday workbook tasks.Move routine spreadsheet work to a familiar interface while investigating Excel merge errors.
microsoft office alternative - wps office

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.