Calculation Speed

[Mark]

For a particularly large excel workbook, the recalulation
time is quite long.

Any suggestions to reduce calculation times?

The following are some things I'm thinking about. Please
feel free to comment on their plusses/minuses or add to
the list.

1. Use Manual Recalc
2. Break workbook into smaller workbooks
3. Get more CPU
4. Allocate more CPU to Excel.
5. more?

Thank you.

Mark

 

[David McRitchie]

Hi Mark,
I have a web page on the subject.
Slow Response, Memory Problems, and Speeding up Excel
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Charles Williams has a website on the subject, one of
the pages (his pages are best viewed in Mozilla).
Calculation Secrets
http://www.decisionmodels.com/calcsecrets.htm

 

[Charles Williams]

There are a number of tips on improving calculation speed at
http://www.decisionmodels.com/optspeed.htm and associated pages


--
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm