Can Excel Co-Author Macro-Enabled Workbooks in Real Time?
Question details
The user wants to know whether multiple people can edit an Excel workbook containing VBA and ActiveX controls with live updates.

- 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.
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.
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.
In Excel, select File > Save As and confirm that the workbook is saved as an Excel Macro-Enabled Workbook (.xlsm).
Save a copy to OneDrive or a SharePoint document library using File > Save As, or upload it through the OneDrive or SharePoint website.
Select Share in Excel or in OneDrive, grant the collaborators editing permission, and send them the link.
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.
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.

Evaluate Excel's legacy Shared Workbook feature
Consider this older desktop feature only if modern co-authoring is unavailable and the workbook works within its restrictions.
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.

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.




