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.

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


On Sat, 14 Feb 2009 07:44:13 -0800, Glenn_707
<(E-Mail Removed)> wrote:

>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.

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" wrote:

> 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
>
>
> On Sat, 14 Feb 2009 07:44:13 -0800, Glenn_707
> <(E-Mail Removed)> wrote:
>
> >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.
>
>

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


On Sat, 14 Feb 2009 09:55:01 -0800, Glenn_707
<(E-Mail Removed)> wrote:

>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" wrote:
>
>> 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
>>
>>
>> On Sat, 14 Feb 2009 07:44:13 -0800, Glenn_707
>> <(E-Mail Removed)> wrote:
>>
>> >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.
>>
>>