Message:Coronavirus (COVID-19)

Blog

How to Open Certain Workbooks Automatically When You Start Excel

February 4th, 2016 by Mark Daly in Industry News No Comments »
How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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”.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

How to Open Certain Workbooks Automatically When You Start Excel ilicomm Technology Solutions

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.

Leave a Reply

You must be logged in to post a comment.

NEED MORE INFORMATION?Contact us to see how we can help your business

Call our Sales Team on:

+44 (0)121 289 3434

or email us at:

hello@ilicomm.com