Ribbon/COM Error with other add-ins installed

[Will Martin]

Hi Excel DNA Team,

I am working on a project that I have recently updated to v1.8 and from .Net 4.6.1 to 4.8. I ship this project via a NSIS installer my installing the packed .xll file and adding the appropriate registry keys under HKCU\Software\Microsoft\Office\[vers]\Excel\Options with an Open registry key to the related .xll path.

Since this update some users have experienced a COM/Ribbon error that usually presents as Excel crashing as soon as they try to open a workbook. This issue is not occurring for all users. It seems the issue does not appear when no other add-ins are active, but no single add-in is causing the issue, and it appears with different add-ins installed for different users. When I have been able to replicate the issue I see the Excel crash, and then open Excel in safe mode and open the .xll manually to see the below error. It does not appear that the packed .xll for my add in is being disabled as no add ins are listed in the disabled items dialogue.

ComAddIn [Error] The Ribbon/COM add-in helper required by add-in [add-in name] could not be registered.
This may be due to the helper add-in being disabled by Excel.
To repair, open Disabled items in the Options->Add-Ins page and re-enable target add-in, then restart Excel.
Error details: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
--- End of inner exception stack trace ---
 at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invoke Attr, Object target, Objet[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
 at System.RuntimeType.InvokeMember(Strin name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, Parameter Modifier[] modifiers, CultureInfo culture, String[] named Params)
 at ExcelDna.Integration.ExcelCOmAddInHelper.LoadComAddIn(ExcelComAddIn addIn) : TargetInvocationException - Exception has been thrown by the target of an invocation.

Here are some questions for starters, but any help would be appreciated:

1) Are there issues with having multiple Excel-DNA add-ins that target various Excel-DNA and .Net versions? My users have several Excel-DNA add-ins and I do not have control over most of them.
2) Does a separate add-in need to registered for the COM/ribbon items in a packed .xll?
3) These errors only occurred after updating from v1.0 to v1.8, why are they appearing now?

Thanks,
Will

[Kedar Kulkarni]

Do you have a trusted folder where the addin is installed or do you have a certificate that users could trust? 

If you are able to reproduce consistently, try to set exception settings to all errors and may be you will see the error. 

Usually, while loading addin, keep the code minimal so loading is faster. Also excel has an option to show addin errors at startup, that can provide error info..

Thanks

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/eeea81de-f4d5-4de9-9438-432efa5e5128n%40googlegroups.com.