Status Tool Bar and "Calculate"

[krock13]

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?

 

[Gary Brown]

Turn on Automatic Calculation.
From the top menu, select Tools>Options>Calculation>Automatic
--
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]

Thanks Gary, but that didnt work - it was already set to Automatic - I reset
it but still showing 'calculate'

 

[Charles Williams]

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

 

[Gary Brown]

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.