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-09-28T10:53:32+00:00

    One drive, another initiative from Microsoft. I deleted everything associated with OneDrive after Microsoft decided it was a good idea to hijack my file system and take over my documents folder. Disgraceful behaviour. If it weren't for my work using windows, I would scrap it entirely for an Open Source operating system.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-09-28T07:32:29+00:00

    I know its many weeks later than when this was asked, but I just hit this problem myself.

    What worked for me was the internet properties : security tab : trusted sites : then adding 'https://d.docs.live.net' as a trusted site. Then I enabled trusted sites in excel and it seemed to work.

    I have no idea why, but it works now, but I am not very tech savvy so I don't know if it will work for you.

    Hi Everyone...

    This is the solution. It works.

    You can now run macros in files saved on Onedrive with this fix.

    Thanks.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-09-27T15:26:10+00:00

    I know its many weeks later than when this was asked, but I just hit this problem myself.

    What worked for me was the internet properties : security tab : trusted sites : then adding 'https://d.docs.live.net' as a trusted site. Then I enabled trusted sites in excel and it seemed to work.

    I have no idea why, but it works now, but I am not very tech savvy so I don't know if it will work for you.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-09-20T16:53:02+00:00

    How do I find the file server name for my router where the hard drive is connected?

    Was this answer helpful?

    0 comments