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,

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,

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