Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Add-ins do not load

Excel add-ins fail to load


Lately (I wrote this page on August 17, 2016) I've been getting reports from people complaining that they can no longer use add-ins. In this article I describe the problem and a solution.

The problem

Even though an add-in has been "installed" into Excel using the Add-ins dialog its userinterface does not show. This is that dialog:

Add-ins dialog of Excel

As you can see, some add-ins are checked. But sometimes the user-interface of an add-in fails to display. In fact, the add-in file will not open in Excel at all, even if you try from Windows Explorer, or from File, Open from within Excel. Without any error message.

The cause

A recent Office Security update has caused any file downloaded from the internet (so this includes add-ins) to be marked as Blocked. Even if those files were in a zip container, they are marked as blocked. And Excel will simply not open them.


Unblock the files! Like so:

1. Copy the file from the zip file to any folder

2. Right-click the file and choose properties:

Select file properties

3. Click the Unblock button:

Click Unblock

Other resources

If you have a folder full of blocked files, this page describes a way to unblock all of them using Powershell.

And a great article by fellow-MVP Jon Acampora: Excel Add-in Ribbon Disappears After Installation.

This article describes the mechanics of the problem very well:


Showing last 8 comments of 10 in total (Show All Comments):


Comment by: Gunthor (10/19/2016 10:43:36 AM)

I've been looking for this answer for 2 months...
M A N Y T H A N K S :-)


Comment by: Ralph (2/7/2017 4:00:17 PM)

THANK YOU!!! I've been searching for this solution for a long, long-time!


Comment by: Wei (2/17/2017 7:37:12 AM)

I tried, but still failed, I also tried to update the regedit, move the dll file to a safe location. Almost feel crazy.......


Comment by: Jan Karel Pieterse (2/20/2017 9:57:33 AM)

Hi Wei,

The article is about Excel-based add-ins (xla and xlam files), not about dll files.


Comment by: king_faisal (10/1/2017 1:03:12 AM)

We are using Dose for Excel Add-In that provides more than +100 functions and features specialized in Excel editing and data manipulating, please consider this add-in in your post since it is so useful for Excel end-users.


Comment by: James Witherspoon (12/26/2017 7:57:51 PM)

Excel 2003 no longer can load Name Manager. When trying to install the addin I get this error from Microsoft Visual Basic: "Errors occurred during load". Clicking the "help" button says to check the log file but I have no idea where that file is located. I unblocked the Name Manger.xla file, as instructed, but that did not help.


Comment by: Jan Karel Pieterse (12/27/2017 11:24:58 AM)

Hi James,

What happens if you launch Excel first (from its shortcut)?


Comment by: Doug Hesketh (2/8/2018 9:45:56 AM)

This was exactly the cause of my issue, a simple resolution and my frustration has disappeared. Thank you.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here:

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].