Default Template

[Bob]

I am trying to establish a new default template. I have
found the book.xlt template under application date etc.,
and have saved the new template there. But, when I start
Excel, it doesn't pull my new template. Can someone
please help me... this is so frustrating. Thanks.

 

[Dave Peterson]

Maybe you're in the wrong XLStart folder.

I'd start excel and hit alt-f11 to get to the VBE.
Then ctrl-G to see the immediate window.
then paste this in:
?application.StartupPath
(? is an old BASIC abbreviation for Print)

I get this back (xl2002 and win98):
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

If that's not the one you expected, I'd move the book.xlt file in there (and
delete the other versions).

This might be worth looking at:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q240150
XL2000: How to Use Excel Startup Folders

http://support.microsoft.com/default.aspx?scid=KB;en-us;q291218
XL2002: How to Use Excel Startup Folders