Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
Posts: 165
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


  #5   Report Post  
Posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
Posts: 165
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Default Excel file and template Mark McDonough Excel Discussion (Misc queries) 2 May 26th 06 02:50 AM
Template question - can I replace the default "worksheet" template Jackie Excel Discussion (Misc queries) 2 April 19th 06 11:59 AM
How do you open a template at startup? James Kendall Excel Discussion (Misc queries) 7 July 26th 05 07:33 PM
Setting a default save folder for a template postitnote100 Excel Discussion (Misc queries) 1 July 8th 05 09:30 PM
Template in Excel prettytwin1 New Users to Excel 1 March 9th 05 09:22 PM


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"