MS Excel Add-Ins

Tags

Tech Trek – 2016.03.14

PROBLEM –
One or more MS Excel COM Add-Ins are not loaded correctly even after enabling items in Excel Options dialog.

RESOLUTION –

  1. Check whether the add-in is listed under Disabled Items in File … Excel Options.

    Excel-COMAddIns

  2. Otherwise, open registry editor and find the affected Add-Ins in the following registry key path. Change the LoadBehavior value data into 3 (Load at Startup).

    HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\
    HKEY_CURRENT_USER\Software\Microsoft\Office\Word\Addins\Excel-LoadBehavior

DISCLAIMER:
Make registry updates with care since changes can render your system into an unusable state. Make sure you have a system restore point, or necessary backup before doing changes.

Follow

Get every new post delivered to your Inbox.