VBA & Macro Problems

How to Fix Excel Macros Stopping After Opening Shared Workbooks

Maira Mehtab Sep 22, 2026 874 views

Question details

Excel macros in a cloud-hosted shared workbook stop functioning for other collaborators once the file is opened and saved from a specific Windows desktop installation.

Product: Excel
Device & OS: Windows
Scenario: Collaborating on a cloud-hosted, macro-enabled Excel workbook across multiple Windows desktop installations.
Observed behavior: The macros run perfectly until one specific user opens the file; afterward, the macros break and stop working for all other collaborators, both in the cloud and when downloaded locally.

Before you start

Ensure all collaborators are opening the shared workbook in the desktop Excel application, as web-based spreadsheet versions do not support running VBA macros natively.

Solution 1Recommended

Verify Macro Trust Settings and Isolate Local vs. Cloud Behavior

Determine if the issue stems from local macro security settings or if automated cell content changes are breaking the VBA code upon opening.

Often, opening a shared workbook on a specific machine can inadvertently trigger formulas or formatting updates that alter cell contents. If your VBA code references these specific cells, the macro will fail for everyone once the file is saved.

Download a fresh local copy

Have the affected user download a local copy of the workbook before opening it in the cloud to see if the macro runs locally.

Check Trust Center Settings

Open Excel Options, navigate to Trust Center > Trust Center Settings > Macro Settings, and ensure macros are enabled or the file's network location is trusted.

Monitor cell content changes

Open the file locally and strictly observe if any formulas or functions automatically update cell contents. If they do, adjust your VBA code to account for dynamic cell changes.

Avoid editing before testing: Make sure the file is completely untouched by the problematic Windows machine before other users attempt to run the test.

Solution 2

Update to a Corporate Microsoft 365 Installation

Resolve underlying VBA platform compatibility bugs by switching to a standardized corporate Office build.

Run and Edit Macros Safely Using WPS Office

If your current spreadsheet software frequently corrupts shared macros or experiences sync compatibility issues, WPS Office provides a highly stable environment for executing VBA macros safely.

1. Install WPS Office: Download and install the free version of WPS Office from the official website.
2. Open your macro workbook: Launch WPS Spreadsheet, go to the Menu, and select Open to load your .xlsm file.
3. Enable and run macros: Click 'Enable Macros' on the security warning prompt. Navigate to the Tools tab and click Macros to run or debug your VBA code safely.

High compatibility with Microsoft Excel macro-enabled formats (.xlsm, .xlsb)Stable VBA execution without shared workbook sync corruptionBuilt-in macro editor with a familiar user interface for seamless migrationLightweight and free alternative for everyday office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel macros stop working after being uploaded to a shared cloud drive?

Cloud platforms like OneDrive or SharePoint often default to opening files in Excel for the Web, which does not support executing VBA macros. Users must explicitly choose to 'Open in Desktop App' to utilize macro functionalities.

Can opening an Excel file change its cell contents automatically and break macros?

Yes. If calculation options are set to Automatic, or if volatile functions (like TODAY or RAND) are used, opening the file can recalculate formulas. If a VBA macro relies on a specific static value that gets altered, the macro will fail.

How do I check if my VBA project has compatibility issues?

Open the VBA Editor (ALT + F11), click on 'Debug' in the top menu, and select 'Compile VBAProject'. If there are broken references or platform-specific incompatibilities (such as 32-bit vs 64-bit API calls), the compiler will highlight the problematic code.

Excel & Data Problems