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..??

Look here:

http://decisionmodels.com/calcsecrets.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rayasiom" <(E-Mail Removed)> wrote in message news1AF7DB1-7DE0-4412-B739-(E-Mail Removed)...
|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..??

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

"Niek Otten" wrote:

> Look here:
>
> http://decisionmodels.com/calcsecrets.htm
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Rayasiom" <(E-Mail Removed)> wrote in message news1AF7DB1-7DE0-4412-B739-(E-Mail Removed)...
> |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..??
>
>
>