Automatically opening selected files when starting Excel

I ran across this tip today at TheExcelAddict.com 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 TheExcelAddict.com 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.

TheExcelAddict.com 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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s