Referring to http://www.decisionmodels.com/calcsecrets.htm,
"Excel's smart recalculation engine normally minimises calculation time by
tracking changes and only recalculating
Cells, formulae, values or names that have changed or are flagged as needing
recalculation.
Cells dependent on other cells, formulae, names or values that need
recalculation."
Does anyone have any suggestions on which version of Excel have smart
recalculation engine? and how to run it rather than using Full calculation?
Thanks in advance for any suggestions
Eric

Hi Eric

As Charles says on his page,
Excel has a complex and finely tuned algorithm for choosing the fastest
sequence and the minimum number of cells required to calculate the correct
answer.
This algorithm was changed significantly when the calculation engine was
rewritten in Excel 97, and further changes have been made in Excel 2002.

It is not a question of selecting it and using it.
It is in use all of the time, with cells being flagged as to whether they
need to be re-calculated or not, whenever a calculation is made.

--

Regards
Roger Govier

"Eric" wrote in message
...
Referring to http://www.decisionmodels.com/calcsecrets.htm,
"Excel's smart recalculation engine normally minimises calculation time by
tracking changes and only recalculating
Cells, formulae, values or names that have changed or are flagged as
needing
recalculation.
Cells dependent on other cells, formulae, names or values that need
recalculation."
Does anyone have any suggestions on which version of Excel have smart
recalculation engine? and how to run it rather than using Full
calculation?
Thanks in advance for any suggestions
Eric