New Book Template

[goss]

Hi all -

I would like to create a template so that when I Ctrl+N on the
keyboard I receive a new Book with my custom configuration (Zoom,
Color Pallete, Gridlines)

I tried modifying Book1.xlt and resaving it in the same location I
found it
C:\Documents and Settings\goss\Application Data\Microsoft\Templates

I searched the PC, this is the only instance of Book1.xlt (Also ...
\goss\recent)

Using Office 11
Checked XLStart, it is empty

Unloaded all add-ins

Re-launched Excel but the standard Book1 is given, not my custom
version.
What else can I check into?
Thanks
-goss

 

[ufo_pilot]

Any workbook, template (template: A workbook that you create and use as the
basis for other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.), or workspace file
(workspace file: A file that saves display information about open workbooks,
so that you can later resume work with the same window sizes, print areas,
screen magnification, and display settings. A workspace file doesn't contain
the workbooks themselves.) you place in the XLStart folder is automatically
opened when you start Excel. This XLStart folder was created when you
installed Excel, and is located in one of the following places:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
C:\Program Files\Microsoft Office\Office11
HTH

 

[goss]

Any workbook, template (template: A workbook that you create and use as the
basis for other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.), or workspace file
(workspace file: A file that saves display information about open workbooks,
so that you can later resume work with the same window sizes, print areas,
screen magnification, and display settings. A workspace file doesn't contain
the workbooks themselves.) you place in the XLStart folder is automatically
opened when you start Excel. This XLStart folder was created when you
installed Excel, and is located in one of the following places:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
C:\Program Files\Microsoft Office\Office11
HTH











- Show quoted text -

Thanks.

My confusion comes from the fact that nothing is in xlstart at the
moment
Yet when I fire-up Excel I receive Book1, but it is not my Book1.xlt
(path given above at start of thread)
So where is this Book1.xls coming from?

I checked the default location (C:\Data\Excel - Hey, it's a company
laptop) Nothing there named "Book1.xls"
Nothing in XLStart folder (Only 1 XLStart folder I checked)
All add-ins are unloaded

Thanks
-goss

 

[Gord Dibben]

Start over.

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 or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...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 Insert>Sheet.

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


Gord Dibben Excel MVP

 

[goss]

Start over.

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 or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...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 Insert>Sheet.

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

Gord Dibben Excel MVP





- Show quoted text -

Thanks Gord
Works great!
Any way to get same result w/o BOOK1 opening when I launch Excel?

Thanks
-goss

 

[goss]

Thanks Gord
Works great!
Any way to get same result w/o BOOK1 opening when I launch Excel?

Thanks
-goss- Hide quoted text -

- Show quoted text -

For this to work, I have discovered that I must launch the Excel
application first and then browse to open a file
Habitually I use a file manager program, find the Excel file I need
and 2x click the file

I notice whwn I use this approach, any new workbooks revert to the
standard template
Only by launching the Excel app first do I receive BOOK1.XLT the
template I created.

Thanks
-goss