Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ready and Calculate in the status bar at the same time

Status
Not open for further replies.

Marita

Technical User
Oct 24, 2003
7
US
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.
.

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top