calculation speed

[Harvey Waxman]

Is there an accepted procedure to find the choke points that might slow
down a calculation especially after a sort. The sheet has 10,000 rows
and lots of array formulas.

Just wondering what is 'normal'

Thanks


Excel OSX. New iMac, Leopard up to date, 2.4 GHz Core 2 Duo, 2 GB ram.

 

[Mike Middleton]

Harvey Waxman -

For Windows Excel, the ultimate guru for calculation is Charles Williams.

His web site is

http://www.decisionmodels.com/

He has sections for "Optimising Speed" and for "Calculation Secrets."

It's like that much of the content also applies to Mac Excel.

- Mike Middleton
http://www.MikeMiddleton.com

 

[Harvey Waxman]

His results are astounding. After looking at the changes he goes
through, I'll wait 90 seconds for the calculation. Thanks