February 7, 2017
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)
If you missed my last newsletter, you can click here to view it online.
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.
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;.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630