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. Save the file to a local hard drive, network share, or cloud share like OneDrive. Open Windows File Explorer and go to the folder where you saved the file. Right-click the file and choose Properties from the context menu. 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

Hi Edwine,. I have the same problem when I open an XLSM that I use daily to track hours worked. See message below that appears on opening: I have tried all suggestions and nothing works When I access properties I don't see the popup that allows me to unblock (as illustrated below) The options available to me, when I click on PROPERTIES/GENERAL/ADVANCED TAB are: Guidance would be gladly appreciated as this is an extremely important spreadsheet for me Kind Regards Eithne

Dear Ryno, Thanks for reporting the issue here, we appreciate your effort and time to share the experience and I'm very sorry that you can’t access your Macro-enabled files, which has caused inconveniences to your daily work! As mentioned in this article Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Docs To help improve security in Office, we’re changing the default behavior of Office applications to block macros in files from the internet. With this change, when users open a file that came from the internet, such as an email attachment, and that file contains macros, the following message will be displayed: If you right click the Excel file and go to Properties> in General tab, can you find a check box for Unblock ? If yes, select the checkbox and then check if you can run macro in the file. If you cannot find the Unlock checkbox, could you share with us the version and channel of your Excel application? Thank you for your understanding and time. Sincerely, Edwine | Microsoft Community Moderator

Dear ED20212021, It looks like the situation on your side is a bit different as you cannot find the Unblock checkbox when you go to the file’s property. We’d like to confirm what is the version and channel of your Excel application? As mentioned in the article, the change is released to Current Channel(Preview) version 2203 and Current Channel version 2205. ![](https://learn-attachment.microsoft.com/api/attachments/157cdd7f-2fe5-4916-8511-5ca23281ce74?platform=QnA At the same time, we’d like to confirm that does the issue appear when you open a specific XLSM file or different XLSM files? Thank you for your understanding and time. Sincerely, Edwine | Microsoft Community Moderator

Hi Edwine, Thanks for the response. The "Unlock" checkbox does not show in the Properties / General window. It was a file that I developed myself and is not from the internet. Our entire organization uses Office 365. Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20028) 32-bit Thanks, Ryno

Microsoft has blocked macros from running

Anonymous

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.

Save the file to a local hard drive, network share, or cloud share like OneDrive.
Open Windows File Explorer and go to the folder where you saved the file.
Right-click the file and choose Properties from the context menu.
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

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,

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

0 comments

112 additional answers

Anonymous

2022-06-12T07:05:22+00:00

Hi Edwine,. I have the same problem when I open an XLSM that I use daily to track hours worked.

See message below that appears on opening:

I have tried all suggestions and nothing works

When I access properties I don't see the popup that allows me to unblock (as illustrated below)

The options available to me, when I click on PROPERTIES/GENERAL/ADVANCED TAB are:

Guidance would be gladly appreciated as this is an extremely important spreadsheet for me

Kind Regards Eithne
Was this answer helpful?

10+ people found this answer helpful.

0 comments No comments
Anonymous

2022-06-13T11:31:50+00:00

Dear Ryno,

Thanks for reporting the issue here, we appreciate your effort and time to share the experience and I'm very sorry that you can’t access your Macro-enabled files, which has caused inconveniences to your daily work!

As mentioned in this article Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Docs

To help improve security in Office, we’re changing the default behavior of Office applications to block macros in files from the internet. With this change, when users open a file that came from the internet, such as an email attachment, and that file contains macros, the following message will be displayed:

If you right click the Excel file and go to Properties> in General tab, can you find a check box for Unblock? If yes, select the checkbox and then check if you can run macro in the file.

If you cannot find the Unlock checkbox, could you share with us the version and channel of your Excel application?

Thank you for your understanding and time.

Sincerely,

Edwine | Microsoft Community Moderator
Was this answer helpful?

2 people found this answer helpful.

0 comments No comments
Anonymous

2022-06-13T11:34:05+00:00

Dear ED20212021,

It looks like the situation on your side is a bit different as you cannot find the Unblock checkbox when you go to the file’s property.

We’d like to confirm what is the version and channel of your Excel application?

As mentioned in the article, the change is released to Current Channel(Preview) version 2203 and Current Channel version 2205.

![](https://learn-attachment.microsoft.com/api/attachments/157cdd7f-2fe5-4916-8511-5ca23281ce74?platform=QnA

At the same time, we’d like to confirm that does the issue appear when you open a specific XLSM file or different XLSM files?

Thank you for your understanding and time.

Sincerely,

Edwine | Microsoft Community Moderator
Was this answer helpful?

0 comments No comments
Anonymous

2022-06-13T12:52:05+00:00

Hi Edwine,

Thanks for the response.

The "Unlock" checkbox does not show in the Properties / General window. It was a file that I developed myself and is not from the internet.

Our entire organization uses Office 365.

Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20028) 32-bit

Thanks,

Ryno
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments