Security Risk - Microsoft has blocked macros from running because the source of this file is untrusted

Anonymous

The error has a link that takes you here

A potentially dangerous macro has been blocked (microsoft.com)

However the option to check mark unblock does not exist on the file. There is nothing below attributes. This page makes no sense to me, I have never in my entire IT career seen this option that supposedly should be there.

I have gone into Options > Trust center > Trusted Location.
I have checked Allow trusted locations on my network.
I have then tried to add the location of the share drive.

I get "The path you have used cannot be used as a trusted location for security reasons".
Quite frustrated at this point I created a registry entry with the file share. (HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations)

The network drive now shows as the file share as a trusted location in excel.
I still get the same Security risk error.

These files have existed for quite some time and we have never had this issue previously. If there were any recent changes or updates I am unaware of them. Moving the file locally to my computer gets rid of the error but this is not a solution as the files need to be on the network drive. This error affects multiple macro files on the share drive not just a single file.

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.

0 comments

Answer accepted by question author

Anonymous

Hi Folks,

Same issues for me... We have built a business around sharing files online via one drive folders, inside these folders we have excel files with clever VBA.

With this security update we are wiped out. No one can update the files and work online. After countless tickets with microsoft and numerous screen shares with their support we got nowhere! Over the last few days I have switched every conceivable setting on/off, tried certificates etc and no one could solve our issue.

I finally stumbled upon a solution myself, I had been coping the url direct from one drive and making that a 'trusted source' which does not work.... Then it finally clicked with me that the file is being opened 'locally' in a download folder so the issue is not one drive rather it's the download folder that is blocking the macros from running.

Here is the steps I took to fix the issue....

Go to your ( main ) folder on one drive where you store the files, if you have sub folders then it's the top folder we are looking for, ie the parent folder.
Right click file, open with Excel App..... ( Not excel online ).... The security warning will come up "Microsoft has blocked macros from running because the source of this file is untrusted"
Click 'file' on excel, then look for the file you have just opened in the list of options below
Right click on the file itself and mouse scroll to 'open file location' then goto the address bar and copy this address.... for me this is https://d.docs.live.net/ then lots unique of numbers.... I omitted the numbers and stopped it at the forward slash /.
Once you have copied this address, cross away and then go to the file section and click options at the bottom ( or more > then options )
Click 'Trust Centre', then 'Trust Centre Settings'
Then look on the left for 'Trusted Locations' and click.... then click 'add new location'
Insert the copied link... for me it was "https://d.docs.live.net/"... likely this is the same for you, but just incase it's downloading locally to somewhere else it's worth checking that's why I put in point 4.
Then tick 'subfolders of this location are also trusted'... Thats important if you have lots of subfolders on one drive as the macros will be blocked in them unless you check this.
That's it done

You should now be able to right click files in one drive ( with macros ) from excel and stuff will sync etc.

Hope this helps for some people

Thanks

Tommy

0 comments

41 additional answers

Anonymous

2023-03-17T15:05:02+00:00

Zee when is Microsoft going to fix this???? This is causing enormous issues!
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2022-06-28T08:53:08+00:00

Thank you very much for your kind support.
Was this answer helpful?

0 comments No comments
Anonymous

2022-06-22T10:21:56+00:00

Hi,

Many Thanks,

The solution suggested works for my cases.

Regards.
Was this answer helpful?

0 comments No comments
Anonymous

2022-06-20T21:31:32+00:00

Dear Eric,

Thank you for posting in Microsoft Community. We are happy to help you.

I understand that you have a concern on cannot open the file and received a message Microsoft has blocked macros from running because the source of this file is untrusted. Apologies for the inconvenience caused to you by this behavior. You said re-mapping the network drive does not resolved the concern on your side.

Kindly right click on the affected file > properties and check if you can see the option Unblock.

Related article: Microsoft has blocked Macros from running because the source is - Microsoft Community

Here is the Official article about the concern Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Docs.

I would suggest you to please raise a ticket Get support - Microsoft 365 admin | Microsoft Docs, our Support Engineer will help to check the concern and collect logs.

We look forward to your response. Thanks for your kind understanding. Stay safe and healthy always.

Sincerely,

Zee | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***
Was this answer helpful?

0 comments No comments