<Tools <Options <Calculation tab,
And click on "Automatic".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"r van setten" <r van wrote in message
...


"i want to find out how to set Automatic Calculation as the default mode,
rather than having to press f9. it used to be this way in previous
editions
of Excel