i have tried this,but each time i open excel fo rthe first time, i have to
reset the calculation to Automatic. Excel does not seem to 'remember' my
instructions.

R van Setten
"Ragdyer" wrote:

<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