Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating cells
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating cells
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. "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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Calculating the average of cells | New Users to Excel | |||
Calculating cells | Excel Discussion (Misc queries) | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |