Change Startup Workbook

[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

 

[JE McGimpsey]

DId you save it as a template?

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

 

[Gord Dibben]

See replies to your other posts.

Please do not multi-post.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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]

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 2004>Office>Startup>Excel 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 Library>Application Support>Microsoft 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.

 

[JE McGimpsey]

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.

 

[Dave Peterson]

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

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

 

[Gene Augustin]

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
(e-mail address removed), "JE McGimpsey"