How to Share a Macro-Enabled Excel Workbook Through the Cloud
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.

- 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 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.
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.
Open your file in Excel, click 'File', select 'Save As', and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the format dropdown.
Navigate to your OneDrive folder or the web portal, and upload the .xlsm file to store it securely in the cloud.
Right-click the uploaded file in OneDrive, click 'Share', and enter the email addresses of your collaborators to grant them access.
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 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. Open and Save the Workbook: Launch WPS Spreadsheet, open your workbook, and save it in the macro-enabled format (.xlsm).
- 2. Upload to WPS Cloud: Click the 'Tools' tab and select 'Save to Cloud' to upload your spreadsheet securely to WPS Cloud.
- 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. 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.

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).




