Opening a Template File Automatically When Starting Microsoft Excel 2010

 

To have Excel open a template upon starting:

Option 1:
Save a template workbook file, named Book.xltx in Xlstart folder.
The Xlstart subfolder is located under Microsoft Excel 2007 folders on the hard drive.
When opening Excel the default Excel file is Book1.xlsx
To open a new workbook from the template while working in Excel, press Ctrl+N.

Option 2:
1. Save the template workbook file as MyWorkbook.xltx (just a suggestion) in any folder.
2. Select File -> Excel Options -> Advanced.
3. In the At start up open all files in box (in General section), enter the full path of the saved MyWorkbook.xltx file.
4. Click OK.

Note: Do not use the two options simultaneously, unless you have created more than one template workbook. Otherwise, Excel will try to open the file with the same name twice.



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>