Hmmm. I don't know quite what I did, but the recalculation now comes up
Automatic each time. However, that happened before I tried anything with
personal.xls.

I tried renaming personal.xls, and it had the effect that when XL opened
there was no blank sheet.

It still prompts me to save the changes to Book1 if I want, even if I
haven't done anything since opening XL.


"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:427513AD.77029B24@netscapeXSPAM.com...
> The workbook template in XLStart should be named book.xlt (not book1.xlt).
>
> When you recreate this template workbook, make sure you save it with
calculation
> set to automatic.
>
> Do you have a personal.xls workbook in your XLStart folder? If yes, open
that
> and save it (again with calculation set to automatic).
>
> Excel uses the first workbook it opens in that session to determine how
the
> calculation mode should be set for that session.
>
> That might be enough to clear up that #1 problem, too.
>
> Brian wrote:
> >
> > I have used XL97 on Windows 2000 for a long time. Just lately, XL has
> > changed its behaviour, and I can't work out why. There are 2 problems,
but
> > they didn't start at the same time.
> >
> > 1. If I open XL and then immediately close it again, without doing
anything,
> > it asks me do I want to save the changes to Book1? What changes to
Book1?
> >
> > 2. Whenever I start XL, re-calculation is set to manual. This is true
even
> > if I finish the previous session by re-setting the previous spreadsheet
to
> > automatic re-calculation and saving it.
> >
> > I tried saving different versions of Book1.xlt and in the end I deleted
> > Book*.xl?. It made no difference.
> >
> > Any suggestions would be welcome.
>
> --
>
> Dave Peterson