Forum Discussion

Vitor_Kurial's avatar
Vitor_Kurial
Copper Contributor
Jun 23, 2022

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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

    • Vitor_Kurial's avatar
      Vitor_Kurial
      Copper Contributor

      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.

       

      • apps1655's avatar
        apps1655
        Copper Contributor
        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.

Resources