Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Status Tool Bar and "Calculate"
I am trying to find out how to remove "Calculate" from showing up in my
status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Status Tool Bar and "Calculate"
Turn on Automatic Calculation.
From the top menu, select ToolsOptionsCalculationAutomatic -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "krock13" wrote: I am trying to find out how to remove "Calculate" from showing up in my status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Status Tool Bar and "Calculate"
Thanks Gary, but that didnt work - it was already set to Automatic - I reset
it but still showing 'calculate' Gary Brown wrote: Turn on Automatic Calculation. From the top menu, select ToolsOptionsCalculationAutomatic I am trying to find out how to remove "Calculate" from showing up in my status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? -- Kristi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Status Tool Bar and "Calculate"
Probably either circular refs with iteration or more than 65536
dependencies: see http://www.decisionmodels.com/calcsecretsf.htm Charles __________________________________________________ The Excel Calculation Site http://www.decisionmodels.com "krock13" <u44699@uwe wrote in message news:86cca5adab7c7@uwe... Thanks Gary, but that didnt work - it was already set to Automatic - I reset it but still showing 'calculate' Gary Brown wrote: Turn on Automatic Calculation. From the top menu, select ToolsOptionsCalculationAutomatic I am trying to find out how to remove "Calculate" from showing up in my status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? -- Kristi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Status Tool Bar and "Calculate"
I've occassionally seen that happen if there are large amounts of formulas
and/or system memory is getting kind of low. The only suggestion I can give you is to press the 'F9' [Calculate] key to see what happens. Good luck. -- Hope this helps. Sincerely, Gary Brown "krock13" wrote: Thanks Gary, but that didnt work - it was already set to Automatic - I reset it but still showing 'calculate' Gary Brown wrote: Turn on Automatic Calculation. From the top menu, select ToolsOptionsCalculationAutomatic I am trying to find out how to remove "Calculate" from showing up in my status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? -- Kristi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
Status Bar Shows "CALCULATE" | Excel Worksheet Functions | |||
"Calculate" on status bar | Excel Discussion (Misc queries) | |||
What does "Calculate" mean in the Status Bar? | Excel Discussion (Misc queries) |