Calculation Options

[St@cy]

I have a pretty elaborate workbook that seems to be calculating all the time,
even when new data is not being entered. It's starting to slow things down.
Please explain the calculation options and give me some suggestions.

Thanks.

 

[Peo Sjoblom]

If you use volatile functions like offset, indirect etc they will make the
workbook calculate

http://www.decisionmodels.com/calcsecretsi.htm


if possible it's better to use multiple simple formulas compared to
complicated array formulas with volatile function

 

[Niek Otten]

Lots of info about calculation (options) in Excel can be found on Charles Williams' site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a pretty elaborate workbook that seems to be calculating all the time,
| even when new data is not being entered. It's starting to slow things down.
| Please explain the calculation options and give me some suggestions.
|
| Thanks.