Allow Excel Macros from a NAS Drive with a Trusted Location
Question details
Allow Excel macros to run in files stored on a trusted NAS drive.

- 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.
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.
Add the NAS Folder to Excel Trusted Locations
Use this method to trust a specific NAS folder when Excel permits network trusted locations.
In Excel, select File > Options > Trust Center, then click Trust Center Settings.
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.
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.
Click OK to save the settings, close the workbook, and open it again from the trusted NAS folder.

Check the NAS in the Windows Local Intranet Zone
Use this option when Windows treats a trusted NAS as an outside network location and your administrator permits zone changes.
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.

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.




