Microsoft has blocked macros from running

Anonymous
2022-06-08T03:54:07+00:00

Hello All,

you might know that " Microsoft has blocked Macros from running through internet" do we have any permanent solution on this?

I have tried the below solution which doesn't work.

  1. Save the file to a local hard drive, network share, or cloud share like OneDrive.
  2. Open Windows File Explorer and go to the folder where you saved the file.
  3. Right-click the file and choose Properties from the context menu.
  4. At the bottom of the General tab, you should see a section for Security. Select the Unblock checkbox and select OK.

Also, tried to enable Macros through Macros settings through Trust center but didn't work?

is there any permanent solution on this?

Thanks,

AMit

Microsoft 365 and Office | Excel | For business | 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.

0 comments
Answer accepted by question author
Anonymous
2022-06-17T08:05:21+00:00

Hi,

I think I found a solution to my problem.

The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.

Mapped Location:

\fileserver\networkdirectory and not \[192.xxx.xxx.xxx]\networkdirectory

Hope it helps someone out there.

Regards,

Ryno

Was this answer helpful?

100+ people found this answer helpful.
0 comments

112 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2022-06-28T12:37:07+00:00

    I had the exact same problem which was being experienced by some of my clients with them even threatening to sue our it support services for lose of business due to this issue. Microsoft support were totally useless on all fronts just referring me to a number of support articles which i obviously tried countless time before even getting in touch with them and lets just say that i personally found their support disappointing and pathetic, but in regards to your problem. I found a solution that did work after some playing around on my side.

    thre

    What worked for me was to go through control panel, then go to internet options and then select "change security settings". From there select the security tab add the source location of the files to either Local intranet or teh Trusted sites location. ( I then also reduced the security level of these sources to the lowest possible settings (not sure if this was necessary or recommended but i was just experimenting). The files have since been able to work without the blocked macros restrictions.

    I am still playing around with this but since doing this my clients are able to work normally again which is what is important. I will be pushing this setup through group policy on our various clients servers to prevent any further problems from occurring in the future and will try update on how this goes. But for now, this is the only solution that worked.

    If anyone else can try this and update, please do share.

    Microsoft, i don't need to hear from you. You were of absolutely no help in anyway so i'd rather take suggestions from the people that actually help....your affected customers ( the ones you don't care about)

    Was this answer helpful?

    10 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-06-28T05:08:42+00:00

    Microsoft messed up with their latest security settings. Can't open our own macro enabled excel files that we were using from years.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2022-06-28T05:07:04+00:00

    YE this worksthanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-06-24T08:44:31+00:00

    Hi,

    On my screen i don't see that unblock checkbox.

    Anybody knows how i can unblock the file??

    Kind regards,

    Tom

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments