Customize how Excel starts

Before you start Microsoft Office Excel, you can make sure that a specific workbook or a workbook template or worksheet template that has custom settings opens automatically when you start Excel. If you no longer need a specific workbook to open, you can stop it from being opened when you start Excel.

If a workbook that is opened when you start Excel contains automatic macros, such as Auto_Open, those macros will run when the workbook opens. If needed, you can prevent them from running automatically when you start Excel.

Tip   You can also customize the way that Excel starts by adding command-line switches and parameters to the startup command.

For more information, see Command-line switches for Excel.

In this article

Automatically open a specific workbook when you start Excel

Stop a specific workbook from opening when you start Excel

Automatically open a workbook template or worksheet template when you start Excel

Prevent automatic macros from running when you start Excel

Automatically open a specific workbook when you start Excel

To automatically open a specific workbook when you start Excel, you can place that workbook in the XLStart folder, or you can use an in addition to the XLStart folder.

Place a workbook in the XLStart folder

Any workbook, template, or that you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is usually located in one of the following places.

  • In Windows Vista, the path to the XLStart folder is usually:

    C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart.

  • In Microsoft Windows XP, the path to the XLStart folder is usually:

    C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart.

    Tip   You can locate the exact path to the XLStart folder in the Trust Center.

    How to locate the XLStart folder

    1. Click the Microsoft Office Button Office button image, and then click Excel Options.

    2. Click Trust Center, and then under Microsoft Office Excel Trust Center, click Trust Center Settings.

    3. Click Trusted Locations, and then verify the path to the XLStart folder in the list of trusted locations.

Use an alternate startup folder

  1. Click the Microsoft Office Button Office button image, click Excel Options, and then click the Advanced category.

  2. Under General, in the At Startup, open all files in box, type the full path of the folder that you want to use as the alternate startup folder.

    Because Excel will try to open every file in the alternate startup folder, make sure that you specify a folder that contains only files that Excel can open.

Note   If a workbook with the same name is in both the XLStart folder and the alternate startup folder, the file in the XLStart folder opens.

Top of Page

Stop a specific workbook from opening when you start Excel

Depending on the location of the workbook that is automatically opened when you start Excel, do any of the following to make sure that the workbook no longer opens upon startup.

  • If the workbook is stored in the XLStart folder, remove it from that folder.

    • In Windows Vista, the path to the XLStart folder is usually:

      C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart.

    • In Microsoft Windows XP, the path to the XLStart folder is usually:

      C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart.

  • If the workbook is stored in the alternate startup folder, do the following:

    1. Click the Microsoft Office Button Office button image, click Excel Options, and then click the Advanced category.

    2. Under General, clear the contents of the At startup, open all files in box, and then click OK.

    3. In Windows Explorer, remove any icon that starts Excel and automatically opens the workbook from the alternate startup folder.

      Tip   You can also right-click that icon, click Properties, and then remove any references to the workbook on the Shortcut tab.

Top of Page

Automatically open a workbook template or worksheet template when you start Excel

You can save workbook settings that you frequently use in a workbook template, and then automatically open that workbook template every time that you start Excel.

  1. Do one of the following:

    • To use a workbook template, create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting that you want to use in new workbooks that will be based on the workbook template.

    • To use a worksheet template, create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information that you want to appear on all new worksheets that will be based on the worksheet template.

      Settings that you can save in a workbook or worksheet template

      • Cell and sheet formats.

      • Page formats and print area settings for each sheet.

      • Cell styles.

      • The number and type of sheets in a workbook.

      • Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.

      • Text you want to repeat, such as page headers and row and column labels.

      • Data, graphics, formulas, charts, and other information.

      • Data validation settings.

      • Macros, hyperlinks, and ActiveX controls on forms.

      • Workbook calculation options and window view options.

  2. Click the Microsoft Office Button Office button image, and then click Save As.

  3. In the Save as type box, click Template.

  4. In the Save in box, select the folder where you want to store the template.

    • To create the or , select either the XLStart folder or the alternate startup folder.

      • In Windows Vista, the path to the XLStart folder is usually:

        C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart.

    • In Microsoft Windows XP, the path to the XLStart folder is usually:

      C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart.

    • To create a custom workbook or worksheet template, make sure that the Templates folder is selected.

      • In Windows Vista, the Templates folder is usually:

        C:\Users\<user name>\AppData\Roaming\Microsoft\Templates.

      • In Microsoft Windows XP, the Templates folder is usually:

        C:\Documents and Settings\<user name>\Application Data\Microsoft\Templates.

  5. In the File name box, do one of the following:

    • To create the default workbook template, type Book.

    • To create the default worksheet template, type Sheet.

    • To create a custom workbook or worksheet template, type the name that you want to use.

  6. Click Save.

  7. Click the Microsoft Office Button Office button image, and then click Close.

Top of Page

Prevent automatic macros from running when you start Excel

Automatic macros (such as Auto_Open) that have been recorded in a workbook that opens when you start Excel will automatically run as soon as the workbook opens.

  • To prevent macros from automatically running, hold down SHIFT while you start Excel.

Tip   For more information about automatic macros, see Run a macro.

Top of Page

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language