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, I have exactly the same problem. This is the pop-up I get when I try running my macro. My macro creates a template using "Set open_doc = CreateObject("Word.Application")" which uses the path "C:\Users\USERNAME\AppData\Local\Microsoft\Windows\INetCache\Content.Word That is a path which cannot be added into Trusted locations - The path you have entered cannot be used as a Trusted Location for security reasons. I also don't have the checkbox in the properties of the file. I need an override for this issue.. a way to directly write the trusted locations into the registry or something. Thank you.

Microsoft is crazy they are destoying one of the competive advantages they have vs other sw office solutions! Today MS products are untrusted and they are blocked by me a my company because I've macro solutions in place and people dependent on them. They should revert the changes because all solutions they presented either are not working properly or they don't exist!

This is a lame attempt by some folks at Microsoft trying to ruin Microsoft Excel without thinking of the millions of users using macros. I heard that they were rolling back the update but not sure. Everyone is now stuck and clueless.

Can Microsoft Support guide me on what to do with this error. This error is appearing today in all the Excel files. The surprising thing is all these files were created by me and not downloaded from internet or received from external senders. And I've not created a macro.. What steps can be taken to address this? is this a malware attack?

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-08-31T10:30:32+00:00

Hi,

I have exactly the same problem. This is the pop-up I get when I try running my macro. My macro creates a template using "Set open_doc = CreateObject("Word.Application")" which uses the path "C:\Users\USERNAME\AppData\Local\Microsoft\Windows\INetCache\Content.Word

That is a path which cannot be added into Trusted locations - The path you have entered cannot be used as a Trusted Location for security reasons.

I also don't have the checkbox in the properties of the file.

I need an override for this issue.. a way to directly write the trusted locations into the registry or something. Thank you.
Was this answer helpful?

0 comments No comments
Anonymous

2022-08-31T09:39:28+00:00

Microsoft is crazy they are destoying one of the competive advantages they have vs other sw office solutions! Today MS products are untrusted and they are blocked by me a my company because I've macro solutions in place and people dependent on them. They should revert the changes because all solutions they presented either are not working properly or they don't exist!
Was this answer helpful?

0 comments No comments
Anonymous

2022-08-31T06:23:16+00:00

This is a lame attempt by some folks at Microsoft trying to ruin Microsoft Excel without thinking of the millions of users using macros.
I heard that they were rolling back the update but not sure. Everyone is now stuck and clueless.
Was this answer helpful?

0 comments No comments
Anonymous

2022-08-31T05:51:20+00:00

Can Microsoft Support guide me on what to do with this error. This error is appearing today in all the Excel files. The surprising thing is all these files were created by me and not downloaded from internet or received from external senders. And I've not created a macro.. What steps can be taken to address this? is this a malware attack?
Was this answer helpful?

0 comments No comments