Need help saving default/options in XL2002

[MJM Business Resources, Inc.]

Can anyone tell me how to save new (changed) default settings for new Excel
2002 spreadsheets/workbooks?

I have a customer who wants to change a default for new spreadsheets. When
she opens a new book, Tools/Options/Calculation is set to manual by default
and she wants Automatic as a default. How do I make this so?

Thank you!

Mark

 

[Dave Peterson]

The bad news is this setting is picked up from the first workbook opened in that
session. If that customer is lucky enough to always open a workbook with
calculation set for automatic, then woohoo.

But as soon as they open a workbook set for manual, it'll be
Tools|options|Calculation tab time.

 

[Dave Peterson]

It's the first workbook opened that dictates this setting:

But as soon as they open a workbook set for manual _FIRST_, it'll be
Tools|options|Calculation tab time.

 

[MJM Business Resources, Inc.]

Dave,

The default setting to manual recalculation occurs before she opens a
workbook. If she opens Excel and creates a new workbook, manual recalc is
the default. On my office systems, I get auto recalc by default. She gets
manual by default.

Similarly, I rarely use gridlines. Yet I haven't been able to figure out a
way to turn them off by default. Every time I create a new workbook, I have
to turn them off manually, every time.

Is there no way to modify the default new workbook template?

Thanks again,

Mark

 

[Dave Peterson]

Does she have a workbook in her XLStart folder?

I keep my default template for new workbooks (called book.xlt) in that folder.
If I saved that workbook has with calculation set to manual, then I could
reproduce what you describe. (Just open it up and change the calculation mode,
then save it.)

You may want to do the same for every file in that folder--I have sheet.xlt and
personal.xla in my XLStart folder (sheet.xlt is the default for new sheets added
to an existing workbook and personal.xla (or .xls) is where many people store
their commonly used macros/functions.

Here's a link to a previous discussion for the gridlines stuff:
http://groups.google.com/[email protected]

Dave,

The default setting to manual recalculation occurs before she opens a
workbook. If she opens Excel and creates a new workbook, manual recalc is
the default. On my office systems, I get auto recalc by default. She gets
manual by default.

Similarly, I rarely use gridlines. Yet I haven't been able to figure out a
way to turn them off by default. Every time I create a new workbook, I have
to turn them off manually, every time.

Is there no way to modify the default new workbook template?

Thanks again,

Mark