User Profile
Beastian
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
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 specific machine. This workbook works on multiple other machines but something on that machine is causing this formula to break. 1) Excel version is 2211 (Build 15831.20208 Click-to-run). I have tried an excel repair already on that specific machine. 2) Shift+F9 on the offending worksheet hangs excel with the status bar showing: "calculating (spill resize pass 1)" stuck at 66%. Pressing escape allows me to regain control, but a subsequent Shift+F9 crashes the excel process entirely. 3) The legacy Ctrl+Shift+Enter method of using the formula with a defined output range allows Shift+F9 to work on that worksheet without any issue. 4) Calculating the rest of the page separately without the offending formula, then inputting the offending dynamic range formula also works. 5) Other machines on the identical version of Excel recalculate the sheet instantaneously. 5) I've tried to disable things such as endpoint security services to no avail. Is there anyone who has encountered this behavior before and/or can tell me how to diagnose better the issue?2.6KViews0likes4Comments
Recent Blog Articles
No content to show