I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.

When I create a new workbook, the new style is not avaialble as I expected

How did you create the new workbook?

Did you click the New icon on the standard toolbar?

Are you sure that this was the correct XLStart location?

I'd use windows search to find them all (could be a few, depending on how you
upgraded). Then clean up all but the "real" one. (Move the files to the
correct location or delete them if they're not needed.)

And I'd let excel tell me the "real" one.

Open excel
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath

For me (winXP Home) and xl2003, I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

GKW in GA wrote:

I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.

When I create a new workbook, the new style is not avaialble as I expected

--

Dave Peterson

If you clicked on FileNew...Blank workbook, you will get the Excel default
workbook.

FileNew or click on New File Icon

See Dave's post about location of default XLSTART folder.

Mine is located at

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

Gord would be your username.


Gord Dibben MS Excel MVP

On Fri, 28 Mar 2008 10:22:00 -0700, GKW in GA
wrote:

I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.

When I create a new workbook, the new style is not avaialble as I expected

That worked. I was using the wrong path, the one mentioned in the Microsoft
Help.

I presume macros should be stored there too.

Thanks
"Dave Peterson" wrote:

How did you create the new workbook?

Did you click the New icon on the standard toolbar?

Are you sure that this was the correct XLStart location?

I'd use windows search to find them all (could be a few, depending on how you
upgraded). Then clean up all but the "real" one. (Move the files to the
correct location or delete them if they're not needed.)

And I'd let excel tell me the "real" one.

Open excel
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath

For me (winXP Home) and xl2003, I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

GKW in GA wrote:

I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.

When I create a new workbook, the new style is not avaialble as I expected

--

Dave Peterson

Maybe some of them.

I put my personal.xl* file there along with my book.xlt and sheet.xlt (for
adding new sheets to existing workbooks).

But I don't put any other files there. I'll load them when I need them if
they're .xls (and some .xla) files.

Or I'll use tools|addins for the .xla files that I need.

But if you have multiple .xls files that need to be opened every time you open
excel, then that seems like a reasonable approach.



GKW in GA wrote:

That worked. I was using the wrong path, the one mentioned in the Microsoft
Help.

I presume macros should be stored there too.

Thanks
"Dave Peterson" wrote:

How did you create the new workbook?

Did you click the New icon on the standard toolbar?

Are you sure that this was the correct XLStart location?

I'd use windows search to find them all (could be a few, depending on how you
upgraded). Then clean up all but the "real" one. (Move the files to the
correct location or delete them if they're not needed.)

And I'd let excel tell me the "real" one.

Open excel
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath

For me (winXP Home) and xl2003, I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

GKW in GA wrote:

I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.

When I create a new workbook, the new style is not avaialble as I expected

--

Dave Peterson


--

Dave Peterson