Excel COM add is not loading during startup and have to add it manually

excel add-in comaddin
user2373210 picture user2373210 · Jan 10, 2018 · Viewed 45.2k times · Source

Excel COM addin is not loading during starting up and each time I have to add it manually. After checking the File > OPtions > Add-ins > Manage -> COM addins, I see that the 'add in' is in 'Unloaded' state. Not sure how to make it automatically load at startup.

enter image description here

Answer

user2373210 picture user2373210 · Jan 10, 2018

Here's what fixed the issue for me.

Steps:

  1. Start > type 'regedit'

  2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

  3. Then change the value of loadBehaviour to 3 for HyperionComAddin. As shown below. Just to clarify, this is the add-in that was not loading during start up for me. Picture in the question is to give an example.

  4. Close registry and reopen it to make sure that value has not changed.

  5. Now restart excel. enter image description here

Related questions

Exception from HRESULT: 0x800A03EC Error

I am getting "HRESULT: 0x800A03EC" error when running Excel add-in with following code: Excel.Range rng = ActiveSheet.Cells[x, y] as Excel.Range; string before = rng.Value2; string cleanV = System.Text.RegularExpressions.Regex.Replace(before, @"\s+", ""); rng.set_…

Read More
COM Add-in for Excel doesn't load when Excel is launched by opening file

Several users have reported that if they launch Excel by double-clicking an Excel file, the add-in will not load. But, if they open Excel via the Start menu (or Quick launch toolbar) the add-in loads fine. Some details, in case …

Read More
Creating add-in for Excel using C#

I want to use C# class methods in Excel. Can anybody guid me how to do it ? The C# component will be excel add-in. How to create setup for this addin, so that I just need to give setup to …

Read More