MS Excel Add-Ins


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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s