Home / Important Information
Please ensure every time you wish to use one of the resources, you revisit the 20:20 Innovation website and download the latest version of the resource. This will ensure that you are always using the latest template and are aware of any updated guidance on the resource.
In 2022, Microsoft released a new version of Microsoft Excel that brought in advanced security protection against Excel Macros. In their aim to safeguard users from malicious macros, Microsoft made the security so tight that users now 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. As a number of the 2020 spreadsheets and resources contain Macros, and you will need to review and follow the procedures below to ensure they work effectively.
Some users when they download Excel resources will get the error message below 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 redirects you to the Microsoft website that tells you in-depth about why you are seeing this error and also provides you with the solution.
You have the choice of Unblocking a single file or Unblock all files from a specific network share or website.
We suggest you follow the instructions to Unblock all files from a specific network share or website so you have full access to the suite of 2020 resources available to you. Please follow the steps outlined on Microsoft support page, scroll half way down the page to the Unblock all files from a specific network share or website section.
For an individual file, such as a file downloaded from an internet location or an email attachment the user has saved to their local device, the simplest way to unblock macros is:
Some users may see a Macro SECURITY WARNING when opening some of the Excel resources, as shown in the figure below. If you see the message below, simply select the Enable Content button to permit use of the macro within the Excel document.
If you wish to change your Macro settings, please see the procedures outlined on the Microsoft website.
Please speak to your companies system administrator who can help amend these settings. By way of example, at 20:20 Innovation, we use the setting settings to “Disable all macros with notification” this means that by default macros are disabled, but security alerts appear (as per figure above) if there are macros present.