Forum Discussion
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...
I am having the same issue with Dynamic Spill ranges, which seems to happen for me when toggling between automatic and manual calculations and the shift+F9 with dynamic array functions, it freezes you can get out of that then it crashes with a next action, it happens on multiple workbooks but inconsistently as it seems to allow the toggling and shift+F9 for a certain amount of time. I have done repairs on the excel installation, rebuilt workbooks but it still occurs. It started to occur around 2 weeks ago.