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.

Large array, slow calcualtion of formulas
 

The control is in the book's calc mode. You can set the calc mode to
"Manual", via ToolsOptionsCalculations tab. Then press F9 only whenever
re-calc is required (after you complete each batch of data entry, etc).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Gary" wrote:
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.

Large array, slow calcualtion of formulas
 

Thanks Max!! Just goes to show us that Excel is an amazing tool with lots of
flexibility that takes time to learn! I'm glad we have this resource to ask
questions and share knowledge!

"Max" wrote:

The control is in the book's calc mode. You can set the calc mode to
"Manual", via ToolsOptionsCalculations tab. Then press F9 only whenever
re-calc is required (after you complete each batch of data entry, etc).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Gary" wrote:
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.

Large array, slow calcualtion of formulas
 

Welcome, Gary. And soon enough, you may find it irresistable to join in
responding to queries. Do plough-in!
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Gary" wrote in message
...
Thanks Max!! Just goes to show us that Excel is an amazing tool with lots
of
flexibility that takes time to learn! I'm glad we have this resource to
ask
questions and share knowledge!