VBA & Macro Problems

Fix Excel Macros Blocked from a Trusted Network Location

Natalie TaylorNatalie Taylor Nov 12, 2026 868 views

Question details

The user needs to allow macros in an Excel workbook stored on a trusted network share when Excel continues to block them.

Fix Excel Macros Blocked from a Trusted Network Location
Product
Microsoft Excel
Device & OS
not provided
Scenario
A macro-enabled workbook is opened from a network location that has been added to Excel Trusted Locations and whose server is listed as a trusted site.
Observed behavior
Excel blocks the workbook macros despite the network share appearing to be trusted.
Before you start

Confirm that the workbook is from a known internal source and that it uses a macro-enabled format such as .xlsm or .xltm. If the network location is managed by your organization, ask your administrator before changing Trust Center, policy, or security settings.

Solution 1Recommended

Allow the network share as an Excel Trusted Location

Use this when the workbook is stored on an approved file server but macros remain blocked after opening it from the share.

Excel can trust folders on a network only when the network trusted-location setting is enabled. The location path must match the folder where the workbook is stored.

1
Open Trust Center settings

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

2
Check macro settings

Select Macro Settings and choose the organization-approved macro option. Do not enable all macros unless your administrator specifically requires it.

3
Enable network trusted locations

Under Macro Settings, select Trust access to the VBA project object model only if required by your organization. Then select Trusted Locations and enable Allow Trusted Locations on my network (not recommended) if the option is available and permitted.

4
Add or verify the share path

In Trusted Locations, select Add new location, enter the approved UNC path such as \\server\sharedfolder, and select Subfolders of this location are also trusted when appropriate.

5
Reopen the workbook

Close Excel completely, reopen the workbook directly from the trusted network folder, and select Enable Content if Excel displays a security notice.

Allow the network share as an Excel Trusted Location
Network locations may be controlled by policy: If the network-location option is unavailable or disabled, a Group Policy setting may be preventing changes. Contact your IT administrator to configure the approved share.
Free Microsoft Office alternative

Open Macro-Enabled Excel Workbooks with WPS Office

If Microsoft Excel security policies on your managed network prevent you from working with approved files, WPS Office is a free, lightweight office alternative with a familiar spreadsheet interface. It supports common Excel workbook formats for a smooth transition while you coordinate macro and security requirements with your administrator.

Open and edit common Excel workbook formats, including .xlsx and .xlsm files.Use a familiar spreadsheet workspace for formulas, tables, and workbook editing.Lightweight, free Office suite designed for easy migration from Microsoft Office.Maintain compatibility with Microsoft Excel file formats when sharing standard workbook content.
microsoft office alternative - wps office

Frequently Asked Questions

Why are macros blocked when my network folder is already in Excel Trusted Locations?

Excel may not permit network trusted locations unless File > Options > Trust Center > Trust Center Settings > Trusted Locations includes the enabled option to allow trusted locations on the network. A Group Policy can also override this setting.

What Excel file types can contain VBA macros?

Macro-enabled Excel files commonly use the .xlsm or .xltm extension. A standard .xlsx file cannot store VBA macros, so save a macro workbook using File > Save As > Excel Macro-Enabled Workbook (*.xlsm).

How do I tell whether Windows has blocked a macro workbook?

Close the workbook, right-click the file in File Explorer, select Properties, and check the General tab. If a Security section includes an Unblock checkbox or button, Windows applied an internet security mark to the file.

Can an invalid VBA signature stop macros from running?

Yes. In the Visual Basic Editor, select Tools > Digital Signature to check the VBA project certificate. Remove an invalid signature or replace it with a valid certificate issued by a trusted publisher.

Why can’t I change Excel macro or Trusted Location settings?

Your organization may manage these settings through Group Policy, Microsoft 365 security rules, or endpoint protection software. Contact your IT administrator to have the approved network path or macro publisher configured correctly.