ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   default template at startup (https://www.excelbanter.com/excel-discussion-misc-queries/112397-default-template-startup.html)

Amy

default template at startup
 
Hi,

I created a template and saved it in the XLSTART folder, so that it would
open every time I started Excel. That turned out to be annoying because
usually when I start Excel I want to work on an existing document rather than
start a new one, so I have to close the Book1 workbook every time.

My question is, where should I move the template to (instead of the XLSTART
folder) so that it is still the default template used if I start a new
workbook, but so that it does not open on startup?

Thanks.

Dave Peterson

default template at startup
 
I keep three files in my XLStart folder:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

book.xlt
sheet.xlt
personal.xla

Each time I open excel by double clicking on a file name in windows explorer,
only that file opens.

If I start excel via a shortcut, personal.xla opens (hidden) and a new workbook
based on book.xlt is created.

What's the name of your template? (and do you want to use that template for the
basis of new workbooks?)

and do you have anything else in XLStart--be sure to check for multiple
locations of XLStart, too.

Amy wrote:

Hi,

I created a template and saved it in the XLSTART folder, so that it would
open every time I started Excel. That turned out to be annoying because
usually when I start Excel I want to work on an existing document rather than
start a new one, so I have to close the Book1 workbook every time.

My question is, where should I move the template to (instead of the XLSTART
folder) so that it is still the default template used if I start a new
workbook, but so that it does not open on startup?

Thanks.


--

Dave Peterson

Dave Peterson

default template at startup
 
Each time I open excel by double clicking on a file name in windows explorer,
only that file opens. (personal.xla opens, too. But no workbook based on
book.xlt is created.)

Dave Peterson wrote:

I keep three files in my XLStart folder:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

book.xlt
sheet.xlt
personal.xla

Each time I open excel by double clicking on a file name in windows explorer,
only that file opens.

If I start excel via a shortcut, personal.xla opens (hidden) and a new workbook
based on book.xlt is created.

What's the name of your template? (and do you want to use that template for the
basis of new workbooks?)

and do you have anything else in XLStart--be sure to check for multiple
locations of XLStart, too.

Amy wrote:

Hi,

I created a template and saved it in the XLSTART folder, so that it would
open every time I started Excel. That turned out to be annoying because
usually when I start Excel I want to work on an existing document rather than
start a new one, so I have to close the Book1 workbook every time.

My question is, where should I move the template to (instead of the XLSTART
folder) so that it is still the default template used if I start a new
workbook, but so that it does not open on startup?

Thanks.


--

Dave Peterson


--

Dave Peterson

Gord Dibben

default template at startup
 
Amy

If you truly saved the workbook as a Template, it will not open at startup.

BOOK.XLT templates in the XLSTART folder has to be opened via FileNew or using
the New File Icon.

To stop Book1.xls from opening, append /e to your Excel shortcut.

i.e. "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e


Gord Dibben MS Excel MVP


On Sun, 1 Oct 2006 23:27:01 -0700, Amy wrote:

Hi,

I created a template and saved it in the XLSTART folder, so that it would
open every time I started Excel. That turned out to be annoying because
usually when I start Excel I want to work on an existing document rather than
start a new one, so I have to close the Book1 workbook every time.

My question is, where should I move the template to (instead of the XLSTART
folder) so that it is still the default template used if I start a new
workbook, but so that it does not open on startup?

Thanks.



Amy

default template at startup
 
Hi Dave and Gord,
Thanks for your help but I managed to fix it myself. I just took the
template out of the XLSTART folder and saved it elsewhere on my computer. Now
it doesn't open when I start Excel, but I can still choose to base new
workbooks on this template by using filenew.
Thanks,
Amy

"Gord Dibben" wrote:

Amy

If you truly saved the workbook as a Template, it will not open at startup.

BOOK.XLT templates in the XLSTART folder has to be opened via FileNew or using
the New File Icon.

To stop Book1.xls from opening, append /e to your Excel shortcut.

i.e. "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e


Gord Dibben MS Excel MVP


On Sun, 1 Oct 2006 23:27:01 -0700, Amy wrote:

Hi,

I created a template and saved it in the XLSTART folder, so that it would
open every time I started Excel. That turned out to be annoying because
usually when I start Excel I want to work on an existing document rather than
start a new one, so I have to close the Book1 workbook every time.

My question is, where should I move the template to (instead of the XLSTART
folder) so that it is still the default template used if I start a new
workbook, but so that it does not open on startup?

Thanks.





All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com