Automatically opening selected files when starting Excel

I ran across this tip today at site – Open A Specific Workbook Every Time Excel Starts. It shows how you can set up Excel to automatically open all the spreadsheet files in a particular folder when you start Excel. Here’s how that works…

In my Documents folder on my C: drive, I created a folder called ExcelFileOpenAtStartup. In that folder, I have three spreadsheet files that I want to have open up automatically every time I launch Excel:

To set that up, I go to File > Options > Advanced, and in the General section I have the At startup option. I copied the link to the start-up folder I created in the above step, and then click OK:

Now when I open Excel, those three spreadsheets open automatically!

This is a great feature for someone who has a group of spreadsheets that they use every day, and they want to have them open up without trying to find each one individually.

I recommend checking out the link to this tip at for a few other tweaks you can make to this setup, such as putting file shortcuts in the Startup folder so that you can have spreadsheets stored in different areas still open up automatically without moving them to a new location. also has a newsletter you can sign up for to get tips like these on a regular basis. I highly recommend it!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s