ExcelDna
ExcelDna copied to clipboard
Excel-DNA
Crash Excel when using cell of a udf as a calculation
I was having no issues until quite recently with UDF using ExcelAsyncHandle and now whenever I'm in manual calculation mode and use the result cell of a function using it, then press Shift+F9, Excel crash with a 255 error code, no other info
the below code can reproduce it, I've taken it from the samples
using System;
using System.Threading.Tasks;
using ExcelDna.Integration;
public class Test : IExcelAddIn
{
public void AutoOpen()
{
ExcelIntegration.RegisterUnhandledExceptionHandler(ex => "!!!Error " + ex);
}
public void AutoClose()
{
}
// .NET 4.5 only (or using the .NET 4.0 async/await library)
[ExcelFunction(Description = "This function wraps a call to the 'DelayedEcho' task")]
public static async void dnaEchoNewAsync(object valueToEcho, int msToSleep, ExcelAsyncHandle asyncHandle)
{
try
{
object result = await DelayedEcho(valueToEcho, msToSleep);
asyncHandle.SetResult(result);
}
catch (Exception ex)
{
asyncHandle.SetException(ex);
}
}
static async Task<object> DelayedEcho(object valueToEcho, int msToDelay)
{
if (valueToEcho.Equals("Boom!")) throw new Exception("Boom! Boom! Boom!");
await Task.Delay(msToDelay);
return valueToEcho;
}
private static async Task<object> Delayed(int msToDelay)
{
await Task.Delay(msToDelay);
var result = new object[1, 2];
result[0, 0] = 100;
result[0, 1] = 200;
return result;
}
[ExcelFunction()]
public static async void AsyncArray(int msToSleep, ExcelAsyncHandle asyncHandle)
{
try
{
object result = await Delayed(msToSleep);
asyncHandle.SetResult(result);
}
catch (Exception ex)
{
asyncHandle.SetException(ex);
}
}
}
- I enter the udf in 2 cells (
=AsyncArray(5000)) press ctrl + shift + enter and the result appears after 5s - Now in another cell I add 1 to the 100 returned, press enter, 101 appears
- Then I press shift+f9 and excel crash, sometines it doesnt crash right away so repeat from 1 and it's crashing.
Happy to give more info if necessary !
I tried a quick test but can't reproduce a problem in my Excel.
I'm running 32-bit Microsoft 365 on the Beta Channel, and have version 16.0.13219.20004. I am using the current Excel-DNA NuGet package version 1.1.1.
-
What is the exact Excel and Excel-DNA version you are running?
-
Can you have a look at the Windows Application event log to get the error code for the process crash?
-
Did you make changes to the add-in for this problem to occur, or was it just an Excel update that triggered the problem?
I tried a quick test but can't reproduce a problem in my Excel.
I'm running 32-bit Microsoft 365 on the Beta Channel, and have version 16.0.13219.20004. I am using the current Excel-DNA NuGet package version 1.1.1.
- What is the exact Excel and Excel-DNA version you are running?
- Can you have a look at the Windows Application event log to get the error code for the process crash?
- Did you make changes to the add-in for this problem to occur, or was it just an Excel update that triggered the problem?
- 16.0.13029.20342 64Bit . For excelDNA I ran the code above with the latest version so 1.1.1, my addin runs a lower version though, will check asap
- event log, I hope it's that you want ?:
Faulting application name: EXCEL.EXE, version: 16.0.13029.20344, time stamp: 0x5f2a2b40
Faulting module name: EXCEL.EXE, version: 16.0.13029.20344, time stamp: 0x5f2a2b40
Exception code: 0xc0000005
Fault offset: 0x0000000001fc744a
Faulting process id: 0x1100
Faulting application start time: 0x01d685b4e5e4b347
Faulting application path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE
Faulting module path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE
Report Id: 3fae9161-5258-4e96-8ea0-58e596ea337c
Faulting package full name:
Faulting package-relative application ID:
- No the addin is working fine for the past year or so, so it's more likely an excel upgrade issue
Another guy with a slightly different version Excel 2019 MSO 16.0.13029.20342 64-bit has the same crashing issue,
He confirms the addin could use the result of a cell defined by the UDF without crashing, so most likely it's an excel upgrade issue ?
I managed to get a dump using procdump, not sure it's useful, quite big 718Mb ..., can send it if you want.
this is using code above.
summary says:
Dump Summary
------------
Dump File: EXCEL.EXE_200909_003530.dmp : C:\Users\benoi\Downloads\Procdump\EXCEL.EXE_200909_003530.dmp
Last Write Time: 9/9/2020 12:35:41 AM
Process Name: EXCEL.EXE : C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE
Process Architecture: x64
Exception Code: 0xC0000005
Exception Information: The thread tried to read from or write to a virtual address for which it does not have the appropriate access.
Heap Information: Present
System Information
------------------
OS Version: 10.0.19041
CLR Version(s): 4.8.4220.0
Modules
-------
Module Name Module Path Module Version
----------- ----------- --------------
EXCEL.EXE C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE 16.0.13029.20344
ntdll.dll C:\Windows\System32\ntdll.dll 6.2.19041.488
kernel32.dll C:\Windows\System32\kernel32.dll 6.2.19041.292
KERNELBASE.dll C:\Windows\System32\KERNELBASE.dll 6.2.19041.488
apphelp.dll C:\Windows\System32\apphelp.dll 6.2.19041.1
ole32.dll C:\Windows\System32\ole32.dll 6.2.19041.153
ucrtbase.dll C:\Windows\System32\ucrtbase.dll 6.2.19041.488
rpcrt4.dll C:\Windows\System32\rpcrt4.dll 6.2.19041.508
combase.dll C:\Windows\System32\combase.dll 6.2.19041.508
gdi32.dll C:\Windows\System32\gdi32.dll 6.2.19041.1
win32u.dll C:\Windows\System32\win32u.dll 6.2.19041.508
gdi32full.dll C:\Windows\System32\gdi32full.dll 6.2.19041.508
msvcp_win.dll C:\Windows\System32\msvcp_win.dll 6.2.19041.488
user32.dll C:\Windows\System32\user32.dll 6.2.19041.488
AppVIsvSubsystems64.dll C:\Program Files\Microsoft Office\root\Office16\AppVIsvSubsystems64.dll 5.2.160.0
advapi32.dll C:\Windows\System32\advapi32.dll 6.2.19041.1
msvcrt.dll C:\Windows\System32\msvcrt.dll 7.0.19041.1
sechost.dll C:\Windows\System32\sechost.dll 6.2.19041.388
VCRUNTIME140.dll C:\Program Files\Microsoft Office\root\Office16\VCRUNTIME140.dll 14.16.27033.0
msvcp140.dll C:\Program Files\Microsoft Office\root\Office16\msvcp140.dll 14.16.27033.0
shell32.dll C:\Windows\System32\shell32.dll 6.2.19041.488
C2R64.dll C:\Program Files\Microsoft Office\root\Office16\C2R64.dll 16.0.13029.20232
oleaut32.dll C:\Windows\System32\oleaut32.dll 6.2.19041.388
userenv.dll C:\Windows\System32\userenv.dll 6.2.19041.1
imm32.dll C:\Windows\System32\imm32.dll 6.2.19041.1
mso20win32client.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso20win32client.dll 0.0.0.0
IPHLPAPI.DLL C:\Windows\System32\IPHLPAPI.DLL 6.2.19041.488
bcryptPrimitives.dll C:\Windows\System32\bcryptPrimitives.dll 6.2.19041.264
mso30win32client.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso30win32client.dll 0.0.0.0
wevtapi.dll C:\Windows\System32\wevtapi.dll 6.2.19041.1
mso40uiwin32client.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso40uiwin32client.dll 0.0.0.0
GdiPlus.dll C:\Windows\WinSxS\amd64_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.19041.508_none_faefa4f37613d18e\GdiPlus.dll 6.2.19041.508
mso50win32client.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso50win32client.dll 0.0.0.0
mso98win32client.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso98win32client.dll 0.0.0.0
wtsapi32.dll C:\Windows\System32\wtsapi32.dll 6.2.19041.1
mso.dll C:\Program Files\Common Files\Microsoft Shared\Office16\mso.dll 0.0.0.0
version.dll C:\Windows\System32\version.dll 6.2.19041.1
msi.dll C:\Windows\System32\msi.dll 5.0.19041.508
bcrypt.dll C:\Windows\System32\bcrypt.dll 6.2.19041.1
comctl32.dll C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.19041.488_none_ca04af081b815d21\comctl32.dll 6.10.19041.488
d2d1.dll C:\Windows\System32\d2d1.dll 6.2.19041.329
uxtheme.dll C:\Windows\System32\uxtheme.dll 6.2.19041.488
msctf.dll C:\Windows\System32\msctf.dll 6.2.19041.488
winsta.dll C:\Windows\System32\winsta.dll 6.2.19041.1
dxgi.dll C:\Windows\System32\dxgi.dll 6.2.19041.488
kernel.appcore.dll C:\Windows\System32\kernel.appcore.dll 6.2.19041.1
d3d11.dll C:\Windows\System32\d3d11.dll 6.2.19041.1
d3d10warp.dll C:\Windows\System32\d3d10warp.dll 6.2.19041.84
DXCore.dll C:\Windows\System32\DXCore.dll 6.2.19041.1
cfgmgr32.dll C:\Windows\System32\cfgmgr32.dll 6.2.19041.1
SHCore.dll C:\Windows\System32\SHCore.dll 6.2.19041.488
windows.storage.dll C:\Windows\System32\windows.storage.dll 6.2.19041.508
wldp.dll C:\Windows\System32\wldp.dll 6.2.19041.423
shlwapi.dll C:\Windows\System32\shlwapi.dll 6.2.19041.1
profapi.dll C:\Windows\System32\profapi.dll 6.2.19041.488
secur32.dll C:\Windows\System32\secur32.dll 6.2.19041.1
sspicli.dll C:\Windows\System32\sspicli.dll 6.2.19041.488
clbcatq.dll C:\Windows\System32\clbcatq.dll 2001.12.10941.16384
Windows.Security.Authentication.Web.Core.dll C:\Windows\System32\Windows.Security.Authentication.Web.Core.dll 6.2.19041.488
WinTypes.dll C:\Windows\System32\WinTypes.dll 6.2.19041.508
netprofm.dll C:\Windows\System32\netprofm.dll 6.2.19041.423
mscoree.dll C:\Windows\System32\mscoree.dll 6.2.19041.1
mscoreei.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll 4.8.4180.0
DWrite.dll C:\Windows\System32\DWrite.dll 6.2.19041.388
npmproxy.dll C:\Windows\System32\npmproxy.dll 6.2.19041.423
MSOARIA.DLL C:\Program Files\Microsoft Office\root\Office16\MSOARIA.DLL 16.0.13029.20000
webservices.dll C:\Windows\System32\webservices.dll 6.2.19041.1
iertutil.dll C:\Windows\System32\iertutil.dll 11.0.19041.488
RICHED20.DLL C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\RICHED20.DLL 16.0.13029.20076
OneCoreCommonProxyStub.dll C:\Windows\System32\OneCoreCommonProxyStub.dll 6.2.19041.1
vaultcli.dll C:\Windows\System32\vaultcli.dll 6.2.19041.388
CRYPTBASE.DLL C:\Windows\System32\CRYPTBASE.DLL 6.2.19041.1
crypt32.dll C:\Windows\System32\crypt32.dll 6.2.19041.21
Windows.Web.dll C:\Windows\System32\Windows.Web.dll 6.2.19041.264
sppc.dll C:\Windows\System32\sppc.dll 6.2.19041.1
dpapi.dll C:\Windows\System32\dpapi.dll 6.2.19041.1
xmllite.dll C:\Windows\System32\xmllite.dll 6.2.19041.1
wbemprox.dll C:\Windows\System32\wbem\wbemprox.dll 6.2.19041.1
ws2_32.dll C:\Windows\System32\ws2_32.dll 6.2.19041.1
wbemcomn.dll C:\Windows\System32\wbemcomn.dll 6.2.19041.1
dwmapi.dll C:\Windows\System32\dwmapi.dll 6.2.19041.488
powrprof.dll C:\Windows\System32\powrprof.dll 6.2.19041.1
umpdc.dll C:\Windows\System32\umpdc.dll 0.0.0.0
wbemsvc.dll C:\Windows\System32\wbem\wbemsvc.dll 6.2.19041.1
TextShaping.dll C:\Windows\System32\TextShaping.dll 0.0.0.0
fastprox.dll C:\Windows\System32\wbem\fastprox.dll 6.2.19041.1
amsi.dll C:\Windows\System32\amsi.dll 6.2.19041.1
MpOAV.dll C:\ProgramData\Microsoft\Windows Defender\Platform\4.18.2008.9-0\MpOAV.dll 4.18.2008.9
OART.DLL C:\Program Files\Microsoft Office\root\Office16\OART.DLL 16.0.13029.20232
textinputframework.dll C:\Windows\System32\textinputframework.dll 6.2.19041.508
CoreUIComponents.dll C:\Windows\System32\CoreUIComponents.dll 6.2.19041.1
CoreMessaging.dll C:\Windows\System32\CoreMessaging.dll 6.2.19041.423
ntmarta.dll C:\Windows\System32\ntmarta.dll 6.2.19041.1
twinapi.appcore.dll C:\Windows\System32\twinapi.appcore.dll 6.2.19041.488
twinapi.dll C:\Windows\System32\twinapi.dll 6.2.19041.488
nsi.dll C:\Windows\System32\nsi.dll 6.2.19041.1
usermgrcli.dll C:\Windows\System32\usermgrcli.dll 6.2.19041.1
cabinet.dll C:\Windows\System32\cabinet.dll 5.0.1.1
windowscodecs.dll C:\Windows\System32\windowscodecs.dll 6.2.19041.388
propsys.dll C:\Windows\System32\propsys.dll 7.0.19041.488
d3d10_1.dll C:\Windows\System32\d3d10_1.dll 6.2.19041.1
d3d10_1core.dll C:\Windows\System32\d3d10_1core.dll 6.2.19041.1
winhttp.dll C:\Windows\System32\winhttp.dll 6.2.19041.264
dhcpcsvc6.DLL C:\Windows\System32\dhcpcsvc6.DLL 6.2.19041.508
dhcpcsvc.dll C:\Windows\System32\dhcpcsvc.dll 6.2.19041.508
dcomp.dll C:\Windows\System32\dcomp.dll 6.2.19041.488
webio.dll C:\Windows\System32\webio.dll 6.2.19041.1
mswsock.dll C:\Windows\System32\mswsock.dll 6.2.19041.423
winnsi.dll C:\Windows\System32\winnsi.dll 6.2.19041.1
MSOHEV.DLL C:\Program Files\Microsoft Office\root\Office16\MSOHEV.DLL 16.0.13029.20044
dnsapi.dll C:\Windows\System32\dnsapi.dll 6.2.19041.508
normaliz.dll C:\Windows\System32\normaliz.dll 6.2.19041.1
rasadhlp.dll C:\Windows\System32\rasadhlp.dll 6.2.19041.1
FWPUCLNT.DLL C:\Windows\System32\FWPUCLNT.DLL 6.2.19041.488
schannel.dll C:\Windows\System32\schannel.dll 6.2.19041.508
cryptsp.dll C:\Windows\System32\cryptsp.dll 6.2.19041.1
rsaenh.dll C:\Windows\System32\rsaenh.dll 6.2.19041.1
mskeyprotect.dll C:\Windows\System32\mskeyprotect.dll 6.2.19041.1
ntasn1.dll C:\Windows\System32\ntasn1.dll 6.2.19041.1
msasn1.dll C:\Windows\System32\msasn1.dll 6.2.19041.1
cryptnet.dll C:\Windows\System32\cryptnet.dll 6.2.19041.1
msxml6.dll C:\Windows\System32\msxml6.dll 6.30.19041.388
ncrypt.dll C:\Windows\System32\ncrypt.dll 6.2.19041.1
ncryptsslp.dll C:\Windows\System32\ncryptsslp.dll 6.2.19041.1
urlmon.dll C:\Windows\System32\urlmon.dll 11.0.19041.488
wininet.dll C:\Windows\System32\wininet.dll 11.0.19041.508
ondemandconnroutehelper.dll C:\Windows\System32\ondemandconnroutehelper.dll 6.2.19041.1
msimg32.dll C:\Windows\System32\msimg32.dll 6.2.19041.508
usp10.dll C:\Windows\System32\usp10.dll 6.2.19041.1
Windows.Globalization.dll C:\Windows\System32\Windows.Globalization.dll 6.2.19041.388
Bcp47Langs.dll C:\Windows\System32\Bcp47Langs.dll 6.2.19041.84
BCP47mrm.dll C:\Windows\System32\BCP47mrm.dll 6.2.19041.1
globinputhost.dll C:\Windows\System32\globinputhost.dll 6.2.19041.1
directmanipulation.dll C:\Windows\System32\directmanipulation.dll 6.2.19041.84
coml2.dll C:\Windows\System32\coml2.dll 6.2.19041.1
Windows.StateRepositoryPS.dll C:\Windows\System32\Windows.StateRepositoryPS.dll 6.2.19041.508
mpr.dll C:\Windows\System32\mpr.dll 6.2.19041.1
wintrust.dll C:\Windows\System32\wintrust.dll 6.2.19041.423
imagehlp.dll C:\Windows\System32\imagehlp.dll 6.2.19041.1
Windows.Networking.Connectivity.dll C:\Windows\System32\Windows.Networking.Connectivity.dll 6.2.19041.423
Windows.Security.Authentication.OnlineId.dll C:\Windows\System32\Windows.Security.Authentication.OnlineId.dll 6.2.19041.488
OneCoreUAPCommonProxyStub.dll C:\Windows\System32\OneCoreUAPCommonProxyStub.dll 6.2.19041.508
ClassLibrary1-AddIn64.xll C:\Users\benoi\Source\Repos\ClassLibrary1\ClassLibrary1\bin\Debug\ClassLibrary1-AddIn64.xll 1.1.0.3
MSPTLS.DLL C:\Program Files\Common Files\Microsoft Shared\Office16\MSPTLS.DLL 0.0.0.0
clr.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll 4.8.4220.0
VCRUNTIME140_CLR0400.dll C:\Windows\System32\VCRUNTIME140_CLR0400.dll 14.10.25028.0
ucrtbase_clr0400.dll C:\Windows\System32\ucrtbase_clr0400.dll 14.10.25028.0
mscorlib.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\8b0445ce5a447ad49f5d2104153ddbd4\mscorlib.ni.dll 4.8.4220.0
MpClient.dll C:\ProgramData\Microsoft\Windows Defender\Platform\4.18.2008.9-0\MpClient.dll 4.18.2008.9
gpapi.dll C:\Windows\System32\gpapi.dll 6.2.19041.508
clrjit.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll 4.8.4220.0
XLCALL32.DLL C:\Program Files\Microsoft Office\root\Office16\XLCALL32.DLL 16.0.12228.20050
System.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System\692cee7f35bc369df5d159f8c5627c5d\System.ni.dll 4.8.4200.0
System.Core.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Core\c93affb73b44fea7fcb1a88839fbc9af\System.Core.ni.dll 4.8.4220.0
System.Configuration.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Configuration\774075c043860368904f346d5f3ee2df\System.Configuration.ni.dll 4.8.4190.0
System.Xml.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xml\bc239fff46a8f02f99383a032ee436d1\System.Xml.ni.dll 4.8.4084.0
System.Drawing.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Drawing\1c771fd588f41bfd1a3793556b94dc2d\System.Drawing.ni.dll 4.8.4084.0
System.Windows.Forms.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Windows.Forms\c01aadd99fb3f53a9673e2058d489eca\System.Windows.Forms.ni.dll 4.8.4200.0
comctl32.dll C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_5.82.19041.488_none_4238de57f6b64d28\comctl32.dll 5.82.19041.488
appresolver.dll C:\Windows\System32\appresolver.dll 6.2.19041.264
slc.dll C:\Windows\System32\slc.dll 6.2.19041.1
linkinfo.dll C:\Windows\System32\linkinfo.dll 6.2.19041.1
ntshrui.dll C:\Windows\System32\ntshrui.dll 6.2.19041.488
srvcli.dll C:\Windows\System32\srvcli.dll 6.2.19041.1
cscapi.dll C:\Windows\System32\cscapi.dll 6.2.19041.1
netapi32.dll C:\Windows\System32\netapi32.dll 6.2.19041.1
davhlpr.dll C:\Windows\System32\davhlpr.dll 6.2.19041.1
netutils.dll C:\Windows\System32\netutils.dll 6.2.19041.1
policymanager.dll C:\Windows\System32\policymanager.dll 6.2.19041.508
msvcp110_win.dll C:\Windows\System32\msvcp110_win.dll 6.2.19041.1
TaskFlowDataEngine.dll C:\Windows\System32\TaskFlowDataEngine.dll 6.2.19041.488
cdp.dll C:\Windows\System32\cdp.dll 6.2.19041.488
dsreg.dll C:\Windows\System32\dsreg.dll 6.2.19041.1
GFX.DLL C:\Program Files\Microsoft Office\root\Office16\GFX.DLL 16.0.13029.20076
dataexchange.dll C:\Windows\System32\dataexchange.dll 6.2.19041.264
sxs.dll C:\Windows\System32\sxs.dll 6.2.19041.450
UIAutomationCore.DLL C:\Windows\System32\UIAutomationCore.DLL 7.2.19041.488
srpapi.dll C:\Windows\System32\srpapi.dll 6.2.19041.488
msproof7.dll C:\Program Files\Microsoft Office\root\Office16\msproof7.dll 16.0.13029.20050
msspell7.dll C:\Program Files\Microsoft Office\root\Office16\PROOF\msspell7.dll 16.0.13029.20000
MsSpellCheckingFacility.dll C:\Windows\System32\MsSpellCheckingFacility.dll 6.2.19041.329
It looks like you are running a version which has the Dynamic Arrays support. However, you describe the crash as happening when you enter a legacy Ctrl+Shift+Enter array formula, and then a further calcualation.
If you enter the same formula into the single cell, it should spill over into two cells (due to dynamic arrays).
-
Can you check whether there is a difference in these situations? I imagine there has been work in Excel related to these different array functions, and also that the combination of an Excel-native async function like yours, with an array result, could be somewhat of an edge case for Excel.
-
Are you able to reproduce the error on a machine with a debugger? It would be interesting to see the call stack, and it would be easier in Visual Studio than getting the large procdump. Maybe you can just make some screenshots of the call stack from Visual Studio.
In any event, it sounds like it could be an Excel issue to me. If you want to take it further with Microsoft, we would need to make a native code reproduction of the error where there is no Excel-DNA in the loop, and then file a report.
If you enter the same formula into the single cell, it should spill over into two cells (due to dynamic arrays).
No I get a #VALUE
- Are you able to reproduce the error on a machine with a debugger? It would be interesting to see the call stack, and it would be easier in Visual Studio than getting the large procdump. Maybe you can just make some screenshots of the call stack from Visual Studio.
I can rerproduce in Visual Studio yes, but every attempt ended up in having just Excel crash and no report, call stack, it crashes and Excel restart right away. I'm afraid I suck at windows and I dont use it that often, so maybe there is some configuration to make in Visual Studio ?
If you enter the same formula into the single cell, it should spill over into two cells (due to dynamic arrays).
No I get a #VALUE
OK sorry - I wasn't looking carefully and now I see you have Excel 2019, which does not have the Dynamic Arrays feature. I would still not expect an error when entering into a single cell, though I'll have to check that. I will need to try in a VM a bit later.
I suspect this is an Excel issue, but we can dig further to confirm this. If it is a priority for you and you want to arrange for a paid-for support session, you can contact me directly.
excel can not manage effectly cells that it dont know value has changed in background program.
I suspect this is an Excel issue, but we can dig further to confirm this. If it is a priority for you and you want to arrange for a paid-for support session, you can contact me directly.
you got mail !
