Spreadsheet pausing,calculating cells,up2 100%,each input,why?

M

Matticace

Hello there,

Everytime I input data into even the smallest of spreadsheets, the
application pauses, in the bottom left it states that it is calculating
cells, then there is a 3 second pause as a percentage rolls up to 100. This
is slowing my work down alot, please help me to understand what is going on
and how to stop it.

Regards

Matthew C.
 
D

Dave Peterson

You can turn calculation to manual, do your data entry and then turn it back on
(or just recalculate when you want).

You'll see that excel gives you a warning in the statusbar when the workbook
need recalculation.

Tools|Options|Calculation tab is where you'd toggle this setting.
 
Top