Opening a template file automatically upon starting Microsoft Excel

There are two options for opening a workbook template automatically upon starting Excel.

First option
Save a workbook name Book.xlt ( in Excel 2000 name the book Sheet.xlt), which you customized, in the sub-folder XlStart. When Excel is started, a customized workbook Book1.xls (or Sheet1.xls in Excel 2000) is opened from within the template you saved, instead of the standard Book1.xls. The XlStart sub-folder is located in the same folder as the Office program on the hard drive.
To open a new workbook, press Ctrl+N or in the Standard toolbar, click the New icon.

Second option
Save the template file you created as MyWorkbook.xlt in any folder, and enter the name of the workbook template in the Options dialog box.

  1. From the Tools menu, select Options.
  2. Select the General tab.
  3. In the Alternate startup file location box, enter the full path where you saved the MyWorkbook file.
  4. Click OK.

Note
Do not use the two selected options simultaneously, unless you have created more than one workbook. Use only one of the two options (Excel tries to open the file with the same name twice).

Comments

  1. Bruce in Australia

    When I create a new spreadsheet, the AutoRecover file location defaults to a location that no longer exists, how do I change this default so that from here-on at least the AutoRecover file location will be a location that exists?

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.