Fix Excel Macros That Stop Working in a Network Workbook
Question details
A user needs to restore macro functionality in a shared XLSM workbook that works for other users.

- 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.
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.
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.
In Excel for Windows, select File > Options > Trust Center > Trust Center Settings.
Select Trusted Documents, click Clear, and confirm the prompt. This clears trust decisions for all previously trusted documents, not just this workbook.
Close the workbook, then open the XLSM file again from its network location.
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.

Check the affected user's workbook access and macro warning
Use this if clearing the trusted document cache does not restore the macro.
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.

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.




