Excel Add-in will install but won't load

Posted on 2008-11-04
Last Modified: 2012-05-05
I have written a C# addin for Excel using the following article as a template:
It installs and loads with Excel correctly on my machine and another (non-developer) machine.
However on another user's machine it installs but doesn't load when Excel starts.

We've all got the the same version of Excel (2003 SP3).

As the Add-in is a C# one, it's a DLL not an XLA file, so it doesn't show up in Excel > Tools > Add-Ins.

Does anybody know what I need to do to get the add in working on this other machine?  Let me know if you need any more details.
Question by:openshac
    LVL 50

    Expert Comment

    by:Dave Brett
    I haven't used a DLL addin before, but with a standard XLA you can have an issue if there is a fastopen switch
    in the Registry addin path, under  either
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Add-in Manager


    LVL 6

    Author Comment


    Thanks, but I checked and  there are not fastopen switches there in my registry.
    LVL 6

    Author Comment

    OK, I think I may have it:

    Some of the end users don't have the Office 2003 Primary Interop Assemblies installed.
    LVL 6

    Accepted Solution

    OK, I needed one more thing, which I found at

    2.       If your add-in is supposed to be loaded at application startup, look at the LoadBehavior for your Add-In in registry and make sure it is set to 3. This is necessary because, whenever an Add-In load fails, Office disconnects the Add-In (Loadbehavior changes to 2).

    Because it failed when I didn't have the Office 2003 Primary Interop Assemblies installed I had to fix up the load behaviour.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now