HI TWIMC,

I'm try to get Excel to use a default workbook when I click on the 'New'
workbook button on the toolbar. Yes I have the Book.xls file in my
'C:\Documents and Settings\mccake\Application Data\Microsoft\Excel\XLSTART'
folder but when I start an Excel session it opens the Book.xls and dosen't
use it as a template in that when I click on the 'New' button I get a new
workbook Book1.xls that has the original workbook format. Yes I've tried a
template workbook (Book.xlt) but that too does the same, Excel starts and
opens the Book.xlt but I'm expecting Excel to open with a workbook file name
of Book1.xls but using my Book.xls (or Book.xlt) as a default. So the
questions is, is the XLSTART folder the correct folder.

It's probably not Excel that is the problem is probably to do with the App
Agent/Managed Apps scripts that run when ever I start an office application.

TIA

Book.xlt in XLSTART works perfectly for me. Make sure you actually saved
"Book" as a template through the Save As dialog and didn't just rename a
normal file.

--
Jim
"Kevin McCartney" wrote in
message ...
| HI TWIMC,
|
| I'm try to get Excel to use a default workbook when I click on the 'New'
| workbook button on the toolbar. Yes I have the Book.xls file in my
| 'C:\Documents and Settings\mccake\Application
Data\Microsoft\Excel\XLSTART'
| folder but when I start an Excel session it opens the Book.xls and dosen't
| use it as a template in that when I click on the 'New' button I get a new
| workbook Book1.xls that has the original workbook format. Yes I've tried a
| template workbook (Book.xlt) but that too does the same, Excel starts and
| opens the Book.xlt but I'm expecting Excel to open with a workbook file
name
| of Book1.xls but using my Book.xls (or Book.xlt) as a default. So the
| questions is, is the XLSTART folder the correct folder.
|
| It's probably not Excel that is the problem is probably to do with the App
| Agent/Managed Apps scripts that run when ever I start an office
application.
|
| TIA

You are on the right track............

Open a new workbook. Customize as you wish.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

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

This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Wed, 12 Dec 2007 05:43:02 -0800, Kevin McCartney
wrote:

HI TWIMC,

I'm try to get Excel to use a default workbook when I click on the 'New'
workbook button on the toolbar. Yes I have the Book.xls file in my
'C:\Documents and Settings\mccake\Application Data\Microsoft\Excel\XLSTART'
folder but when I start an Excel session it opens the Book.xls and dosen't
use it as a template in that when I click on the 'New' button I get a new
workbook Book1.xls that has the original workbook format. Yes I've tried a
template workbook (Book.xlt) but that too does the same, Excel starts and
opens the Book.xlt but I'm expecting Excel to open with a workbook file name
of Book1.xls but using my Book.xls (or Book.xlt) as a default. So the
questions is, is the XLSTART folder the correct folder.

It's probably not Excel that is the problem is probably to do with the App
Agent/Managed Apps scripts that run when ever I start an office application.

TIA