Calculating cells

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

while working with a worksheet my excel takes nearly 30 - 40 seconds for
calculation and a bar appears at bootom telling calculating cells 5% ,10%
like that .What it is why it is taking so much of time for updating a cell
 
D

Dave Peterson

If you have lots and lots of formulas, then that could be the problem.

If you're doing data entry, maybe turning calculation to manual would be ok.
Toggle it back to automatic when you're done with the data entry.

Tools|Options|calculation tab
is where that setting can be changed.
 
Top