Microsoft KB Archive/291218

= How to use Excel startup folders in Excel 2002 =

Article ID: 291218

Article Last Modified on 5/7/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q291218





For a Microsoft Excel 97 version of this article, see 259926.

For a Microsoft Excel 2000 version of this article, see 240150.

IN THIS TASK
SUMMARY Folders That Excel Uses at Startup
 * Microsoft Windows 98 and Microsoft Windows Millennium Edition (Me)
 * Microsoft Windows NT 4.0
 * Microsoft Windows 2000
 * Microsoft Windows XP

Accepted File Types During Excel Startup
 * Templates
 * Add-Ins
 * Workbooks

Incorrect Use of the Alternate Startup File Location Using the Default File Location REFERENCES



SUMMARY
This step-by-step article explains how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways:


 * To load Excel files at startup

-and-


 * As a reference location for templates

The actual startup folder locations can vary depending on which version of Excel you use. For more details about Excel startup locations, please see the &quot;References&quot; section later in this article.

back to the top

Folders That Excel Uses at Startup
If you install Microsoft Excel to the default location, Excel opens files from the following paths.

back to the top

Microsoft Windows 98 and Microsoft Windows Millennium Edition (Me)

 * C:\Program Files\Microsoft Office\Office\Office10\Xlstart
 * C:\Windows\Application Data\Microsoft\Excel\Xlstart

NOTE: If you have Profiles activated, the path to the XLStart folder is instead:

C:\Windows\Profiles\ \Application Data\Microsoft\Excel\Xlstart
 * The folder that is specified in the Alternate startup file location box on the General tab of the Options dialog box (on the Tools menu, click Options).

back to the top

Microsoft Windows NT 4.0

 * C:\Program Files\Microsoft Office\Office\Office10\Xlstart
 * C:\Winnt\Profiles\ \Application Data\Microsoft\Excel\Xlstart

where  is your login user name.
 * The folder specified in the At startup, open all files in box on the General tab of the Options dialog box (on the Tools menu, click Options).

back to the top

Microsoft Windows 2000

 * C:\Program Files\Microsoft Office\Office10\Xlstart
 * C:\Documents and Settings\ \Application Data\Microsoft\Excel\XLSTART

where  is your login user name.
 * The folder specified in the At startup, open all files in box on the General tab of the Options dialog box (on the Tools menu, click Options).

back to the top

Microsoft Windows XP

 * C:\Program Files\Microsoft Office\Office10\Xlstart
 * C:\Documents and Settings\ \Application Data\Microsoft\Excel\XLSTART

where  is your login user name.
 * The folder specified in the At startup, open all files in box on the General tab of the Options dialog box (on the Tools menu, click Options).

back to the top

Accepted File Types During Excel Startup
You typically use startup folders to load Excel templates and add-ins, but you can also use them to load workbooks. When you load these three types of files from a startup folder, they have the following important characteristics.

back to the top

Templates
 If you save a workbook called Book.xlt and place it in a startup folder location, that workbook becomes the default workbook when you start Excel, and when you open any additional new workbooks. To use any additional custom templates that you create, you must place them in the following folder:

C:\Program Files\Microsoft Office\Templates\1033

You can then use the templates by clicking New on the File menu.

back to the top

Add-Ins

 * Add-ins (*.xla) that you place in a startup folder do not typically appear when you start Excel, but are loaded in memory and run any auto macros.
 * You can then use these add-ins by whatever method the add-in provides (that is, a menu item or toolbar button).

back to the top

Workbooks

 * Workbooks (*.xls) that you place 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.

back to the top

Incorrect Use of the Alternate Startup File Location
 When using the alternate startup file location, it is important to specify a file path in which 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.



back to the top

Using the Default File Location

 * In addition to the alternate startup file location, the Default file location setting is also on the General tab in the Options dialog box. This setting is different from a startup folder; it sets the folder location that you want Excel to point to when you open or save a file by using the File menu.

back to the top

<div class="references_section">