To have Excel open a template upon starting:
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.
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.