Subscribe
in a readerExcel 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:
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:
3. Click the Unblock button:
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 30 in total (Show All Comments):Comment by: PhilUK (22-6-2018 10:44:37)
Like many of your followers I have used your addin since Excel 2003 and have appreciated your work for many years
I am now using Excel 2016
When I try to add a new name I get an error message headed "API Clipboard Copy", which states "Memory location could not be Unlocked. Clipboard copy aborted"
The added name is then listed but typically shows as referring to the active cell only
I have tried to edit the "refers to" but the same error message appears
Can you offer any advice?
Comment by: Ricardo Hernandez Tablas (19-7-2018 18:30:32)
Thanks a lot
Comment by: Aslam (18-10-2018 08:19:12)
Comment by: joan jiang (2-11-2018 20:38:01)
Comment by: Eddy Van Wulpen (2-7-2019 19:36:00)
only when I protect the sheet it doens't work,
even if you unlock the cell
Thank for helping me out
Comment by: Jan Karel Pieterse (3-7-2019 11:05:00)
I'm not sure what you are referring to?
Comment by: Eddy Van Wulpen (3-7-2019 14:01:00)
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)
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.
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.