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?

  • This a build from the Release branch or the Insider Preview branch?
    – Ramhound
    Jul 21 '16 at 22:24
  • Release. It was pushed through via automatic Office updates. Jul 22 '16 at 0:26
  • I have Adobe Acrobat installed, and after I updated to build 7070, the Excel Adobe PDF add-on toolbar still was visible.
    – Ramhound
    Jul 22 '16 at 0:42
  • Adobe might be a COM add-in. This seems to only affect VBA add-ins. Jul 23 '16 at 12:56

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:

C:\Users\%USER NAME%\AppData\Roaming\Microsoft\Excel\XLSTART

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:



See http://www.jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp about downloaded internet files.

(Does not solve my problem, but...)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.