Forum Discussion
adidriksen
Feb 14, 2024Copper Contributor
Excel freezes and crashes when editing formula
Hello all, Excel keeps crashing when I'm in the depicted situation: I've clicked on a formula and I am trying to edit it. It will typically be a complex formula. It often crashes right as I'm cli...
JKPieterse
Feb 15, 2024Silver Contributor
I haven't seen this cause crashes before. Perhaps you should convert your source range of this formula to a table, then there is no need to have the SUMIFS point to entire columns.