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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.