How do I change default template?
 

I'm trying to change the default startup template in Excel 2003. No luck.
I've followed all steps in the help menu with no luck?

Quoted from an XL "Tips" page:

"If you'd like certain settings to always be applied to new
workbooks, you can override what file Excel uses as the basis for
new files. All you have to do is create a special template file
and save it in your XLSTART folder.

Before you actually save the file, you need to identify where
your XLStart folder is located (or your Startup: Excel folder if
you're using a Mac). The location varies depending on both your
Office version and operating system, so your best course of
action is to use your operating system's Find or Search feature
to locate the folder. You may actually find multiple copies of
the folder, depending on whether your system incorporates user
profiles--choose whichever makes the most sense for your needs
and make a note of its path.

Once you have the folder path, configure a workbook as you'd
like and then save it as a template. To do so, choose File | Save
As from the menu bar. Next, choose Template (*.xlt) from the Save
As Type dropdown list (the Format pop-up menu on a Mac). Using
the Save In dropdown list, locate and open the XLStart or
Startup: Excel folder. Finally, change the File Name setting to
Book.xlt (just name the file Workbook on a Mac) and click Save."

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"cooldaisyday" wrote in message
...
I'm trying to change the default startup template in Excel 2003. No luck.
I've followed all steps in the help menu with no luck?

Thank you..I did not realize that I had to rename the file book.xlt.
I just got this program today, so excuse me if I seem daft :)
If I want to use the default spreadsheet for i application how do I get the
blank excel worksheet ?

"RagDyeR" wrote:

Quoted from an XL "Tips" page:

"If you'd like certain settings to always be applied to new
workbooks, you can override what file Excel uses as the basis for
new files. All you have to do is create a special template file
and save it in your XLSTART folder.

Before you actually save the file, you need to identify where
your XLStart folder is located (or your Startup: Excel folder if
you're using a Mac). The location varies depending on both your
Office version and operating system, so your best course of
action is to use your operating system's Find or Search feature
to locate the folder. You may actually find multiple copies of
the folder, depending on whether your system incorporates user
profiles--choose whichever makes the most sense for your needs
and make a note of its path.

Once you have the folder path, configure a workbook as you'd
like and then save it as a template. To do so, choose File | Save
As from the menu bar. Next, choose Template (*.xlt) from the Save
As Type dropdown list (the Format pop-up menu on a Mac). Using
the Save In dropdown list, locate and open the XLStart or
Startup: Excel folder. Finally, change the File Name setting to
Book.xlt (just name the file Workbook on a Mac) and click Save."

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"cooldaisyday" wrote in message
...
I'm trying to change the default startup template in Excel 2003. No luck.
I've followed all steps in the help menu with no luck?

Method to ensure that a New workbook is based on your Template.......

Create the workbook as you wish then save as a Template.

Store this Template as BOOK.XLT in your XLSTART folder.

Now in ToolsCustomizeCommandsFile you will find two "New" buttons.

One is New...(note the ellipsis). This will bring up the "Blank workbook"
which is not your Template or force you to scroll to your Template and click
on that.

The other is New with no ellipsis. This one will insert a new workbook based
on your Template from the XLSTART folder.


Gord Dibben Excel MVP



On Sat, 19 Mar 2005 14:31:07 -0800, cooldaisyday
wrote:

Thank you..I did not realize that I had to rename the file book.xlt.
I just got this program today, so excuse me if I seem daft :)
If I want to use the default spreadsheet for i application how do I get the
blank excel worksheet ?

"RagDyeR" wrote:

Quoted from an XL "Tips" page:

"If you'd like certain settings to always be applied to new
workbooks, you can override what file Excel uses as the basis for
new files. All you have to do is create a special template file
and save it in your XLSTART folder.

Before you actually save the file, you need to identify where
your XLStart folder is located (or your Startup: Excel folder if
you're using a Mac). The location varies depending on both your
Office version and operating system, so your best course of
action is to use your operating system's Find or Search feature
to locate the folder. You may actually find multiple copies of
the folder, depending on whether your system incorporates user
profiles--choose whichever makes the most sense for your needs
and make a note of its path.

Once you have the folder path, configure a workbook as you'd
like and then save it as a template. To do so, choose File | Save
As from the menu bar. Next, choose Template (*.xlt) from the Save
As Type dropdown list (the Format pop-up menu on a Mac). Using
the Save In dropdown list, locate and open the XLStart or
Startup: Excel folder. Finally, change the File Name setting to
Book.xlt (just name the file Workbook on a Mac) and click Save."

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"cooldaisyday" wrote in message
...
I'm trying to change the default startup template in Excel 2003. No luck.
I've followed all steps in the help menu with no luck?