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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-18T06:46:53+00:00

    Hi EDYOT,

    The view of Windows 11 is different, so the steps to connect to network drive are a little different than Windows 10, please check the support article below which describes the detailed steps:

    Map a network drive in Windows (microsoft.com)

    Regards,

    Neha

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-06-17T12:08:08+00:00

    Thanks Ryno. I have Windows 11 and not seeing the above. I work solo, so have just logged it with IT Service Provider. Thanks for all your help. Much appreciated ☺️☺️

    Was this answer helpful?

    0 comments
  3. lmacri 2,505 Reputation points
    2022-06-16T12:28:56+00:00

    Hi Amit Rakibe

    Is your issue similar to that described by Chris_H111 in their 14-Jun-2022 threadOffice 365 Macros Now Blocked on Local Network? If so, Chris was able to solve their problem "by mapping the server using \fileserver\servername instead of mapping the server IP and then adding that as a trusted location via Trust Centre".

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-06-16T08:06:47+00:00

    Hi Ryno,

    I understand the version you provided is an MSO version and it is hard to identify the actual version of your Office apps from this info. The version looks like xxxx (Build xxxxx.xxxxx click-to-run). Could you please provide us with the screenshot of Microsoft 365 app version? You will find this screen in any Office, click File>Account, as shown below.

    Image

    Also, may I know if this started happening after Windows or Office update?

    We look forward to your reply. Thanks for your cooperation.

    Regards,

    Neha

    Was this answer helpful?

    0 comments