Hi,
My spreadsheet is displaying quot;calculation cellsquot; 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,
You may have calculation set to manual. You can check it in Tools -gt; Options
-gt; Calculation, and set it back to Automatic if that is the case.
Miguel.
quot;Louisquot; wrote:
gt; Hi,
gt; My spreadsheet is displaying quot;calculation cellsquot; in the botom left corner
gt; everytime I enter someting in the sheet.
gt; This seem to have appears all of a sudden and slows down the working of the
gt; sheet significant.
gt; How did it end up there?
gt; How do I remove this again?
gt;
gt; Thanks in advance,
It sounds like you have quot;volatilequot; 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 Vaughnquot;Louisquot; wrote:
gt; Hi,
gt; My spreadsheet is displaying quot;calculation cellsquot; in the botom left corner
gt; everytime I enter someting in the sheet.
gt; This seem to have appears all of a sudden and slows down the working of the
gt; sheet significant.
gt; How did it end up there?
gt; How do I remove this again?
gt;
gt; Thanks in advance,
- Sep 29 Fri 2006 20:09
calculating cells
close
全站熱搜
留言列表
發表留言