Change Startup workbook

G

Gene Augustin

I created a workbook template with all the formats, logos, layouts, etc that
I want to use most of the time. I want this to be the default workbook for
NEW or on opening EXCEL.

I have put copies in the MY TEMPLATES folder, OFFICE>STARTUP>EXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno
 
G

Gord Dibben

Name it BOOK.xlt and store it in the XLSTART folder.

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

Will be default book for New workbooks.

Note: do not choose from New...Blank Workbook.

New(no ellipsis) or CTRL + n or New Icon

You can also place a template named SHEET.xlt to have a default
Insert>Worksheet.


Gord Dibben MS Excel MVP
 
P

Paul Wilson

You should save it as Book.xlt into your excel start folder
In XP: C:\Documents and Settings\username\Application
Data\Microsoft\Excel\XLSTART


Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top