Unable to load 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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.