default template

[Guest]

Which folder contains the default Excel template? I am hoping that If I edit this template, the changes I make in that file will be contained in all the files I create thereaftger.

 

[Dave Peterson]

Your XLStart folder.

You can use windows|Find (or Search) to look for it.

Or you can do this:
Start Excel
hit Alt-F11 (to get to the VBE where macros live)
hit ctrl-G (to see the immediate window)

type this and hit enter.

?application.StartupPath

I get this with win98 and xl2002:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

You'll want to save this template file as book.xlt. If you want the similar
effect for new sheets to existing workbooks, create another template, save it in
the same location, but name it sheet.xlt.

 

[Gord Dibben]

AL

Open a new workbook. Customize as you wish. File>Save 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 File>New>Workbook.

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

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

Gord Dibben Excel MVP