There are usually two XLSTART folders.

C:\Documents and Settings\username\Application\Data\Microsoft\Excel \XLSTART is
the usual default.

You will also find an XLSTART folder at....

C:\Program Files\Microsoft Office\Office11\XLStart which Excel doesn't seem to
use.

The Blank workbook that opens using File New...(note ellipsis) is not the
BOOK.XLT you stored in the XLSTART folder.

I'm not sure if there is a method to change this behavior. Maybe a Registry
change. I'll have a look.

I use the other FileNew command(the one without the ellipsis...). That will
give you your default BOOK.XLT directly from your XLSTART folder.

If not on your File Menu, go to ToolsCustomizeCommandsFile and drag the
"New" command to the File Menu or a Toolbar.

Check out the descriptions of the two "New" commands while you're there. You
will see the difference between the two.


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 08:37:07 -0800, "krinneyd"
wrote:

Hi Again,

I found the XLStart folder and saved the book.xlt and sheet.xlt in there but
it did not overwrite the template - I know I am doing somthing wrong - could
u show me the directory where I need to go to make the changes.

Krinneyd

"Dave Peterson" wrote:

Are you related to Amanda?

You could create a workbook that has the settings you want. Then save
this workbook as a template for all new workbooks.

If that's what you want to do:
Start a new workbook.
change the margins
(and modify it to your heart's content)

Also, modify anything else you want as a standard--header/footers, page
orientation, number of worksheets in that workbook???

Now save it as a template in your XLStart folder as book.xlt

Then when you click on that New icon, the new workbook will inherit all those
settings.

=====
If you create another file named sheet.xlt (in the same XLStart location), then
every new worksheet added will inherit the settings from this template.

I set up book.xlt the way I wanted it (one sheet only) and then used windows
explorer to copy it to sheet.xlt. Then they would be identical. (Seemed like
less work, too.)

krinneyd wrote:

I cannot seem to find where to change the default margin settings for Excel -
I can go in and change them everytime on the page setup but I do not want to
have to manually change the margins everytime. Please help!

--

Dave Peterson