Options Won't Stick

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EarlePearce - 06 Sep 2007 21:40 GMT

Most application save settings to be used in future documents. I cannot get
Excel 2003 to do likewise. I want all future books and sheets to open
without gridlines and to contain my macros. I have saved Book.xlt &
Sheet.xlt in either and both a)Docuiments & settings, user, .... XLStart and
b) Programs Files, office, XLStart. Nothing seems to work as a default.

I need to create a new blank workbook and have it the way I want, and same
for inserting new sheets.

Odd, though, the setting for the number of sheets in new blank workbooks and
the number of recently opened files to display do stick. So what about the
rest of the settings?

Reply to this Message

Dave Peterson - 06 Sep 2007 23:14 GMT

I'd use windows start button|search to look for all the book.xlt and sheet.xlt
files.

Maybe you have multiple versions and excel isn't using the one you want.

> Most application save settings to be used in future documents. I cannot get
> Excel 2003 to do likewise. I want all future books and sheets to open
[quoted text clipped - 8 lines]
> the number of recently opened files to display do stick. So what about the
> rest of the settings?

Signature

Dave Peterson

Reply to this Message

EarlePearce - 07 Sep 2007 01:44 GMT

The issue is fixed - finally. I had read book.xlt, sheet.xlt and
personal.xls should be hidden, so I marked them hidden. It finally dawned on
my that Excel probably won't even see them so I made them visible.

Now personal.xls loads but isn't seen and my formatting and macros are good.

Thanks for your help.

Earle

> I'd use windows start button|search to look for all the book.xlt and sheet.xlt
> files.
[quoted text clipped - 13 lines]
> > the number of recently opened files to display do stick. So what about the
> > rest of the settings?

Reply to this Message

Gord Dibben - 06 Sep 2007 23:20 GMT

Save both customized Book.xlt and Sheet.xlt as Templates under File>Save As>Save
as Type.......Template(*.xlt)?

Save to C:\Documents and Settings\username\Application Data\Microsoft\Excel

One thing to note............

File>New...Blank workbook will give you the default Excel workbook which you
cannot change so no way of "fixing" that.

File>New(no ellipsis) or clicking the the New File Icon or CTRL + n will give
you your customized workbook.

Insert>Worksheet will give you your customized worksheet.

Gord Dibben MS Excel MVP

>Most application save settings to be used in future documents. I cannot get
>Excel 2003 to do likewise. I want all future books and sheets to open
[quoted text clipped - 8 lines]
>the number of recently opened files to display do stick. So what about the
>rest of the settings?

Reply to this Message

Gord Dibben - 07 Sep 2007 00:26 GMT

Should read......

Save to C:\Documents and Settings\username\Application
Data\Microsoft\Excel\XLSTART folder.

Gord

>Save to C:\Documents and Settings\username\Application Data\Microsoft\Excel

Reply to this Message