View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams
 
Posts: n/a
Default Why does "Calculate" appear?

There are 4 known conditions for Calculate in the statusbar: see

http://www.decisionmodels.com/calcsecretsf.htm

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"will" wrote in message
...
Hi,

I have a large (3Mb) spreadsheet with lots of external links.

Calculation is switched to Automatic within Options, yet "Calculate" still
appears at the bottom of the screen. Is this because there are too many
links
or its taking too long to update? The "Calculate" does not disappear after
time, which rather knocks that latter idea on the head!

Any ideas? Anything I should be worried about (eg circular reference)?

Thanks,

Will