Excel picks up setting from the first workbook that you open in that
session--including personal.xls.
So open excel
Unhide personal.xls (if you have to)
(window|Unhide in xl2003)
change that setting
Hide personal.xls (if you want)
Close excel
Answer Yes to the "do you wanna save personal.xls" prompt.
(Or you'll be doing it again!)
Leo Rod wrote:
>
> when I close and reopen the application still stuck on manual.
>
> "andycat" <(E-Mail Removed)> wrote in message
> news:_(E-Mail Removed)...
> > Tools | Options | Calculations | Automatic doesn't work?
> >
> > ------------
> >
> > "Leo Rod" <leo@rod_com> wrote in message
> > news:eMg6XY%(E-Mail Removed)...
> >> Yes, I switched it to manual and I can't find a way to set it on auto by
> >> default always.
> >>
> >> "Bernard Liengme" <(E-Mail Removed)> wrote in message
> >> news:ujeUmN%(E-Mail Removed)...
> >>> And reset it to Auto when the file is closed?
> >>> --
> >>> Bernard V Liengme
> >>> Microsoft Excel MVP
> >>> www.stfx.ca/people/bliengme
> >>> remove caps from email
> >>>
> >>> "Leo Rod" <leo@rod_com> wrote in message
> >>> news:uFAbJH%(E-Mail Removed)...
> >>>> would somebody please tell me how to change the defaut calculation
> >>>> setting inside options to automatic from manual?
> >>>>
> >>>> I can't have this change be permanent, I would like that everytime I
> >>>> open a workbook the setting is defaulted to calculate= automatic.
> >>>>
> >>>> Please, HELP!!!
> >>>>
> >>>> Leo.
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
--
Dave Peterson
Similar Threads
