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

Teethless mama wrote:

Tools Options Calculation tab select Automatic OK

"skikat101" wrote:

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,

--

Dave Peterson