RE: Recalculation

"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

<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 [email protected]> wrote in message
news:[email protected]...
>
>
> "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

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 [email protected]> wrote in message
> news:[email protected]...
> >
> >
> > "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
>
>

See if this old thread can shed some light on the subject:

http://tinyurl.com/anahg


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"r van setten" <r van [email protected]> wrote in message
news:[email protected]...
>
> 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 [email protected]> wrote in message
> > news:[email protected]...
> > >
> > >
> > > "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
> >
> >