Add-ins tab is not visible in Ms Excel 2016

Question

Have installed data analysis and Real statistics pack . But Add-ins tab is not visible in Ms Excel 2016

Answer 1

Hi,

Go to File-> Options->Customize Ribbon. On the right side, you will see the Customize the Ribbon option. Select the Developer option from the list and click OK. 

Now the Developer tab will be appear in the main tab. In the developer tab, Add-ins option is available. You can check them easily like this:

I hope it will work for you.

Answer 2

Hi,

Did you add the add-ins tab from the customize ribbons tab in word options window?

You may follow the below steps and check if you can see the installed add-ins.

1. Click on File < Options < Add-ins.
2. Under Manage select Excel Add-ins and click on “Go”.

Reference:

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

Hope the information helps.

Thank you.

Answer 3

Thanks Deepak ,

I have added it , have installed add-ins like data analysis and real stats . checked it in add-ins dialog box too ( please check the attachment) .

But still not able to see Add-ins tab on main menu .

Answer 4

There are two separate issues.

(A) When the Analysis ToolPak is properly installed, the Data Analysis item will appear on the far right end of the Data ribbon. The Add-Ins ribbon is not involved.

(B) If a VBA add-in uses only legacy code that would add an item to the Tools menu in pre-2007 Excel (and the VBA add-in does not explicitly include code for adding its own ribbon), then the menu item will appear in the Add-Ins ribbon. However, after you install the add-in, you may have to quit Excel and relaunch Excel to have the menu item appear.

Furthermore, hopefully temporarily, you may have to use the Windows 10 File Explorer to Unblock the XLAM file. See "Real Statistics disappears from Addin ribbon" at http://www.real-statistics.com/blogs/