View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default 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.