VBA & Macro Problems

Can Excel Co-Author Macro-Enabled Workbooks in Real Time?

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

The user wants to know whether multiple people can edit an Excel workbook containing VBA and ActiveX controls with live updates.

Can Excel Co-Author Macro-Enabled Workbooks in Real Time?
Product
Microsoft Excel
Device & OS
not provided
Scenario
Collaborators in different locations want to edit a macro-enabled workbook stored on MEGA, including from Office 2019 Professional Plus.
Observed behavior
Live updates are needed across different networks, but the workbook's macros, controls, storage location, and Excel versions may limit collaboration.
Before you start

Check each collaborator's Excel version and confirm whether the workbook contains ActiveX controls as well as VBA macros. Agree on a shared storage location and test a copy of the workbook before relying on live collaboration.

Solution 1Recommended

Co-author an XLSM workbook with supported Excel clients

Use Microsoft 365 Excel and supported cloud storage when collaborators need modern, real-time editing.

Excel supports co-authoring macro-enabled XLSM workbooks, but VBA and ActiveX features have limitations. Excel for the web cannot run VBA macros, and ActiveX controls may prevent or limit browser editing.

Office 2019 desktop does not provide modern Excel co-authoring. MEGA file synchronization is not a substitute for Excel's OneDrive or SharePoint co-authoring service and can create conflicting copies when people edit simultaneously.

1
Check the file format

In Excel, select File > Save As and confirm that the workbook is saved as an Excel Macro-Enabled Workbook (.xlsm).

2
Move a test copy to supported storage

Save a copy to OneDrive or a SharePoint document library using File > Save As, or upload it through the OneDrive or SharePoint website.

3
Share the workbook

Select Share in Excel or in OneDrive, grant the collaborators editing permission, and send them the link.

4
Open and test together

Have each person open the shared link in a supported, up-to-date Excel for Microsoft 365 desktop client. Make small edits at the same time and check that they appear for everyone.

5
Test macros and controls

In the desktop workbook, test the required VBA actions and ActiveX controls with the collaborators. Avoid editing the VBA project while others are co-authoring.

Co-author an XLSM workbook with supported Excel clients
Browser limitations: Excel for the web can co-author compatible workbooks, but it cannot run VBA macros. Test whether the workbook opens and edits correctly in the browser before asking anyone to use it.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and Excel format compatibility for easier migration. It does not fix Excel co-authoring restrictions, and VBA macros or ActiveX controls may not behave the same way, so test essential features before switching.

Open and edit compatible Microsoft Excel XLSX and XLSM filesUse a familiar spreadsheet interface for everyday editingTry a free, lightweight alternative when moving between office suitesReview macro-enabled workbook compatibility before adopting a new workflow
microsoft office alternative - wps office

Frequently Asked Questions

Can people co-author an XLSM file in Excel?

Yes. Save the XLSM file to OneDrive or SharePoint, share it with editing permission, and use supported Excel clients. Test any VBA and ActiveX features separately.

Can Office 2019 Professional Plus co-author an Excel workbook?

Office 2019 desktop does not support modern Excel co-authoring. Use a supported Microsoft 365 desktop version for that workflow, or evaluate Excel for the web if the workbook is compatible.

Can Excel for the web run the workbook's macros?

No. Excel for the web cannot run VBA macros. Open the workbook in a compatible desktop version of Excel to run them, and test any ActiveX controls there.

Can we use MEGA for simultaneous Excel co-authoring?

MEGA synchronization is not the supported Excel co-authoring service. For live co-authoring, place the workbook in OneDrive or SharePoint and share a link with editing permission.

Does legacy Shared Workbook work in Excel for the web?

No. Shared Workbook is a legacy desktop feature. Its restrictions can also affect workbooks that rely on macros and ActiveX controls, so test a copy before using it.