![](/uploads/1/2/5/7/125778590/407691275.jpg)
Is anyone having a problem with Excel add-ins not loading in Excel 2016, 2013, or 2010? This was not a problem with Office 2016 builds prior to build 7070, released July 12, 2016. Any workarounds?
OfficeAddinDev
OfficeAddinDevOfficeAddinDev
The Excel version will be listed under the Subscription Product section. Click the About Excel button. The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window. How to Install Power Query Excel 2016. Power Query is included with Excel 2016 (Office 365). I am trying to run two independent instances of Excel 2016 side-by-side; one with volatile functions and one without. The reason being that volatile functions react to change in any workbook within a single application instance, not just the workbook they exist in.
2 Answers
This problem results from security patch in KB31152, released in July 2016. According to private communication with Microsoft software engineers:
'With this update, we changed the behavior of Excel so that it will not load certain file types (including .xlam) when they are untrusted. The easiest workaround is to find the add-in that is causing you trouble, right-clicking on it in Windows Explorer, and checking Unblock'
An easier approach is to simply place the add-in in a Trusted Location (in Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations), such as the following folder, and load it from there:
Unfortunately, Microsoft failed to clearly document this major, 'breaking' change (as of this writing), leaving probably hundreds of thousands (millions?) of Excel users wondering why their add-ins are not loading. They did, however, bury some useful information about this issue in a blog post:
OfficeAddinDevOfficeAddinDev
Seehttp://www.jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.aspabout downloaded internet files.
(Does not solve my problem, but...)
TuntableTuntable
Not the answer you're looking for? Browse other questions tagged microsoft-excel or ask your own question.
![](/uploads/1/2/5/7/125778590/407691275.jpg)