Tools/Options/Calculation/Auto Problem

[Dennis]

Whenever I start a blank spreadsheet or a cvs spreadsheet in Excel2000 the
calculation mode is always manual. I always have to go to
Tools/Options/Calculation and click on the Automatics box.

If I start Excel/2000, it comes up with a blank spreadsheet called book1.xls

I've tried saving the blank book1.xls in the windows/applications
data/microsoft/excel directory as book1.xls with the Automatic box checked. But
after I save the book1.xls in that directory and close Excel, when I start Excel
again it comes up with a blank spreadsheet called book1.xls but the calculation
mode is set to Manual.

Also any csv file that I start comes up with the calculation mode set to manual.

If I save a XLS Excel file with calculation mode set to automatic then that same
Excel xls file always comes up with the calculation mode set to where it was,
namely automatic.

How can I get Excel to start any csv file or a blank page with the calculation
mode set to automatic?

Thanks for any help with this simple problem.

Dennis

 

[Dennis]

Sorry I solved my own problem below. However the solution may be helpful to
others.

If I save the blank spreadsheet book1.xls with the calculation mode box
automatic checked in the directory

C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

then every csv file and blank spreadsheet that I start with Excel has the
calculation/automatic box checked on startup.

My error was not putting the book1.xls file into the \XLSTART subdirectory but
only into the C:\WINDOWS\Application Data\Microsoft\Excel directory.

I don't know how the directory switch problem occurred for I never had this
problem until about 3 months ago.

Dennis