Fix Excel VBA Macros Blocked on a Network Server
Question details
The user needs to run trusted Excel VBA macros in workbooks stored 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.
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.
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.
In Excel, select File > Options > Trust Center > Trust Center Settings > Trusted 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.
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.
Close the workbook and reopen it from the trusted path in Excel. Check whether the macros can now run.

Unblock a trusted workbook in Windows
Use this when a workbook was downloaded or copied from another system and Windows marks it as blocked.
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.

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.




