MissingMethodException on 1.9.0-rc1
Rhi
Previously, the add-in functioned without problems.
However, post-update, I'm consistently seeing an error when running it on 32-bit versions of Excel, ranging from Excel 2010 through to Microsoft 365. The add-in appears to work correctly on 64-bit versions.
> Runtime [Error] Unhandled exception in async delegate call :
MissingMethodException ... 'System Object ExcelDna.Integration.ExcelDnaUtil.get_Application()
Govert van Drimmelen
In earlier prerelease versions of v1.9.0 (e.g. 1.9.0-beta2), we changed the return type of the helper property
ExcelDnaUtil.Application
To be the COM Application type from the interop assembly.
We did this because:
- It is convenient, because this is what the ExcelDnaUtil.Application is always returning, so it avoids requiring an extra cast
- It is possible now that we are targeting .NET 4.x+ and no longer .NET 2.x, we can use the embedded COM types
For 1.9.0-rc1 we have reverted this change and gone back to typing the return as ‘object’.
We reverted because:
- Tthe change we made means that in some cases an additional package reference or referenced assembly would be needed to use the ExcelDnaUtil.Application, so the change breaks compilation in some cases
- For use from VB.NET or assigning to a ‘dynamic’ variable in C#, code that worked before through late-binding would now fail to compile
- We decided that continuing to require the extra cast is preferable to breaking code that built before
The fix for projects going from 1.9.0-beta2 to 1.9.0-rc1 should be to just cast the result of ExcelDna.Application to the right interop type.
using Microsoft.Office.Interop.Excel;
…
Application app = (Application)ExcelDnaUtil.Application;
I hope this is what is causing your problem, though the error and the fact that you only see this under 32-bit Excel does not make sense completely.
Could you perhaps check this, and be sure to rebuild everything against the newer version?
I have not yet checked against a 32-bit version of Excel, so it is possible that there is another problem.
-Govert
--
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/3a3ec304-f5af-44a6-90b9-f4de5915c190n%40googlegroups.com.
이성제
You received this message because you are subscribed to a topic in the Google Groups "Excel-DNA" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/exceldna/u7Ki2w9SZDw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to exceldna+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/00bf01dbe9d8%24cee7b120%246cb71360%24%40gmail.com.
Govert van Drimmelen
I don’t understand your question.
The ExcelDna.IntelliSense package v1.9.0-rc1 has also been published.
<PackageReference Include="ExcelDna.IntelliSense" Version="1.9.0-rc1" />
NuGet Gallery | ExcelDna.IntelliSense 1.9.0-rc1
-Govert
To view this discussion visit https://groups.google.com/d/msgid/exceldna/CAKuxcmrFqCmqxUy1YcWD73MicaaJTW7Pov5PGp7GnrojAO83HA%40mail.gmail.com.
이성제
Previously Working Configuration
The following package versions were previously in use and functioned without any issues:
<PackageReference Include="ExcelDna.Integration" Version="1.9.0-beta2" />
<PackageReference Include="ExcelDna.Interop" Version="15.0.1" />
<PackageReference Include="ExcelDna.Addin" Version="1.9.0-beta2" />
<PackageReference Include="ExcelDna.IntelliSense" Version="1.9.0-beta2" />
<PackageReference Include="ExcelDna.Registration" Version="1.9.0-beta2" />
<PackageReference Include="ExcelDna.Registration.VisualBasic" Version="1.9.0-beta2" />
<PackageReference Include="ExcelDna.XmlSchemas" Version="1.0.0" />
Problematic Configuration
The issue arises with the following updated package versions. While 64-bit environments are unaffected, we are experiencing errors in 32-bit Excel:
<PackageReference Include="ExcelDna.Integration" Version="1.9.0-rc1" />
<PackageReference Include="ExcelDna.Interop" Version="15.0.1" />
<PackageReference Include="ExcelDna.Addin" Version="1.9.0-rc1" />
<PackageReference Include="ExcelDna.IntelliSense" Version="1.9.0-rc1" />
<PackageReference Include="ExcelDna.Registration" Version="1.9.0-rc1" />
<PackageReference Include="ExcelDna.Registration.VisualBasic" Version="1.9.0-rc1" />
<PackageReference Include="ExcelDna.XmlSchemas" Version="1.0.0" />
Error Details
When the add-in attempts to load in 32-bit Excel, the error occurs.
We have personally verified this on Excel 2016 32-bit on Windows 11 and Excel 2010 32-bit on Windows 10.
Additionally, other users have reported the same issue with Microsoft 365 Excel 32-bit on an unspecified operating system.
An error when attempting to access the inline help for UDFs.
The following error occurs upon clicking:
The error message is as follows:
System.MissingMethodException: Method not found: 'System.Object ExcelDna.Integration.ExcelDnaUtil.get_Application()'.
************** 예외 텍스트 **************
System.MissingMethodException: 메서드를 찾을 수 없습니다. 'System.Object ExcelDna.Integration.ExcelDnaUtil.get_Application()'위치: ExcelDna.IntelliSense.ToolTipForm.LaunchLink(String address)
위치: ExcelDna.IntelliSense.ToolTipForm.MouseButtonUp(Point screenLocation)
위치: ExcelDna.IntelliSense.ToolTipForm.WndProc(Message& m)
위치: System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
위치: System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
위치: System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** 로드된 어셈블리 **************
mscorlib
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
ExcelDna.ManagedHost
어셈블리 버전: 1.1.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
System
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
ExcelDna.Loader
어셈블리 버전: 1.1.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
ExcelDna.Integration
어셈블리 버전: 1.1.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
System.Core
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9297.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Configuration
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Windows.Forms
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9256.0 built by: NET481REL1LAST_B
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Accessibility
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
EGToolsVB
어셈블리 버전: 1.8.127.210
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
Microsoft.VisualBasic
어셈블리 버전: 10.0.0.0
Win32 버전: 14.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Numerics
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
ExcelDna.IntelliSense
어셈블리 버전: 1.1.0.0
Win32 버전: 4.8.9310.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
WindowsBase
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9297.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
System.Net.Http
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
----------------------------------------
Snippets
어셈블리 버전: 0.0.0.0
Win32 버전: 4.8.9297.0 built by: NET481REL1LAST_C
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms.resources
어셈블리 버전: 4.0.0.0
Win32 버전: 4.8.9032.0 built by: NET481REL1
코드베이스: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_ko_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
To view this discussion visit https://groups.google.com/d/msgid/exceldna/00f701dbea04%2458b8b3b0%240a2a1b10%24%40gmail.com.
Govert van Drimmelen
I installed with NuGet packages and built targeting .NET Framework 4.8.I checked each package while upgrading them from beta2 to rc1, and encountered an issue with ExcelDna.IntelliSense.Currently, only this package is applied as beta2.What else should I look into?
2025년 7월 1일 화요일 오전 1시 5분 48초 UTC+9에 Govert van Drimmelen님이 작성:
Govert van Drimmelen
It might take a few minutes for NuGet to propagate these.
Thank you for reporting the problem.
If you still have this problem or any others with the new update, please let me know.
Regards,
이성제
You received this message because you are subscribed to a topic in the Google Groups "Excel-DNA" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/exceldna/u7Ki2w9SZDw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to exceldna+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/b9e55949-3795-4ee5-bf77-6fb6320a58cen%40googlegroups.com.
SJ Rhi
Hi, Govert
It appears that ExcelDna.IntelliSense is at v1.9.0-rc3 on NuGet,
but I'm assuming the GitHub source still shows v1.9.0-rc1.
Could you please confirm if the latest source has been reflected?
Govert van Drimmelen
The latest source matching the NuGet package is on GitHub, just the package reference versions in Source\Directory.Build.targets get updated when I build and publish.
-Govert
From: exce...@googlegroups.com <exce...@googlegroups.com> On Behalf Of SJ Rhi
Sent: 30 July 2025 09:54
To: Excel-DNA <exce...@googlegroups.com>
Subject: Re: [ExcelDna] MissingMethodException on 1.9.0-rc1
Hi, Govert
To view this discussion visit https://groups.google.com/d/msgid/exceldna/27bafd13-c6aa-4b1d-a870-5a884c991477n%40googlegroups.com.
SJ Rhi
After downloading and building the GitHub source, then replacing the DLLs in the NuGet package and building my Add-in,
the error I previously reported occurs.
Runtime [Error] Unhandled exception in async delegate call. : MissingMethodException -
'Microsoft.Office.Interop.Excel.Application ExcelDna.Integration.ExcelDnaUtil.get_Application()'
This is the same error I reported when it was rc1, which led me to suspect that the source might still be rc1.
Please let me know if I'm doing anything wrong.
I just want to fix the incorrectly specifying the location when applying structured references to table ranges.
Govert van Drimmelen
You must reference the current version of ExcelDna.Integration / ExcelDna.Addin (v1.9.0-rc3) when rebuilding IntelliSense.
The fix for the get_Application error was to revert a change in ExcelDna.Integration.
-Govert
From: exce...@googlegroups.com <exce...@googlegroups.com> On Behalf Of SJ Rhi
Sent: 30 July 2025 11:22
To: Excel-DNA <exce...@googlegroups.com>
Subject: Re: [ExcelDna] MissingMethodException on 1.9.0-rc1
Hi, Govert,
After downloading and building the GitHub source, then replacing the DLLs in the NuGet package and building my Add-in,
the error I previously reported occurs.
Runtime [Error] Unhandled exception in async delegate call. : MissingMethodException -
'Microsoft.Office.Interop.Excel.Application ExcelDna.Integration.ExcelDnaUtil.get_Application()'
This is the same error I reported when it was rc1, which led me to suspect that the source might still be rc1.
Please let me know if I'm doing anything wrong.
I just want to fix the incorrectly specifying the location when applying structured references to table ranges.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/411e0465-8d23-4a11-a843-d268633e61e0n%40googlegroups.com.