Fix Excel VBA Macros Blocked Without an Unblock Option
Question details
The user is unable to run Excel VBA macros from files located on a company network server because they are blocked, the file properties lack an Unblock option, and adding the path to Trusted Locations results in a security error.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Accessing and running a macro-enabled workbook that is stored on a shared company network server.
- Observed behavior
- Excel blocks the VBA macros, the Windows file Properties dialog does not display an Unblock option, and adding the network location to Excel's Trusted Locations yields a security error.
Ensure you have the exact file server name or UNC path (e.g., \\fileserver\networkdirectory) rather than just the mapped drive letter, and verify you have permission to modify Excel Trust Center settings.
Add the Network UNC Path to Excel Trusted Locations
Bypass the security error by using the actual server name (UNC path) instead of a mapped drive letter when configuring Excel's Trusted Locations.
Excel's Trust Center often rejects mapped drive letters (such as Z:\) for network locations due to security protocols. Specifying the Universal Naming Convention (UNC) path resolves this security error.
Open Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, and check the box for 'Allow Trusted Locations on my network (not recommended)'.
Click 'Add new location...' to open the Microsoft Office Trusted Location dialog box.
Instead of browsing to a mapped drive, manually type the exact UNC path of the network directory (e.g., \\servername\sharedfolder) into the path field and check 'Subfolders of this location are also trusted'.
Click OK to save the new settings, close all open Excel windows, and reopen your macro-enabled workbook from the network.

Contact Your Administrator to Update Macro Policies
If Excel still rejects the UNC path, your organization's Microsoft 365 Group Policy is likely restricting macros from network locations.
Experience Hassle-Free Spreadsheets with WPS Office
If Microsoft Excel's strict network macro policies and missing unblock options are slowing down your workflow, try WPS Office. It provides a lightweight, highly compatible alternative for viewing and editing macro-enabled workbooks without constantly battling complex network security configurations.
- 1. Download and Install: Download WPS Office Free from the official website and complete the straightforward installation process.
- 2. Open your workbook: Launch WPS Spreadsheets and open your network-stored macro workbook.
- 3. Enable Macros: Follow the simple on-screen prompt to enable macros securely without needing to navigate complex trust center menus.

Frequently Asked Questions
Why is the Unblock option missing in the file properties?
The Unblock option typically appears for files downloaded from the internet that carry the 'Mark of the Web' tag. Files accessed directly from a local network share or intranet often do not receive this tag, meaning the option won't appear even though Excel applies network security restrictions.
What is a UNC path and how do I find it?
A UNC (Universal Naming Convention) path points to a network resource using the server name rather than a mapped drive letter, formatted as \\ServerName\ShareName. You can find it by opening the Windows Command Prompt and typing 'net use' to see the remote server names mapped to your drive letters.
Is it safe to allow trusted locations on my network?
Yes, provided the network location is an internal company server managed by your IT department and access is strictly controlled. You should avoid trusting public, unknown, or unsecured network folders to protect your computer from malicious code.




