- PiGuy314 reminded us that you can configure Excel to open all files in a specific directory by choosing Options from the Tools menu, clicking the General Tab, and specifying a directory using the At Startup Open All Files In option. Whether you store one or several workbooks in the directory, Excel will open them when you launch. Be careful when you choose this option as Excel will attempt to open all files, not just Excel workbooks. In addition, it'll cycle through any subfolders as well.
- Mihamil suggested saving workbook files in the XLSTART directory — another excellent solution.
- Mhbaum suggested using the Run command, which is a great tool that I forget about.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.