View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default calculating cells

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.
--
Kevin Vaughn


"Louis" wrote:

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,