?
Solved

Excel Add-in will install but won't load

Posted on 2008-11-04
4
Medium Priority
?
691 Views
Last Modified: 2012-05-05
I have written a C# addin for Excel using the following article as a template: http://support.microsoft.com/kb/302901
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.
0
Comment
Question by:openshac
  • 3
4 Comments
 
LVL 50

Expert Comment

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

Cheers

Dave
0
 
LVL 6

Author Comment

by:openshac
ID: 22877916
brettdj

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

Author Comment

by:openshac
ID: 22887102
OK, I think I may have it:

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

 http://msdn.microsoft.com/en-us/library/aa159923(office.11).aspx
0
 
LVL 6

Accepted Solution

by:
openshac earned 0 total points
ID: 22920482
OK, I needed one more thing, which I found at
http://blogs.msdn.com/vsod/archive/2008/04/22/Troubleshooting-com-add-in-load-failures.aspx

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.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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