Excel 2003 Calculate in the Status Bar 1

[herkiefan]

The word "Calculate" has appeared in the status bar in one of my workbooks. I know this usually means that the sheet is set to calculate manually.

I have gone to Tools > Options > Calculation and the following toggle switches are on:

* Automatic
* Update remote references
* Save external link values
* Accept labels in formulas


When I hit F9 or Shift+F9 nothing appears to recalculate and "Calculate" stays in the status bar.

Is there something else I should check?

Thanks,
Mike


“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

 

[GlennUK]

It could be caused by the number of dependencies in your sheet. See here:

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

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[AnotherHiggins]

See

http://support.microsoft.com/default.aspx?scid=243495

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[herkiefan]

Thanks guys.

It was a circular reference. It's funny though...I never change my calculation to do Iterations...someone's been messin >:{

“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein