Excel crashes about compfinance HOT 3 OPEN

Same here installed both the x86 and x64 vcredist (updated from Microsoft), I think it's compiled for x64 only so need to load up the project in VS2017 and recompile for x86 to match Excel (my guess anyhow). Haven't tried yet but yeah always crashes 32bit Excel

from compfinance.

Actually just recompile the whole project in Visual Studio 2017 (you have to git reset --hard 10ba0b6e81ed53d4c97de67fac60ec3f853cfca7 to get the proper 2017 project). If you're using VS 2019 just recompile as is. You will probably need to retarget for the SDK installed on your PC (under Project, Retarget Solution, pick a Windows SDK on the dropdown (it should list those on your PC already) . Seems both the x64 and x86 plug-ins work on my 32 bit Excel, not sure why, but they do. Some functions don't appear to work, but many of them do (I just compiled the project without changing anything except the x1Comp Property Pages / C/C++ / Language: C++ Language Standard: ISO C++7 Standard) and it works. I was using the x1Test.xlsx after adding the plug-in in the Excel Options menu.

from compfinance.

I had the excel crash as well with Release / 32 bits.
Upon investigation, it seems that what solves my problem is to change the "Enable Enchanced Instruction Set" (in the project settings under C/C++ -> Code Generation) from Advanced Vector Extensions 512 (/arch:AVX512) to Advanced Vector Extensions 2 (/arch:AVX2)

from compfinance.