Automatically open template when Excel 2003 starts

J

John9210

Win XP, Excel 2003, my home computer. I've placed a template in Excel's
XLStart folder. However it does not open automatically when Excel starts.
How can I do this? I have tried placing the template in the XLStart folder in
C:\program files\office11\ as well as in C:\Documents and Settings\User
name\Application data\Microsoft\Excel. Neither works.

The template simply contains worksheet formatting characteristics that I
would like to use as default on all my Excel worksheets.

Any suggestions?

By the way, selecting a discussion group from the list is tough. The list is
too long and needs breaking up into groups. I could not find one for Excel!
 
J

JE McGimpsey

John9210 said:
Win XP, Excel 2003, my home computer. I've placed a template in Excel's
XLStart folder. However it does not open automatically when Excel starts.
How can I do this? I have tried placing the template in the XLStart folder in
C:\program files\office11\ as well as in C:\Documents and Settings\User
name\Application data\Microsoft\Excel. Neither works.

The template simply contains worksheet formatting characteristics that I
would like to use as default on all my Excel worksheets.

Any suggestions?

By the way, selecting a discussion group from the list is tough. The list is
too long and needs breaking up into groups. I could not find one for Excel!

And it continues to be confusing, since this is the Mac Office
newsgroup. There are a number of groups for XL, including:

microsoft.public.excel.newusers
microsoft.public.excel
microsoft.public.excel.misc
microsoft.public.excel.worksheet.functions
microsoft.public.excel.programming
microsoft.public.excel.templates


For WinXL, the template in your startup folder should be named
"Book.xlt" (no quotes), for the default template, otherwise, it won't be
opened on startup.

You can also have a single-worksheet workbook named "Sheet.xlt" (again,
no quotes) in your startup folder that will be used as the default
whenever you insert a worksheet.
 

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