VBA & Macro Problems

Fix Excel Macros That Stop Working in a Network Workbook

Khadija KhanKhadija Khan Nov 18, 2026 869 views

Question details

A user needs to restore macro functionality in a shared XLSM workbook that works for other users.

Fix Excel Macros That Stop Working in a Network Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
One user opens a shared macro-enabled workbook from a network location and tries to run its macros.
Observed behavior
The macros stop responding for one user while the workbook works for most other users.
Before you start

Confirm that the affected user is opening the intended XLSM file from the network and that the workbook comes from a trusted source. The Trust Center menu path below applies to desktop Excel for Windows.

Solution 1Recommended

Clear Excel's trusted document cache and reopen the workbook

Use this when a stale or inconsistent trust state may be preventing macros from working for one user.

1
Open Trust Center settings

In Excel for Windows, select File > Options > Trust Center > Trust Center Settings.

2
Clear trusted documents

Select Trusted Documents, click Clear, and confirm the prompt. This clears trust decisions for all previously trusted documents, not just this workbook.

3
Reopen the network workbook

Close the workbook, then open the XLSM file again from its network location.

4
Enable and test macros

If Excel displays a security warning, select Enable Content only if you trust the file and its source. Run the macro again using its workbook button or the method normally used.

Clear Excel's trusted document cache and reopen the workbook
Organization policies may still apply: Clearing trusted documents does not override macro security policies. If macros remain blocked or the settings are unavailable, ask your IT administrator to check the user's policy and network access.
Free Microsoft Office alternative

Work with spreadsheet files using WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheet files. Its format compatibility helps make migration easier, although it does not fix Excel's trust settings and VBA support can vary by version.

Open and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksCheck VBA support in your WPS version before relying on macros in an XLSM workbookUse a lightweight, free office suite for common productivity tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does the macro work for other users but not for me?

The affected user may have a different trusted document state, macro policy, or network permission. Clear the trusted document cache in Excel's Trust Center and check any security warning when reopening the file.

Will clearing trusted documents affect other workbooks?

Yes. File > Options > Trust Center > Trust Center Settings > Trusted Documents > Clear removes trust decisions for previously trusted documents, so Excel may prompt you again when you open them.

What should I do if Excel still blocks the macro?

Check the exact security message and ask your IT administrator to review macro policies and access to the network location. Clearing the trusted document cache does not override organization policies.

Should I enable macros whenever Excel prompts me?

No. Select Enable Content only when you trust the workbook and its source. If you are unsure, ask the file owner or your IT administrator before enabling macros.