Notably, this update was meant to protect users from running potentially harmful macros that hackers may create to gain access to the user’s personal data. 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 an excel 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. 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. 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.
How do you fix 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.
Under the General tab, make sure to check the Unblock box in Security.
Hit the Apply button.
Now open the workbook.
You will see the error message has now disappeared.
Click on View on the top menu bar.
At the extreme right on the top menu bar, click on Macros.
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. 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 alternate method that fixed the problem for you.
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
