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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

DId you save it as a template?

Do you have an alternate startup directory specified in Options/General?

In article ,
Gene Augustin wrote:

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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

See replies to your other posts.

Please do not multi-post.


Gord Dibben MS Excel MVP

On Wed, 04 Feb 2009 10:38:42 -0500, Gene Augustin
wrote:

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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

Rename workbook.xlt to book.xlt
and delete (or move) workbook.xls.

A new workbook will be created based on this workbook when you click on the New
Icon on the standard toolbar.

Gene Augustin wrote:

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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

--

Dave Peterson

I think XLStart is for Office 2007 or 2008. I gave up on 2008 for MAC and
reverted to 2004 because there was no longer a macro capability in 2008 and
I have a lot of macros in 2004.

I did a search, there is no folder XLStart on my computer.

I followed the instructions for Office 2004 for MAC.

I created a template, it was stored in My Templates as TLR.xlt
I set the General Preference to Office 2004OfficeStartupExcel and put the
desired workbook there using various names on separate tries. I tried
TLR.xlt TLR.xls Workbook.xlt Workbook.xls Book.xlt Book.xls

I then created a new folder in the office directory: Startup-1, set it as
the default startup folder in preferences and made the original startup
folder for Excel the alternate startup folder.

I then tried all of the above names in both places, none worked.

Somewhere in Microsoft Office never-never land is a file with an unknown
name in an unknown folder that is the default file that I can't find or
change.

I've looked in the LibraryApplication SupportMicrosoft and there is
nothing related to this there that I can find. There are some left-over
Office 2008 files and folders that I think I should trash, but don't want to
do it until I get this resolved.

I had a similar problem with Word, but found a file named Normal that was
the default file for Word. I replaced it with my Letterhead file for Word
renamed as Normal.dot. I also created a template with nothing in it and
called it BlankPage.dot, so for most openings I get my letterhead page and
If I want a true blank page, I use the project gallery to open it from my
templates.

I'm trying to do the same thing in Excel.

Sorry about the previous posts in multiple forums. I didn't know any better.
It won't happen again.
On 2/4/09 11:59 AM, in article , "Dave
Peterson" wrote:

Rename workbook.xlt to book.xlt
and delete (or move) workbook.xls.

A new workbook will be created based on this workbook when you click on the
New
Icon on the standard toolbar.

Gene Augustin wrote:

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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

You can find precise instructions for creating a default workbook using
MacXL in MacXL Help ("default workbook template")

You'll need to save the template as "Workbook" (no quotes, no extension)
to the

HD:Applications:Microsoft Office 2004:Office:Startup:Excel

folder, or to the Alternate Startup Folder specified in
Preferences/General.

I'd recommend specifying the alternate startup folder - that way you can
make it specific to individual OS user accounts if you'd like, rather
than being universal.

I'm surprised your Word solution works - Word04 requires the Normal
template to be named Normal, not Normal.dot. Regardless, make sure you
have it backed up - Normal is used as a scratch file for EVERY document
you open, so it is MUCH more vulnerable to corruption than a standalone
template.

If you have MacOffice-specific questions, you may want to look in the

microsoft.public.mac.office.excel

and

microsoft.public.mac.office.word

newsgroups instead of these, which are windows-centric.



In article ,
Gene Augustin wrote:

I think XLStart is for Office 2007 or 2008. I gave up on 2008 for MAC and
reverted to 2004 because there was no longer a macro capability in 2008 and
I have a lot of macros in 2004.

Thannks. The removal of the extension fixed the problee. Also, you are
correct for Word. I didn't remember that I put it in with no extension
there.

Again, thanks for the great and timely responses













n 2/4/09 1:04 PM, in article
, "JE McGimpsey"
wrote:

You can find precise instructions for creating a default workbook using
MacXL in MacXL Help ("default workbook template")

You'll need to save the template as "Workbook" (no quotes, no extension)
to the

HD:Applications:Microsoft Office 2004:Office:Startup:Excel

folder, or to the Alternate Startup Folder specified in
Preferences/General.

I'd recommend specifying the alternate startup folder - that way you can
make it specific to individual OS user accounts if you'd like, rather
than being universal.

I'm surprised your Word solution works - Word04 requires the Normal
template to be named Normal, not Normal.dot. Regardless, make sure you
have it backed up - Normal is used as a scratch file for EVERY document
you open, so it is MUCH more vulnerable to corruption than a standalone
template.

If you have MacOffice-specific questions, you may want to look in the

microsoft.public.mac.office.excel

and

microsoft.public.mac.office.word

newsgroups instead of these, which are windows-centric.



In article ,
Gene Augustin wrote:

I think XLStart is for Office 2007 or 2008. I gave up on 2008 for MAC and
reverted to 2004 because there was no longer a macro capability in 2008 and
I have a lot of macros in 2004.

I didn't realize that you were using a Mac.

Ignore my response. It could only be correct by coincidence.

Gene Augustin wrote:

I think XLStart is for Office 2007 or 2008. I gave up on 2008 for MAC and
reverted to 2004 because there was no longer a macro capability in 2008 and
I have a lot of macros in 2004.

I did a search, there is no folder XLStart on my computer.

I followed the instructions for Office 2004 for MAC.

I created a template, it was stored in My Templates as TLR.xlt
I set the General Preference to Office 2004OfficeStartupExcel and put the
desired workbook there using various names on separate tries. I tried
TLR.xlt TLR.xls Workbook.xlt Workbook.xls Book.xlt Book.xls

I then created a new folder in the office directory: Startup-1, set it as
the default startup folder in preferences and made the original startup
folder for Excel the alternate startup folder.

I then tried all of the above names in both places, none worked.

Somewhere in Microsoft Office never-never land is a file with an unknown
name in an unknown folder that is the default file that I can't find or
change.

I've looked in the LibraryApplication SupportMicrosoft and there is
nothing related to this there that I can find. There are some left-over
Office 2008 files and folders that I think I should trash, but don't want to
do it until I get this resolved.

I had a similar problem with Word, but found a file named Normal that was
the default file for Word. I replaced it with my Letterhead file for Word
renamed as Normal.dot. I also created a template with nothing in it and
called it BlankPage.dot, so for most openings I get my letterhead page and
If I want a true blank page, I use the project gallery to open it from my
templates.

I'm trying to do the same thing in Excel.

Sorry about the previous posts in multiple forums. I didn't know any better.
It won't happen again.
On 2/4/09 11:59 AM, in article , "Dave
Peterson" wrote:

Rename workbook.xlt to book.xlt
and delete (or move) workbook.xls.

A new workbook will be created based on this workbook when you click on the
New
Icon on the standard toolbar.

Gene Augustin wrote:

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, OFFICESTARTUPEXCEL both as
Workbook.xlt and Workbook.xls

It still defaults to the Microsoft default template.

Help

Geno

--

Dave Peterson