Upgraded to 1.5.1 and IntelliSense fails to load

54 views
Skip to first unread message

Leigh Tilley

unread,
Mar 31, 2022, 5:50:04 AM3/31/22
to Excel-DNA
Hi

I am seeing problems with trying to create any new functions in my project. So I thought i'd check for newer versions and saw that there's a 1.5.1 for the ExcelDNA packs.

I upgraded them and IntelliSense fails to load when launching Excel and testing the xll.

I tried to roll back one version, to 1.5.0, and Visual Studio got itself really stuck. I managed to remove all of the packages and get back to 1.5.1. It builds but IntelliSense fails:

I appear to be blocked from inserting a photo but essentially i get the error dialog popup warning of IntelliSense failure.

Leigh Tilley

unread,
Mar 31, 2022, 6:02:37 AM3/31/22
to Excel-DNA
Hi

I forgot to copy/paste the error as text:

Initialization [Warning] Assembly EXCELDNA.INTELLISENSE could not be loaded from resources.
Initialization [Error] DnaLibrary AutoOpen Error : TargetInvocationException - Exception has been thrown by the target of an invocation.

Leigh Tilley

unread,
Mar 31, 2022, 6:18:44 AM3/31/22
to Excel-DNA
Previous working setup was:

ExcelDna.Addin 1.0.0
ExcelDna.Integration 1.0.0
ExcelDna.IntelliSense 1.1.0
ExcelDna.Interop 14.0.1

Current problem setup:

ExcelDna.Addin 1.5.1
ExcelDna.Integration 1.5.1
ExcelDna.IntelliSense 1.5.1
ExcelDna.Interop 14.0.1

Leigh Tilley

unread,
Mar 31, 2022, 6:58:04 AM3/31/22
to Excel-DNA
Hi

Resolved by creating a fresh VS project, copy/pasting code into new classes, adding 1.5.1 Nuget packages and building.

Reply all
Reply to author
Forward
0 new messages