Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Default Excel file and template | Excel Discussion (Misc queries) | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel |