Forum Discussion
Excel Macro blocked
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.
- Vitor_KurialJun 23, 2022Copper Contributor
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.
- apps1655Jun 25, 2022Copper 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.- imsureshbio1109Nov 22, 2022Copper Contributor
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