| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS | Excel Discussion (Misc queries) | |||
| Super slow table array formulas | Excel Worksheet Functions | |||
| large function in non-continguous array? | Excel Discussion (Misc queries) | |||
| AutoFilter Best Practice when used in large files (slow system dow | Excel Discussion (Misc queries) | |||
| Simple worksheet becomes large and slow | Excel Discussion (Misc queries) | |||
Threaded Mode
