More on getting my default xlt to work

[Glenn_707]

I have more information.

I did get Control-N to work, but I had to close and reopen Excel.

Now, it looks like I have to have two copies each of Book.xlt and Sheet.xlt,
one copy of both in the C:\Program Files\Microsoft Office\Office11\XLStart
and one copy of both in C:\Documents and Settings\my name\Application
Data\Microsoft\Templates.

For example, Control-N opens an xls based on the xlt in the XLStart folder
but File|New opens a box and I choose Book.xlt from the "New Workbook" pane
and it opens an xls based on the xlt in the Templates subdirectory.

Am I doing something wrong again? I guess I can keep two copies, but that is
a pain.

Is there a way to set one of these choices to look to the other. I read a
thread that Word has a set of choices but does that apply here? Someone at
work suggested I put the xlt in the subdirectory C:\Documents and
Settings\Pi\Application Data\Microsoft\Excel\XLSTART. Is that yet a third
choice?

Thanks.

 

[Gord Dibben]

Put Book.xlt and Sheet.xlt into

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

I think you will have success with CTRL + n or New File Icon or File>New(no
ellipsis)

Do not use File>New...Blank Workbook


Gord Dibben MS Excel MVP

 

[Glenn_707]

Thanks Gord,

I dug in a little more. It looks like the two XLSTART places are where you
can use CTRL - N. If you use File>New... then if there is a Book.xlt in
either XLSTART places, it will not show up in File>New... A file named
Book.xlt will show up there only if it is in the TEMPLATES area. So, I think
either you need two Book files or only use CTRL + N.

Do you agree?

 

[Gord Dibben]

Thank you, but I don't need to know how to open a new workbook based on
Book.xlt template.

I have been using the method I posted for years in all versions of Excel
with no failures.

You are missing one or more parts of my explanation.


Gord