Forum Discussion

Copper Contributor

Dec 16, 2022

Dynamic array formula call with spill range input parameter crashes Excel; legacy array call works

Hi, I have a workbook with a dynamic range formula call referencing a spill range that worked last week but is suddenly causing excel to crash this week when using a full worksheet re-calc on a s...

excel

Formulas and Functions

Johan_Ras

Copper Contributor

Jan 17, 2023

Beastian I have exactly the same issue and I cannot seem to find anyone that could solve this. Did you get an answer yet?

ChrisVW

Copper Contributor

Jan 28, 2023

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.