Macros not working from network location

Question

Hello all,

I have some users that use macros on their excel documents that are saved on one of our internal file servers. I have added the network location to the trusted locations however when the user opens the file it says "Microsoft has blocked macros from running because the source of this file is untrusted. I have tried adding the parent folder and selecting the apply to subfolders check box and the exact folder location but no matter what it will not allow the user to run the macros properly.

Note: This was working for the user prior to getting a new windows 11 PC but the version of office 365 was the same from computer to computer.

We are using a home version of Office 365 because this is a small office and the family plan made more financial sense the going the business route.

New HP computer with plenty of resources running windows 11.

Please help any suggestions are welcome I am at a wall with my google searches and prior knowledge of office.

Answer 1

Thank you however I have already read through this article and nothing from it has helped. I do not understand what we are doing wrong.

Answer 2

https://techcommunity.microsoft.com/t5/excel/macro-enabled-excel-file-in-network-location-access-issue/m-p/3651100

Answer 3

So yes as this article states I am using a desktop version of 365 not the online. The issue only arises when opening files from a shared folder. If the files are saved on the PC and the location is added to trusted locations there is no problem using the macros however when I add the network location to the trusted locations I still get the same error of macros disabled.

Answer 4

This is the message my user gets even after adding the network location to the trusted locations as listed in the above picture.

Answer 5

Hi,

take a look here..