×

Prevent Microsoft Office Add-ins From Disappearing

By Chris Newman •  Updated: 10/05/16 •  2 min read
Stop Excel Add-in From Disappearing From Ribbon

Why Is This Happening?

This year (July 2016) Microsoft decided to heighten its 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.

How To Fix The Disappearing Add-in Ribbon Menu Bar In Excel

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)
How to prevent Microsoft Office Add-ins from disappearing by making the parent folder a trusted folder.

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.

How to prevent Microsoft Office Add-ins from disappearing using the properties security and unblocking.

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:

Keep Learning

Chris Newman

Chris Newman

Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X