VBA & Macro Problems

How to Share a Macro-Enabled Excel Workbook Through the Cloud

Anum MushtaqAnum Mushtaq Oct 29, 2026 872 views

Question details

The user needs to understand the correct workflow for sharing Excel workbooks containing VBA macros and form controls via cloud platforms like OneDrive without losing functionality.

How to Share a Macro-Enabled Excel Workbook Through the Cloud
Product
Excel
Device & OS
not provided
Scenario
Collaborating on and sharing macro-enabled files (.xlsm) with multiple users using cloud storage services.
Observed behavior
Users want to ensure that VBA macros, generated files, and external links remain intact when the workbook is stored in the cloud, while avoiding version control conflicts.
Before you start

Before sharing, ensure your file is saved in the proper macro-enabled format (.xlsm or .xlsb) and that collaborators are aware they will need a desktop version of Excel to execute the macros.

Solution 1Recommended

Use Cloud Storage and Open in Desktop App

Upload the macro-enabled workbook to a cloud service to preserve its features, and instruct collaborators to open it in the desktop application to run the scripts.

Cloud storage services like OneDrive perfectly preserve VBA macros, form controls, and external workbook links. However, web-based spreadsheet environments do not support the execution of VBA scripts. Consequently, while the file is safely stored in the cloud, the macros will remain inactive until opened locally.

1
Save as a Macro-Enabled Workbook

Open your file in Excel, click 'File', select 'Save As', and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the format dropdown.

2
Upload to OneDrive

Navigate to your OneDrive folder or the web portal, and upload the .xlsm file to store it securely in the cloud.

3
Share the Workbook

Right-click the uploaded file in OneDrive, click 'Share', and enter the email addresses of your collaborators to grant them access.

4
Open in Desktop App

Instruct recipients to click the 'Open in Desktop App' button when viewing the file online. This will launch their local Excel software, allowing VBA macros and form controls to function correctly while maintaining synchronization with the cloud.

Use Cloud Storage and Open in Desktop App
Prevent Conflicting Versions: Avoid repeatedly downloading the file to your hard drive, editing it, and manually re-uploading it. This process behaves like emailing attachments and will cause conflicting versions. Always use the 'Open in Desktop App' feature to edit the live cloud document.
Efficiently Share and Edit Macro Files

Use WPS Office to Manage and Share Macro-Enabled Spreadsheets

WPS Office fully supports executing VBA macros in its desktop application. You can seamlessly save, share, and collaborate on macro-enabled workbooks using the built-in WPS Cloud without losing form controls or VBA script functionality.

  1. 1. Open and Save the Workbook: Launch WPS Spreadsheet, open your workbook, and save it in the macro-enabled format (.xlsm).
  2. 2. Upload to WPS Cloud: Click the 'Tools' tab and select 'Save to Cloud' to upload your spreadsheet securely to WPS Cloud.
  3. 3. Generate a Sharing Link: Click the 'Share' button in the top right corner, adjust the permissions, and copy the collaboration link to send to your team.
  4. 4. Run Macros Locally: Collaborators can open the shared link and choose to edit the file using the WPS Office desktop client, ensuring all macros and form controls run properly.
Native support and full compatibility with Microsoft Excel Macro-Enabled formats (.xlsm and .xlsb)Built-in WPS Cloud for easy file sharing, automatic syncing, and version controlAdvanced desktop application allowing seamless execution of complex VBA scripts and macrosLightweight, fast, and familiar user interface for smooth migration
microsoft office alternative - wps office

Frequently Asked Questions

Can I run Excel macros directly in OneDrive or Excel on the web?

No, web browsers and cloud-based Excel interfaces do not support VBA execution. Although the macros are safely stored and preserved in the cloud, you must open the file in the desktop version of Excel to actually run them.

Why does my cloud-shared Excel file keep creating conflicting versions?

Conflicting versions usually occur when users manually download, edit locally, and re-upload the same file. To avoid this, users should open the cloud document using the 'Open in Desktop App' feature, allowing the cloud service to manage syncing directly.

Which file formats must be used to preserve macros when uploading to the cloud?

To ensure your VBA scripts and form controls are preserved when sharing via the cloud, your file must be saved as an Excel Macro-Enabled Workbook (.xlsm) or an Excel Binary Workbook (.xlsb).