Enable Excel Add-In

[FryGirl]

I have an Excel Add-In which I installed through the Excel Options -- Add-ins -- Manage Excel Add-ins and placed a check next to the add-in.

This add-in use to load fine and I would see it through the Ribbon under the Add-Ins tab, but it no longer shows up.

If I look in the VBE the code is there and if I look in the Excel Options it show up as an Active Application Add-in.

Any thoughts on how to get the Add-in to show back up in the Ribbon?

 

[JoeMo]

Have you tried unchecking the add-in in the add-ins manager, then close Excel, reopen Excel and check it again?

 

[FryGirl]

Hi Joe,

Yes I have tried that but still will not show up.

 

[JoeMo]

Hi Joe,

Yes I have tried that but still will not show up.

How about this:
Close Excel
Go to the folder containing the add-in (.xla or .xlam file) and rename the file.
Reopen Excel and go to the add-ins manager and click on the old file name. This should prompt a dialog box indicating Excel cannot find the file and asking you if you want to delete it - say yes. Now browse to the add-ins folder and select the newly renamed file and check its box.
You may have to tweak this procedure a bit as my memory is rusty.

 

[ZVI]

The Add-In can be disabled by Excel, for example after fault.

To re-enable Add-In that has been hard disabled by Excel:

1. In Excel 2007 click the Microsoft Office Button (or menu File in Excel 2010+)
2. Click the Excel Options button
3. In the categories pane click Add-ins
4. In the details pane locate the add-in in the Disabled Application Add-ins list
5. In the Manage box click Disabled Items and then click Go
6. Select the add-in and click Enable
7. Click Close

In Excel 2003 it's in menu Help – About – Disabled Objects.

 

[FryGirl]

Thanks all. Tried all these methods but nothing worked.

 

[ZVI]

If I look in the VBE the code is there

There can be issue with Add-In's code.
1. What happens if you run the code manually from VBE or by Alt-F8?
2. Is it working on another PC?
3. Can you provide the link to that Add-In or upload/send it for analyzing?