Options Won't Stick
 

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?

Options Won't Stick
 

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.

EarlePearce wrote:

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?

--

Dave Peterson

Options Won't Stick
 

Save both customized Book.xlt and Sheet.xlt as Templates under FileSave AsSave
as Type.......Template(*.xlt)?

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

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

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

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

InsertWorksheet will give you your customized worksheet.


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 13:40:02 -0700, EarlePearce
wrote:

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?

Options Won't Stick
 

Should read......

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


Gord

On Thu, 06 Sep 2007 15:20:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

Options Won't Stick
 

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


"Dave Peterson" wrote:

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.

EarlePearce wrote:

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?

--

Dave Peterson