Pin Me

Microsoft Excel: Have Excel Always Open Certain Workbook(s)

written by: Mr Excel•edited by: Tricia Goss•updated: 7/10/2008

Problem: You always use Excel to work on a particular workbook. Every time that you open Excel, you want this workbook to open automatically.

  • slide 1 of 2

    See all Microsoft Excel tips

    Strategy: Place the file (or a shortcut to the file) in the XLStart folder. This folder can generally be found in the C:\Documents and Settings\Username\Application Data\Microsoft\Excel\ folder. Anything in this folder will automatically start when Excel starts.

    Alternate Strategy: You can specify one folder to act as an additional XLStart folder. Follow these steps.

    1) Move the Excel workbook or workbooks to a new folder. Excel will try to open every file in this folder, so make sure that you do not have other files in it.

    2) Open Excel. From the Tools menu, select Options.

    3) In the Options dialog box, find the General tab. There are five fields at the bottom of the General tab.In Excel 2002 and later versions, the penultimate field is called At Startup, Open all Files in:. In Excel 2000 and earlier versions, this same field was called Alternate Startup File Location. In either case, enter the path to the folder in this field.

    Alternate Strategy: A third strategy is to use a command line switch. This is discussed in the next topic.

    Summary: Excel will automatically open all files in the XLStart folder or in one additional alternate startup folder that you specify.

    Commands Discussed: Tools – Options – General

    Cross Reference: Set up Excel Icons to Open a Specific File on Startup

    See all Microsoft Excel tips

  • slide 2 of 2

    Images

    Fig. 61Fig. 62