Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to use startup folders in Excel
Article ID: 822107 - View products that this article applies to.
For a Microsoft Excel 2002 version of this article, see 291218
For a Microsoft Excel 2000 version of this article, see 240150
For a Microsoft Excel 97 version of this article, see 259926
For a Microsoft Excel 2001 for Mac version of this article, see 259921
This step-by-step article describes how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways:
Folders that Excel uses at startupIf you install Excel in the default location, Excel opens files from the following paths:
Accepted file types during Excel startupYou typically use startup folders to load Excel templates and add-ins. You can also use startup folders to load workbooks. When you load the following types of files from a startup folder, the files have the important characteristics that are described in the following list.
TemplatesIf you save a workbook named Book.xlt, and then put it in a startup folder location, that workbook is the default workbook when you start Excel or open a new workbook.
To use additional templates, you must save them in the following folder:
C:\Program Files\Microsoft Office\Templates\1033To use the templates in Excel 2003, follow these steps:
To use the templates in Excel 2007, follow these steps:
Add-insAdd-ins (.xla files) that you put in a startup folder do not typically appear when you start Excel. The add-ins are loaded in memory. The add-ins run any auto macros.
You can use these add-ins by whatever method the add-in provides (for example, a command on a menu or a button on a toolbar).
WorkbooksWorkbooks (.xls files) that you put in a startup folder are loaded and appear when you start Excel, unless the workbook is saved in a hidden state.
For example, the personal macro workbook Personal.xls is a global macro workbook that Excel typically loads from the XLStart folder in a hidden state.
Incorrect use of the alternative startup file locationWhen you use the alternative startup file location, you must specify a file path where there are recognizable file types (such as templates, add-ins, and workbooks).
If Excel finds unrecognizable file types in a startup folder, you may receive an error message. The most common error message is:
This file is not a recognizable format.
Use the default file locationIn addition to the alternative startup file location, the default file location can be set by using the Default file location box on the General tab in the Options dialog box in Excel 2003.
The default file location differs from a startup folder. It can set the folder location that you want Excel to point to when you open or save a file by using the File menu.
Note In Excel 2007, to see the default file location, follow these steps: