Calculate in bottom left hand corner in Excel 2007

[skikat101]

Recently some of my spreadsheets do not automatically calculate but require
me to hit f9 or click on the word calculate in the bottom left hand quarter.
HOw can I set it back to automaically recalculate?

THanks,

 

[Teethless mama]

Tools > Options > Calculation tab > select Automatic > OK

 

[Dave Peterson]

In xl2007, it's under that Office Button and Excel Options (I think--and then my
memory goes completely bad!)