Hi there,
We are migrating our users from Office 2010 to Office 2016. Our users frequently use 3rd party add-ins for Excel. These add-ins have been enabled in Excel but the Add-ins tab is not displaying in the ribbon.
Any ideas?
Thanks,
Jake
June 10, 2024
HansV MVP - Ashish Mathur - Andreas Killer - Jim_ Gordon - Rich~M ✅
Hi there,
We are migrating our users from Office 2010 to Office 2016. Our users frequently use 3rd party add-ins for Excel. These add-ins have been enabled in Excel but the Add-ins tab is not displaying in the ribbon.
Any ideas?
Thanks,
Jake
Reported content has been submitted
* Please try a lower page number.
* Please enter only numbers.
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:
Click on the File tab.
Go to Options.
Click Add-ins.
In the Manage section, select COM Add-ins and click on Go.
Now uncheck the Add-ins and click on OK.
For more information, you may refer to the following article and check:
Please post to us if you need any further assistance and we will assist you.
Thank you.
Reported content has been submitted
43 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi Sagnik,
Thanks for your email.
I tried the suggestion but I'm seeing the same behavior as before.
Thanks,
Jake
Reported content has been submitted
4 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi Jake,
Thank you for replying back to us.
Please refer to the following thread which discusses about the same issue and check if it helps in resolving your issue:
Please post to us if you need any further assistance and we will assist you.
Thank you.
Reported content has been submitted
2 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Go to File Options Add-ins Manage
Select Com Add-Ins and click Go
Check the missing add-ins
Reported content has been submitted
38 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
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.
Reported content has been submitted
312 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Reported content has been submitted
2 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Great, thanks a lot...was not aware that the file itself was blocked !!!
cheers
Reported content has been submitted
3 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Reported content has been submitted
3 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
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
Reported content has been submitted
19 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.