Add-ins Tab Not Showing in Ribbon In Excel 2016

Here are two possible explanations.

(A) If you are using an Excel VBA add-in which correctly uses the pre-2007 methods for adding a custom tool bar or menu item, and if it is correctly installed, then there will be an "Add-Ins" tab added to the ribbon with a "Menu Commands" group. 

In Windows Excel 2013 and 2016, after you click the checkbox in the Add-ins Available list, the Add-Ins tab may not appear until you quit Excel and restart.

Instead, if your add-in creates a 2007-and-later ribbon and does not use the pre-2007 methods, then Excel will not show an "Add-Ins" tab.

(B) Microsoft added some extra security features in July 2016.

Depending on your system and settings and file location, you may have to unblock downloaded files before use.

In your Windows file manager, right-click the XLA or XLAM file, choose Properties > General, check the Unblock box, and click OK.

Then start Excel and use File > Open to load the add-in file.

Found this: https://community.spiceworks.com/topic/457676-excel-2013-add-ins-tab-keeps-disappearing-from-ribbon

In a nutshell:

Disable all add-ins (including Analysis Packs)

Close Excel and Re-open

Re-enable all add-ins except Analysis Packs

Close Excel and Re-open

Enable Analysis pack add-ins

Seems to have worked for me.

Hi Jake,

I understand that your Excel add-ins are not showing up in Excel 2016.

I suggest you to start Excel in safe mode and check if it helps. To do that, close Excel. Click on Start> All Programs> Accessories> Run, and in the open box type in Excel /safe and hit ok.  

Note: There is a space between Excel and /. 

If the application works fine safe mode, try disabling the add-ins for the application and check the result:

1. Click on the File tab.
2. Go to Options.
3. Click Add-ins.
4. In the Manage section, select COM Add-ins and click on Go.
5. Now uncheck the Add-ins and click on OK.

For more information, you may refer to the following article and check:

https://support.office.com/en-us/article/Add-or-remove-add-ins-in-Excel-2016-for-Windows-d3a00532-d99c-45d2-928e-5ed6f4006b64

Please post to us if you need any further assistance and we will assist you.

Thank you.

Go to File Options Add-ins Manage

Select Com Add-Ins and click Go

Check the missing add-ins

It doesn't solve the issue. The add-ins get loaded on starting Excel, yet the Add-in tab does not show. When moving the position of the tab using Customise Ribbon, you can see the tab flicker briefly on the ribbon, then it is gone again.

Strangely, on a different login account on the same PC, there is no issue at all with exactly the same add-ins.

Bug, Bug, Bug