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.

Trainings

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

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Add-ins do not load

Excel add-ins fail to load

Introduction

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.

Solution

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: http://www.howtogeek.com/70012/what-causes-the-file-downloaded-from-the-internet-warning-and-how-can-i-easily-remove-it/


Comments

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

 


Comment by: Eddy Van Wulpen (3-7-2019 14:01:00)

Hi Jan Karel,

put a date in a cell
DatePicker works
Go to Cell Properties>Properties>Unlock
Now Protect sheet>Unlocked cells only
DatePicker failed

Solution:
Protect sheet>Unlocked cells + Edit objects
DatePicker works
Disadvantage: all other objects in the sheet can be moved or changed

 


Comment by: Jan Karel Pieterse (3-7-2019 16:17:00)

Hi Eddy,

Hmm, This is probably implementation-specific and has nothing to do with the page (this page) you placed your comment on. Depending on how this DatePicker works, the code will need to be adjusted.

 


Comment by: Adam Alhayek (25-11-2019 16:33:00)

hi

when i try to add date i get msg " run-time error '13'
" type mismatch"

 


Comment by: Jan Karel Pieterse (25-11-2019 16:42:00)

Hi Adam,

When exactly do you get this message? Is it with any of my downloads? If so, which one?

 


Comment by: Mollie (29-4-2020 08:19:00)

The latest version of Excel for Office 365 doesn't even show the "security....unblock" option in the properties of the date picker. Is there a newer workaround to have the datepicker reliably show up?
Note: I couldn't unzip to the suggested xlstart folder, because my Microsoft Office isn't listed in the x86 Program folder. Any advice?

 


Comment by: Jan Karel Pieterse (29-4-2020 10:18:00)

Hi Mollie,

Whether or not you see the Unblock button/checkbox is not caused by Office but rather by Windows I'm guessing. You are aware that you should be accessing the properties dialog from Windows Explorer?

 


Comment by: Carlos Ferreira (25-5-2020 18:16:00)

I need it on VBA.

 


Comment by: Jan Karel Pieterse (26-5-2020 11:02:00)

Hi Carlos,

Can you please elaborate what you "need on VBA"?

 


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: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

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

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.