Power BI Webinar

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 7, 2017

Greetings from The Excel Addict

Hi fellow Excel Addict,

In today's 'Excel in Seconds' tip, I'm going to show you how to 'Open One or More Specific Workbooks Every Time Excel Starts'.

If you missed my last 'Excel in Minutes' tip, 'Quickly Fix Inconsistent Data in Multiple Cells', you can read it here now.

Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)

Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"I expect to pass through life but once.
If, therefore, there be any kindness I can show,
or any good thing I can do for any fellow being, let me do it now,
and not defer or neglect it, as I shall not pass this way again."

-- William Penn --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with TheExcelAddict.com

Open One or More Specific Workbooks Every Time Excel Starts

Many Excel users start each workday using one or more specific workbooks, such as a ToDo list or a calendar we've created.

Startup Workbook in Microsoft Excel 2007 2010 2013 2016 365
Maybe you've already added shortcuts to your Desktop to make opening these workbooks easier.

If you would like these workbooks to open automatically every time Excel launches, there are two locations where you can store these workbooks (or shortcuts to them). One is the 'alternate startup folder and the other is the XLSTART folder.

Option 1: Designate an alternate startup folder

1) From the File tab click Excel Options and Advanced;
2) Scroll down to the General section and look for 'At Startup, open all files in:';
3) Type the full path of the folder that you want to use as the alternate startup folder and click OK;.

Use an Alternate Startup Folder in Microsoft Excel 2010 2013 2016 365
4) Move any workbooks into this folder that you want to open each time Excel starts. Or, rather than moving a workbook to this folder, you can put a shortcut (i.e. right click, New, Shortcut) that links to a workbook in different folder

NOTE: If you have a workbook with the same name in both the XLSTART folder and the alternate startup folder, only the file in the XLSTART folder will open.

Option 2: Use your XLSTART folder

What the heck is an XLSTART folder? The XLSTART folder is a special folder that Excel uses to hold files that need to be opened every time Excel starts.

The location of this folder on your computer depends on the version of Excel and operating system you are using. If you don't know where your XLSTART folder is located, open Windows Explorer and search (CTRL+F) for XLSTART.

My computer has Windows 8.1 and my XLSTART folder is located  at...

If you want you can move the workbook files themselves into the XLSTART folder or you can use shortcuts. To add a shortcut, just right click in the XLSTART folder and choose New, Shortcut, and browse to the workbook you want to add.

When you are finished, close and reopen Excel and you will see that the workbooks open automatically.

If you've found this tip helpful, please click here to share it.

Click here to get more tips like this every week

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630