File Open With Startup
Do you have a workbook that must be opened first thing everyday when you start up MS Excel?
Wouldn’t it be nice if Excel would simply open that file for you when you first start the program?
If you’re thinking that this would save you time each day, then maybe this is the tip you’ve been waiting for.
There’s no special setting in Excel and nothing fancy to do. The whole trick is simply where you save the file.
When Excel starts, it looks in the XLStart folder. If a file is in there, it is opened as the program starts up. There’s no ifs, ands or buts about it.
So, to have your special file(s) open as the program starts, simply locate your XLStart folder and save the file to that location. (While each computer system is unique, I can say that my XLStart folder was located at C:\Program Files\Microsoft Office\Office10. This may be enough to give you a direction to head in when trying to locate your folder).
Keep in mind that the file is now stored in the XLStart folder, so any older versions of the file located elsewhere will not be updated when you save. Only the file in the new location is updated each time since it’s the one the program that actually opens.
Yep, that’s really it. A quick save as to the XLStart folder is all it takes.
Now, I do have a couple of quick notes on this one.
First, this trick works with multiple files. You don’t have to pick the most important one. If there are two or three files in XLStart, it will open all of them.
Next, for those of you who are file backup minded and are afraid that you’ll forget to backup the ones in this out-of-the-way location, I’ve got a way around the problem. I found that I could accomplish this same trick using shortcuts to the files. Simply create a shortcut to the file in its original location, then move the shortcut into the XLStart folder.
That should do it. Just another way to take control of your own Excel universe.