Do you have a workbook (or workbooks) you, without a doubt, open every time you start up MS Excel?
Ever wish it would magically open on its own when Excel starts?
If that sounds like a good idea to you, I’ve got great news for you! That’s exactly what we’re going to go over today.
The first thing you need to do is create a folder that contains only the file(s) you want opened with Excel’s startup. (Be sure to note its location, because you’ll need that information again momentarily).
Now, we need to go to Excel’s Tools menu, Options choice.
In the Options window, you need the General tab.
Toward the bottom of this tab, we’re looking for the “At startup, open all files in:” field. In this field, enter the entire pathway to the location of the folder you created.
Then click OK.
That’s it. Next time you start your Excel, you’ll find your file automatically open and ready for editing, without any extra effort needed from you!