Forum Discussion
Excel Macro blocked
Microsoft has blocked all macros form files that are not on your PC.
My files are on a NAS.
How do unblock the macros in the excel?
T
6 Replies
- NikolinoDEPlatinum ContributorAs far as I can remember they have to put the NAS as a trusted place in Excel when it comes to macros. 
 Here is a link to itAdd, remove, or change a trusted location Add a trusted location Click File > Options. Click Trust Center > Trust Center Settings > Trusted Locations. Click Add new location. Click Browse to find the folder, select a folder, and then click OK. Hope this helps, if not please just ignore it. - Vitor_KurialCopper ContributorHi, That still doesn't work, because excel don't allow folder's from the network. The only way that i found to temporay solve this issue is by create a link using CMD as administrator: MKLINK /d c:\Folder_to_use \\192.168.0.1\path_to_the_Network\ Use the folder that was created as a folder of the "C" Drive. As anyone as other solution for this problem of the latest update of the office 365? thanks. - apps1655Copper ContributorHi Vitor,
 I Had the same problem and the solution in fact it's easy:
 You must refer to the network with the server name and not the IP
 Example: \\serverA\path and not \\192.168.0.1\Path
 if you mapped any location with IP you need to remap with the server name.