personal.xls in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 06 Oct 2006 16:46 GMT

I am running Excel 2003 on XP. In C:\Program Files\Microsoft
Office\Office11\XLStart I have book.xlt, book1.xlt (my custom workbook)
and personal.xls. When I open Excel, at the top it reads personal.xls.
Shouldn't it read book1? Macros run fine. Anything wrong here?
Thanks.

Reply to this Message

Dave Peterson - 06 Oct 2006 16:52 GMT

With personal.xls the active workbook, hit Window|Hide.

Then close excel and answer yes to save personal.xls as a hidden workbook.

Is there a reason you don't just use book.xlt as your custom workbook template?

Then you could dump book1.xlt.

> I am running Excel 2003 on XP. In C:\Program Files\Microsoft
> Office\Office11\XLStart I have book.xlt, book1.xlt (my custom workbook)
> and personal.xls. When I open Excel, at the top it reads personal.xls.
> Shouldn't it read book1? Macros run fine. Anything wrong here?
> Thanks.

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 06 Oct 2006 21:40 GMT

Books saved with extension of .XLT are Templates.

Templates do not open automatically when stored in XLSTART folder or any other
folder.

Book.XLS will open when Excel starts if stored in the XLSTART folder.

Gord Dibben MS Excel MVP

>I am running Excel 2003 on XP. In C:\Program Files\Microsoft
>Office\Office11\XLStart I have book.xlt, book1.xlt (my custom workbook)
>and personal.xls. When I open Excel, at the top it reads personal.xls.
>Shouldn't it read book1? Macros run fine. Anything wrong here?
>Thanks.

Reply to this Message

Rate this thread: