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
As 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.
Hi,
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.
- Hi 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.
