Prevent Microsoft Office Add-ins From Disappearing From The Ribbon Interface

Blog Post Banner (hdr).png

This year (July 2016) Microsoft decided to heighten it's security features and block files that are downloaded from the internet or another computer by default. With regular files like a .xlsx or .pptx there is a prompt that notifies you the file is currently being blocked. Unfortunately, Microsoft was not kind enough to do the same thing with add-in files (.xlam or .ppam). Hence, leaving a TON of users scratching their heads as to why add-ins keep disappearing from their ribbon. 

If you have recently downloaded an add-in file from this site or any other, you will want to follow one of the laid out solutions described below.

If you are a video person, Jon Acampora (ExcelCampus.com) created a great little video that explains what I will be writing in this article.

Please note that the following steps are based on using the Excel Application. Other Microsoft applications may have slightly different steps to get to the end result.

Option 1: Make Parent Folder A Trusted Folder

This option is most preferred as any file saved into a trusted folder will be unblocked without changing each individual file's properties.

  1. Copy your folder path (ie Ctrl +C)
  2. Go To File > Options
  3. Select Trust Center > Trust Center Settings
  4. Go to Trusted Locations and select Add New Location
  5. Paste in your folder path (ie Ctrl + V) and click OK (3 times to close out of all the dialog boxes)

Click to enlarge

Option 2: Check Unblock Property*

  1. Right-click the add-in file
  2. Click Properties
  3. Check Unblock
  4. Click OK

*This option is not preferred because if an updated file is sent to you, you will have to remember to repeat the steps to unblock the file.

Hopefully, this solution gets your add-ins staying in place! In case this did not solve your issue, here are a couple more articles on the topic that may be of help: