Microsoft has Blocked the Macros Because the Source is Untrusted

Macros can be used by hackers to gain access to your data

2 min. read

Updated onOctober 4, 2024

updated onOctober 4, 2024

Share this article

This article is translated in

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Many readers reported Microsoft has blocked macros from running because the source of this file is untrusted in Excel, and they are worried about this message.

When you click on theLearn Morebutton, it simply redirects you to a website that tells you in-depth about why you are seeing this error and also provides you with the solution.

What do I do if Microsoft has blocked macros from running?

Close the workbook.
Right-click on the workbook.
SelectProperties.
Under theGeneraltab, make sure to check theUnblockbox inSecurity.
Hit theApplybutton.
Nowopenthe workbook.
You will see the error message has now disappeared.
Click onViewon the top menu bar.
At the extreme right on the top menu bar, click onMacros.
In the new window that shows, hit theRunbutton. You will see the macros running without any issues.

Quick Tip:

Sometimes, to fix this kind of problem, you just have to use another app. WPS Office is a replacement for Microsoft Office which has the same functionality.

Perfect for creating and editing Word documents, spreadsheets, and presentations. You won’t feel any difference since you are using the same extensions and Office.

WPS Office

Also, note that any files downloaded to the trusted location will not be blocked by default. To view which locations are trusted, you can follow the steps below.

What error will you get when accessing macros downloaded from the internet?

Before the update, when you used to open macros downloaded from the internet, there was a simple warning that said Macros have been disabled.

But the good thing about this warning was that there was an Enable option that would fix the problem, and actually let you enable the content.

Now, after the update,users come acrossthe error sayingMicrosoft has blocked macros from running because the source of this file is untrustedwhen trying to run macros downloaded from the internet.

This isn’t the only security issue, many reportedOffice detected a problem with this fileandMost of the features have been disabledmessages. You may also encounter issues opening your Excel file because thepersonal.xlsb is locked for editingbut here’s how to bypass it.

Let us know in the comments below if you were able to fix this problem using the above method or not. You can also let us know of any other alternative method that fixed the problem for you.

Microsoft has Blocked the Macros Because the Source is Untrusted#

What do I do if Microsoft has blocked macros from running?#

WPS Office#

What error will you get when accessing macros downloaded from the internet?#

Microsoft has Blocked the Macros Because the Source is Untrusted

What do I do if Microsoft has blocked macros from running?

WPS Office

What error will you get when accessing macros downloaded from the internet?