How to Open Certain Workbooks Automatically When You Start Excel

00_lead_image_auto_open_spreadsheet

If you use a few Excel spreadsheets daily, it would be handy if you could open those spreadsheets automatically every time you start Excel. Thankfully, Excel has this feature built-in–if you know where to look.

For example, maybe you open a time sheet file every day to keep track of your hours as you work on projects. Excel created a folder called XLSTART when you installed the program. Any file you place in this folder will open automatically when you start Excel. We’ll show you how to find out the location of this folder, as well as how to define an additional custom folder into which you can also place files you want opened automatically.

Option One: Use Excel’s Built-In XLSTART Folder

To start, open Excel and click the File tab.

01_clicking_file_tab

On the backstage screen, click “Options” in the list of items on the left.

02_clicking_options

The “Excel Options” dialog box displays. Click “Trust Center” in the list of items on the left.

03_clicking_trust_center

In the “Microsoft Excel Trust Center” section, click “Trust Center Settings”.

04_clicking_trust_center_settings

On the “Trust Center” dialog box, click “Trusted Locations” in the list of items on the left.

05_clicking_trusted_locations

A list of default locations in Excel displays under “Trusted Locations”. Click on the “User StartUp” location under “User Locations”.

06_clicking_user_startup_location

The full path to the selected location displays below the list of locations. This is the folder Excel will scan for files to open every time it starts. You can either make a note of the path yourself or you can copy the path, by clicking “Modify”.

07_noting_path_to_xlstart

If you clicked “Modify” to copy the full path, the “Microsoft Office Trusted Location” dialog box displays. Select the path in the “Path” edit box on the “Microsoft Office Trusted Location” dialog box and press Ctrl+C to copy it. To close all the dialog boxes and return to the main Excel window, click “OK” or “Cancel” on the current dialog box, and on the “Trust Center” and “Excel Options” dialog boxes.

08_copying_path

Then, open File Explorer (or Windows Explorer in older versions of Windows), put the cursor in the address bar, and paste the path you copied. Press “Enter” to go to the folder.

09_pasting_path_in_explorer

Now, we need to copy the file we want to add to this folder. Open another File Explorer window, navigate to the folder containing the file you use daily, select the file, and drag it to the XLSTART folder.

This file will now open automatically every time you start Excel.

10_file_pasted

Option Two: Use Your Own Folder

If you would rather Excel scan a different folder to open files at start–say, a folder you created in your Documents–you can do so. Access the “Excel Options” dialog box as described earlier in this article and click “Advanced” in the list of items on the left.

11_clicking_advanced

Scroll down to the “General” section, and enter the full path to the folder you want to use in the “At startup, open all files in” edit box. Click “OK” to accept the change and close the “Excel Options” dialog box.

12_at_startup_open_all_files_in

Now, when you start Excel, any files you placed in the XLSTART folder and the alternate folder you defined are opened automatically, even when you double-click on another Excel file to open the program. The files in the XLSTART and the alternate folders will open first, and then the file you double-clicked.

If you don’t want to open the files in these folders automatically anymore, simply move the files out of these folders. For example, you may want to replace your time sheet file with a current one at the beginning of each pay period so you always have access to your current time sheet.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.