calculating cells

L

Louis

Hi,
My spreadsheet is displaying "calculation cells" in the botom left corner
everytime I enter someting in the sheet.
This seem to have appears all of a sudden and slows down the working of the
sheet significant.
How did it end up there?
How do I remove this again?

Thanks in advance,
 
M

Miguel Zapico

You may have calculation set to manual. You can check it in Tools -> Options
-> Calculation, and set it back to Automatic if that is the case.

Miguel.
 
K

Kevin Vaughn

It sounds like you have "volatile" formulas, probably a significant amount if
it is slowing you down. A simple formula that contains a volatile function
is =now(). Some other possibilities (not an exhaustive list) are indirect,
offset, or a UDF (user defined function) set as volatile.
 
Top