Ready and Calculate in the status bar at the same time

[Marita]

I have some files that are around 8.5 meg, but when I
change 6 of 12 months from range valued to calculation
mode (dsums), I get the ready and calculate at the same
time status. What causes this, and how can I fix it?

Thanks for any help.
.

 

[xlbo]

It means that you have exceeded the number of dependancies that excel can handle at one time. Excel then has to calculate EVERY cell whenever something is changed. Having the calculate message there is what tells you this has happened. You may need to leave it a coupla minutes to calculate through - you'll probably see a blue progress bar filling up in the status bar and then it will go to the normal "calculating %" till it gets to 100

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244