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.

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



--
Regards,

Peo Sjoblom



"St@cy" wrote in message
...
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.

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

"St@cy" wrote in message ...
|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.