That is not an option for these files here is an example from one of the files
Macros not working from network location
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.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
29 answers
Sort by: Most helpful
-
Anonymous
2023-03-07T16:09:20+00:00 -
Anonymous
2023-03-07T18:00:12+00:00 ok, i see.
-
Anonymous
2023-03-07T18:05:19+00:00 It appears as though I have done everything right and yet we still receive that message when opening the file from the shared location.
-
Anonymous
2023-03-15T20:28:49+00:00 Is there anyone else that has an idea for me on why this is not working?
-
Anonymous
2023-07-11T15:17:27+00:00 Is there anyone else that has an idea for me on why this is not working?
Did you manage to find a solution to your problem as we are now facing this issue!
We have lots of .DOCM files that we use on our system to merge with clients details but for some unknown reason it has all of a sudden started popping up asking do you trust this file or if we dont get that pop up we are getting the macro's disabled band across the top of the document?
We have the trusted locations set up for each drive and never had an issue until now! :(