Default Template

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
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
 
Back
Top