A few years ago (2023, ExcelDNA version 1.7?), I compiled an Excel add-in written in C# in Visual Studio. No major issues since.
I just edited some of the source code and re-compiled using ExcelDNA version 1.8. Now, whenever I startup Excel (and the add-in is started), I get two diagnostic errors from ExcelDNA that seem to refer to Version=1.1.0.0.
Though the add-in itself seems to be working properly.
Initialization [Error] No objects loaded from ExcelDna.IntelliSense, Version=1.1.0.0, Culture=neutral, PublicKeyToken=f225e9659857edbe
Screenshot of Excel startup error
I can't find any hard-code references to version 1.1. And I even tried to disable the diagnostics via the DNALibrary definition (*.dna), but I'm still getting the error.
<DisableAssemblyLoadDiagnostics>true</DisableAssemblyLoadDiagnostics>
Any thoughts on how to get rid of the errors? Thanks!
The AssemblyVersion that you see as 1.1.0.0 is correct (at least it's 'by design') and has to do with assembly signing where changing the assembly version is somehow bad, so we don't update that number for new versions. The ExcelDna.Integration.dll file you are picking up looks right.
The reason for your error message is probably that you have the ExcelDna.IntelliSense.dll assembly as an 'ExternalLibrary' instead of a 'Reference' in the .dna file. (Or the equivalent project entries if you are using an SDK-style project file without your own .dna file.) When loading, Excel-DNA looks for the 'ExternalLibrary' entries to provide functions of other items to register, and that ExcelDna.IntelliSense is just a referenced assembly, not part of the add-in to export.
The best place for asking Excel-DNA related questions is the Google group at https://groups.google.com/g/exceldna