Large array, slow calcualtion of formulas

G

Gary

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.
 
M

Max

The control is in the book's calc mode. You can set the calc mode to
"Manual", via Tools>Options>Calculations 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
 
G

Gary

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue Adding an Array Formula to a cell at Runtime. 4
Inserting rows slow on large report 6
array formulas 0
Excel 2007 extremely slow to delete cells 1
Error with stdev array - getting wrong answer 4
Array counting 3
Counting Cells by colour with an array formula 1
Array formulas slows spreadsheet 6

Top