Security Policy Errors

Allow Excel Macros from a NAS Drive with a Trusted Location

Steven ParkerSteven Parker Nov 18, 2026 868 views

Question details

Allow Excel macros to run in files stored on a trusted NAS drive.

Allow Excel Macros from a NAS Drive with a Trusted Location
Product
Microsoft Excel
Device & OS
Windows; version not provided
Scenario
An Excel workbook with macros is opened from a network-attached storage location.
Observed behavior
Excel may block the workbook's macros because the NAS location is not recognized as trusted.
Before you start

Confirm that you control and trust the NAS, the workbook, and anyone who can modify files in the folder. Find the NAS folder's network path, such as \\nas-name\shared-folder, and check whether your administrator permits changes to trusted locations.

Solution 1Recommended

Add the NAS Folder to Excel Trusted Locations

Use this method to trust a specific NAS folder when Excel permits network trusted locations.

1
Open Trust Center

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

2
Allow network locations

Select Trusted Locations and, if available, check Allow Trusted Locations on my network. If the setting is unavailable or managed by your organization, contact your administrator.

3
Add the NAS folder

Click Add new location, then enter or browse to the trusted NAS folder's network path. Select the subfolders option only if those folders are also trusted.

4
Reopen the workbook

Click OK to save the settings, close the workbook, and open it again from the trusted NAS folder.

Add the NAS Folder to Excel Trusted Locations
Trust only controlled folders: Files in a trusted location can bypass some Office security checks. Use a narrowly scoped folder and restrict who can add or change files there.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not change Excel's trust settings, and macro compatibility can vary.

Open and edit Microsoft Excel XLS and XLSX filesWork with spreadsheets in a familiar, easy-to-use interfaceUse a lightweight office suite for everyday documentsMove common Office files without converting them first
QA img-9

Frequently Asked Questions

Why are macros blocked when I open a workbook from my NAS?

Excel or Windows may not recognize the NAS as trusted, or an organizational policy may block macros. Check Excel's File > Options > Trust Center > Trust Center Settings and ask your administrator if the settings are managed.

Can I trust just one folder on the NAS?

Yes. In Excel, go to Trust Center Settings > Trusted Locations > Add new location and enter the specific folder's network path. Leave the subfolders option unchecked unless those folders are also trusted.

What if Excel won't let me add a network trusted location?

Check whether Allow Trusted Locations on my network is available under Trust Center Settings > Trusted Locations. If it is disabled or controlled by policy, contact your administrator.

Does adding the NAS to Local intranet guarantee that macros will run?

No. File origin information, Excel macro settings, and organizational policies can still block macros. Reopen the workbook after changing an allowed setting and consult your administrator if the block remains.