- After an update, Microsoft has blocked running macros on files downloaded from the internet.
- This is getting in way of many individuals who rely on running macros from files available on the internet.
- This guide explains the simple method that can help you fix the Microsoft has blocked macros from running because the source of this file is an untrusted error.
In 2022, Microsoft released a new version of Microsoft Excel that brought in advanced security protection against Excel Macros.
However, in their aim to safeguard users from malicious macros, Microsoft made the security so tight that users came across an error message saying Security Risk – Microsoft has blocked macros from running because the source of this file is untrusted.
In simple words, the Microsoft change blocked the macros on files downloaded from the internet. But since macros are a great way to automate Excel and make your life easy when working on a sheet, not being able to use genuine macros could hamper the productivity of several users.
Thankfully, this guide mentions a couple of ways that you can follow and fix the Microsoft has blocked macros from running because the source of this file is an untrusted error. Let us check out the guide itself.
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 across the error saying Microsoft has blocked macros from running because the source of this file is untrusted when trying to run macros downloaded from the internet.
How we test, review and rate?
We have worked for the past 6 months on building a new review system on how we produce content. Using it, we have subsequently redone most of our articles to provide actual hands-on expertise on the guides we made.
For more details you can read how we test, review, and rate at WindowsReport.
When you click on the Learn More button, 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.
From Microsoft’s point of view, by adding an extra few steps, they are trying to protect users by only enabling files that they trust. Now, let us check out the method you can use to fix this error.
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 OfficeGet the job done quickly and don’t put off any of the tasks.
How do I do if Microsoft has blocked macros from running because the source is untrusted?
This simple method will help you get rid of the annoying cannot run Macros error message, and you can now download files from the internet to run macros on Excel without any issues.
2. Right-click on the workbook.
3. Select Properties.
4. Under the General tab, make sure to check the Unblock box in Security.
5. Hit the Apply button.
6. Now open the workbook.
7. You will see the error message has now disappeared.
8. Click on View on the top menu bar.
9. At the extreme right on the top menu bar, click on Macros.
10. In the new window that shows, hit the Run button. You will see the macros running without any issues.
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.
- Open the workbook.
- Click on File.
- Select Options.
- Click on Trust Center from the left pane.
- Press Trust Center Settings on the right.
- Select Trusted Locations from the left.
- Here you will see your trusted locations.
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.