Book.xlt and insert sheets

[Desert Piranha]

Hi all,

While not a VBA question, it is excel, so i thought i may get some input.

I have customized my Book.xlt the way i want it. It opens with Excel just the way it should. No problem. Its in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART

There are NO other Book.xlt files on my system.

There are NO files in:
C:\Program Files\Microsoft Office\Office\XLStart

There are no other XLStart folders on my system.

Problem: When i open Excel a "Book1" opens, with format just like i want it, if however i insert sheets they are NOT in the customized format. They are in the old default format.

Question: What is the source of "insert sheets"?? So i can change the source. I figure it the insert sheets is comming from a template folder but i cannot identify the source file.

Thx

[Bob Phillips]

Hi all,

While not a VBA question, it is excel, so i thought i may get some input.

I have customized my Book.xlt the way i want it. It opens with Excel just the way it should. No problem. Its in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART

There are NO other Book.xlt files on my system.

There are NO files in:
C:\Program Files\Microsoft Office\Office\XLStart

There are no other XLStart folders on my system.

Problem: When i open Excel a "Book1" opens, with format just like i want it, if however i insert sheets they are NOT in the customized format. They are in the old default format.

Question: What is the source of "insert sheets"?? So i can change the source. I figure it the insert sheets is comming from a template folder but i cannot identify the source file.

Thx

You need to create another called Sheet.xlt with the new sheet format.

[Desert Piranha]

You need to create another called Sheet.xlt with the new sheet format.xld,

Thx much. It is beautiful.

Thx again
Dave