I've been developing excel add-in using microsoft interop and with the shared- addin template but i face the following problem

When I go to build ProjectNameSetup, it packages the dependencies into a Windows Installer package. I then send the contents generated in Release\ProjectNameSetup to one of my colleagues to beta test. He runs the installer and it says the install was successful. However, when excel app loads, there is no menu added to the main menu. I then go into the COM Addins manager and navigate to the installation directory to add the application .DLL. However, when I attempt to add the .DLL, there is an error occurs:

I checked the Registry to make sure the LoadBehavior, Description, and FriendlyName keys were where they were supposed to be, and they were. I checked the assembly to make sure everything that the application needed was in there, and they were.

I am stumped at this point and would appreciate any assistance the community can offer.

Re: Visual Studio Tools for Office Problem deploying Shared COM-AddIn application


I can't help you with your problem - but I can suggest an alternative that I have used successfully.

Instead of creating a shared Excel add-in, use VSTO (not SE) to create a document-level add-in. Then open the customized Excel workbook and Save it as an XLA file.

This has two main advantages over the shared add-in:

1. Much easier deployment. You just need to give full trust to the XLA file and its supporting assemblies. No registry updates are needed - so that e.g. deployment can be as easy as copying files to a (trusted) network share.

2. The XLA add-in can be loaded on demand (e.g. by a VBA macro in a second "loader" XLA file), which means the overhead of loading the .NET Framework and the VSTO customisation is only incurred when it's actually used.

Re: Visual Studio Tools for Office Problem deploying Shared COM-AddIn application

Dennis Wallentin


The add-in may have been 'blacklisted' by Excel (due to some error in loading procedure either with the present version or with an earlier version). Check it out via the command Help | About Microsoft Excel | Disabled Items...