Fix Excel Macros Blocked from a Trusted Network Location
Question details
The user needs to allow macros in an Excel workbook stored on a trusted network share when Excel continues to block them.

- 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.
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.
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.
In Excel, select File > Options > Trust Center > Trust Center Settings.
Select Macro Settings and choose the organization-approved macro option. Do not enable all macros unless your administrator specifically requires it.
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.
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.
Close Excel completely, reopen the workbook directly from the trusted network folder, and select Enable Content if Excel displays a security notice.

Remove the Internet security block from the workbook file
Use this when a workbook was downloaded, copied from email, or transferred from another device before being placed on the network share.
Repair an invalid VBA digital signature or check enforced policies
Use this when Excel reports a signature problem, the Trusted Locations controls are locked, or security software continues to block macros.
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.

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.




