VBA & Macro Problems

Fix Excel VBA Macros Blocked on a Network Server

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 868 views

Question details

The user needs to run trusted Excel VBA macros in workbooks stored on a network server.

Fix Excel VBA Macros Blocked on a Network Server
Product
Microsoft Excel
Device & OS
not provided
Scenario
Excel workbooks containing VBA macros are opened from a server location.
Observed behavior
Macros remain blocked after changes to macro security settings and trusted sites.
Before you start

Confirm that the workbook and server share come from a trusted source, and identify the exact network path used to open the file. If the settings are managed by your organization, check with your IT administrator before making changes.

Solution 1Recommended

Add the server folder as an Excel trusted location

Use this when trusted workbooks are consistently opened from a specific server folder.

A Windows trusted site is not the same as an Excel trusted location. Add only a folder whose contents are controlled and trusted, because Office files in that location can bypass some security checks.

1
Open trusted locations

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

2
Allow network locations

If available, select Allow Trusted Locations on my network. If the option is unavailable or disabled, ask your IT administrator whether policy permits network trusted locations.

3
Add the server path

Select Add new location and enter the exact folder path used to open the workbook, such as \\server\share\folder or the corresponding mapped-drive path. Select the subfolder option only if those folders are also trusted, then select OK.

4
Reopen the workbook

Close the workbook and reopen it from the trusted path in Excel. Check whether the macros can now run.

Add the server folder as an Excel trusted location
Check the path and policy: A UNC path and a mapped drive may be treated as different locations. If the workbook is still blocked, confirm the path used to open it and ask IT whether group policy overrides the setting.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheets. It supports common Excel formats for an easier transition, but it does not change Excel Trust Center or group policy settings.

Open and edit spreadsheets without changing Excel network trust settings.Works with common Microsoft Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface for everyday workbook tasks.Move between common Office document formats with a lightweight suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why are macros still blocked after I added the server to trusted sites?

Windows trusted sites and Excel trusted locations are separate settings. In Excel, check File > Options > Trust Center > Trust Center Settings > Trusted Locations and verify the folder path.

Should I add the UNC path or the mapped drive?

Add the path you actually use to open the workbook. For example, a workbook opened through \\server\share may not match a trusted location entered as a mapped drive.

What if I cannot enable network trusted locations?

The setting may be controlled by your organization. Ask your IT administrator to check the relevant Office group policy rather than attempting to bypass it.

Where can I find the Unblock option for a downloaded workbook?

In Windows File Explorer, right-click the workbook, select Properties, and check the General tab for Unblock. It appears only when applicable; use it only for files you trust.

Will WPS Office fix Excel's blocked macro warning?

No. WPS Office does not change Excel Trust Center settings or organization policies. VBA macro support can vary by WPS edition and environment, so verify compatibility before relying on a macro-enabled workbook.