Startup Template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GKW in GA - 28 Mar 2008 18:22 GMT

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

Reply to this Message

Dave Peterson - 28 Mar 2008 18:51 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message

GKW in GA - 28 Mar 2008 22:32 GMT

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

I presume macros should be stored there too.

Thanks

> How did you create the new workbook?
>
[quoted text clipped - 23 lines]
> >
> > When I create a new workbook, the new style is not avaialble as I expected

Reply to this Message

Dave Peterson - 28 Mar 2008 22:54 GMT

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.

> That worked. I was using the wrong path, the one mentioned in the Microsoft
> Help.
[quoted text clipped - 34 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 28 Mar 2008 19:08 GMT

If you clicked on File>New...Blank workbook, you will get the Excel default
workbook.

File>New 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

>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

Reply to this Message