Calculate very slow

[Guest]

I have my calculate set to automatic and calculations are getting done
automatically, but at a very slow rate.
The word calculate is constantly on, on the status/task bar at the bottom of
the screen and when you enter a number or delete it, the 'Ready' changes to
'Calculating cells: ??%' and this is when it is now going slow.

Any ideas..??

 

[Niek Otten]

Look here:

http://decisionmodels.com/calcsecrets.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have my calculate set to automatic and calculations are getting done
| automatically, but at a very slow rate.
| The word calculate is constantly on, on the status/task bar at the bottom of
| the screen and when you enter a number or delete it, the 'Ready' changes to
| 'Calculating cells: ??%' and this is when it is now going slow.
|
| Any ideas..??

 

[Guest]

Thank you Niek. That has helped. I see that I have reached my Dependency Tree
Limit as I have all my sheets referencing to one sheet using the SUMIF
formula from row 3 to 65536.

Regards,
Ray