Large array, slow calcualtion of formulas
I have a large array and the formulas take about 30 seconds to calculate
everytime I enter any new data. Is there a way to suppress the calculations
until I've entered all my data each time I make changes, so the calculations
are done only once when I'm finished entering new data? Perhaps using on IF
condition in the array formula and satisfying the IF condition by unchecking
a box when I'm ready for the calculations.
|