adjusting formula totals with tab or arror keys

I used to be able to see the "newly" adjusted totals on my spreadsheets after
moving to the next line, via the arrow down key or tab key. Now only after
saving are the New totals adjusted on the sheet? Why?

Perhaps the calc mode was inadvertently changed to "Manual / Recalc before
save" ?

Click Tools > Options > Calculation tab
Ensure that "Automatic" box is checked > OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Susan" <[email protected]> wrote in message
news:[email protected]...
> I used to be able to see the "newly" adjusted totals on my spreadsheets
after
> moving to the next line, via the arrow down key or tab key. Now only
after
> saving are the New totals adjusted on the sheet? Why?

I checked that, and Automatic is checked.
--
Susan


"Max" wrote:

> Perhaps the calc mode was inadvertently changed to "Manual / Recalc before
> save" ?
>
> Click Tools > Options > Calculation tab
> Ensure that "Automatic" box is checked > OK
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Susan" <[email protected]> wrote in message
> news:[email protected]...
> > I used to be able to see the "newly" adjusted totals on my spreadsheets
> after
> > moving to the next line, via the arrow down key or tab key. Now only
> after
> > saving are the New totals adjusted on the sheet? Why?
>
>
>

I check, and automatic is check, but there is a greyed out line by manual
that is checked and it says recalucate before save.
--
Susan


"Max" wrote:

> Perhaps the calc mode was inadvertently changed to "Manual / Recalc before
> save" ?
>
> Click Tools > Options > Calculation tab
> Ensure that "Automatic" box is checked > OK
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Susan" <[email protected]> wrote in message
> news:[email protected]...
> > I used to be able to see the "newly" adjusted totals on my spreadsheets
> after
> > moving to the next line, via the arrow down key or tab key. Now only
> after
> > saving are the New totals adjusted on the sheet? Why?
>
>
>

I've gone in and selected Manual so I can uncheck the recalulate before save.
Then selecting automatic. Do I have to do this now everytime I open a
workbook? How can I make this change effect all excel, future and past?



--
Susan


"Susan" wrote:

> I checked that, and Automatic is checked.
> --
> Susan
>
>
> "Max" wrote:
>
> > Perhaps the calc mode was inadvertently changed to "Manual / Recalc before
> > save" ?
> >
> > Click Tools > Options > Calculation tab
> > Ensure that "Automatic" box is checked > OK
> >
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > GMT+8, 1° 22' N 103° 45' E
> > xdemechanik <at>yahoo<dot>com
> > ----
> > "Susan" <[email protected]> wrote in message
> > news:[email protected]...
> > > I used to be able to see the "newly" adjusted totals on my spreadsheets
> > after
> > > moving to the next line, via the arrow down key or tab key. Now only
> > after
> > > saving are the New totals adjusted on the sheet? Why?
> >
> >
> >

"Susan" <[email protected]> wrote
> I've gone in and selected Manual
> so I can uncheck the recalulate before save.
> Then selecting automatic.
> Do I have to do this now everytime I open a workbook?
> How can I make this change effect all excel, future and past?

Try saving a new workbook with the calculation mode set to Automatic
as Book.xlt in XLSTART folder (template file)

Open a new (empty) book
Click Tools > Options > Calculation tab
Ensure "Automatic" is checked > OK

Click File > Save As:
Select under "Save as type:" : Template
Put as "File name:" : Book
Navigate to (for "Save in:"):
C:\Program Files\Microsoft Office\Office\XLStart
Click Save

---

But note that Excel will "set" the calc mode based on the first book which
is opened in any one session (until Excel is exited). So if the first book
opened happens to be one saved earlier with manual calc (E.g.: you might be
double-clicking to open an existing xls file in windows explorer), it's
going to throw the session's operating mode into manual. Just do a quick
check on the mode via Tools > Options > Calc tab.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----