We recently moved to a new laptop and suddenly, when opening a blank new workbook, received the message that ‘Microsoft has blocked macros from running because the source of this file is untrusted’ which is extremely strange as it is a blank workbook, with nothing in, especially not macros.
Table of contents
New workbook = untrusted file?
As shown below we get this message when creating a new workbook. This message however, doesn’t really help much.
Find workbook with ‘Application add-ins have been disabled’ message
Try and open another file which has something in it, and you may see the below message saying ‘Application add-ins have been disabled’. Again a strange message as this file has no macros and does not reference any add- ins, but at least it has the Options button which will give us a clue of where the problem is.
When you click on options it says that one of the Add Ins we have is not trusted (strange because it was fine on the previous computer), but you can see part of the path which is key.
Find the full path which you can normally do by using Windows File Explorer to find the Add-In name.
Make new workbooks trusted
If you trust the Add In, then go to FILE & OPTIONS as shown below
Click on Trust Centre and Trust Centre Settings.
Choose the
- Trusted Locations,
- then click ‘Add new location,
- enter the path to where the problem is (note that it is to the folder, not the actual add in),
- and click OK
You will need to restart your Excel, but the ‘Microsoft has blocked macros from running because the source of this file is untrusted’ message should disappear.
Related
Not Enough System Resources to Display Completely
Excel not finding a workbook that you know is in the location
What is lost when a workbook corrupts and you try repair it
Test your (or others) Excel skill level- no more awkward Excel interviews