Forum Discussion
Dynamic array formula call with spill range input parameter crashes Excel; legacy array call works
Johan_RasI am having the same problem and I also don't see any response from Microsoft. This started happening in late December 2022 in all my spreadsheet applications that have dynamic arrays. The ActiveSheet.Calculate command will no longer execute and Excel crashes.
I have the exact same problem you are describing - as of now, nothing has worked and it's driving me crazy.
It does not seem there is much on this topic either (https://www.mrexcel.com/board/threads/calculations-hang-up-freeze-issue-spill-resize.1139035/) and it does not seem to correlate with the number of calculations or arrays in a single sheet, sometimes I see this with quite basic formulas with just 100s of rows.
EDIT: one thing I noticed is that CHOOSECOLS is particularly prone to generating this kind of problem (maybe it's only me). Removing this formula with some workarounds has removed this issue from one of the sheets. I also noticed that the issue arose when there were some names that were either referring to another file or to a sheet that was not present on the file.