Excel Macro blocked

[Vitor_Kurial]

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

[#2]

@Vitor_Kurial 

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 it

Add, 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.

[#3]

@NikolinoDE 

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.

[#4]

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.

[#5]

HI this sounds like it might work for me, only i'm not sure how to do what you suggest. My files are actually kept on OneDrive and accessed as a shared folder.
Can you help please.

[#6]

Hi,
Regarding this topic, I've used this workaround with success, but in fact it's something which does not feel right from a security perspective.
What I would like is to allow a specific folder or file instead of the whole network share, which leaves a door open to any malicious file.
Any other way of allowing specific files on a network share without allowing them all on the network share?
Thanks

[#7]

@apps1655 Hi, 

I too have the same problem, I have the macro enabled excel workbook, even though I give the server path as trusted location, it's always asking me to enable the macros.

I want it to be enabled every time the document opens ? fr all the users in my organization. Is there any way