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?

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?

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

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

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