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: Oldest
Most helpful Newest Oldest
  1. 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
  2. Anonymous
    2022-06-16T09:28:23+00:00

    Hi Neha,

    Above the version and the Build.

    I cannot confirm when updates happen in office. I know it started about two days before my first post to this thread.

    There is no need to post my spreadsheet, it is a spreadsheet with any macro that runs from our internal network. The problem is that I need to be able to trust a mapped network drive in the excel application.

    Regards,

    Ryno

    Was this answer helpful?

    3 people found 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-16T17:04:53+00:00

    WE are having the same problem not just excel its Access as well. Udates that seem to be causing it as workstations that havent updated can run them no problem.

    Also the "unblock" un the General tab is NOT there so we cant do that

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments