Microsoft Excel - Automatically Open A Workbook When You Start Excel (97/2000/2001/2002/v. X/2003)

We recently discussed using your system's XLSTART folder when you want to customize the default template that Excel uses for new workbooks (in v. X, you use the Startup: Excel folder). We thought we should point out that it can be used to automatically open any workbooks when Excel starts. In fact, there are two folders that Excel checks for workbooks when you start the program. If any are found, Excel opens the files.

Your operating system affects the XLSTART folder's location, so the easiest way to access it is to use your operating system's built-in Find or Search feature. In addition to the XLSTART folder, you can specify another folder that Excel should check. To do so:

  1. Choose Tools | Options from Excel's menu bar
  2. Click on the General tab
  3. Enter the folder path in the At Startup, Open All Files In text box (in older versions of Excel, the Alternate Startup File Location text box.)
  4. Click OK

Go back