Excel 2000 - Calculate on Status Bar

  • Thread starter Erlinda Natividad
  • Start date
E

Erlinda Natividad

Everytime I enter a character on a cell, why does it keep
showing "Calculating" on the Status Bar of my
spreadsheet? What can I do so it will stop doing this?
It makes updating my cells very slow.
 
B

Bob Phillips

It means that you have lots of formulae that are re-calculating each time.

You can switch to manual calculation mode (menu Tools>Options Calculation
tab, and set the Manual button), and set back to automatic when all done. I
have toolbar buttons to toggle them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top