View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default 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