New workbook gives ‘Microsoft has blocked macros from running because the source of this file is untrusted’

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.

New workbook = untrusted file?

As shown below we get this message when creating a new workbook. This message however, doesn’t really help much.

Microsoft has blocked macros from running because the source of this file is untrusted

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.

Application add-ins have been disabled

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.

Microsoft has blocked macros from running because the source of this file is untrusted

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

Application add-ins have been disabled

Click on Trust Centre and Trust Centre Settings.

Microsoft has blocked macros from running because the source of this file is untrusted

Choose the

  1. Trusted Locations,
  2. then click ‘Add new location,
  3. enter the path to where the problem is (note that it is to the folder, not the actual add in),
  4. and click OK
Application add-ins have been disabled

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.

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