Calculation Options
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. |
Calculation Options
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. |
Calculation Options
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. |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com