In this guide, we are going to show you how you can open all files in a folder on startup. Excel allows selecting a specific folder to open the files in it automatically when Excel starts. This can be a project or template folder, or just a folder on the network used for collaboration.
Let’s take a look at the steps involved in opening all files in a folder on startup:
- Open a new workbook or an existing workbook
- Click on File in the Ribbon
- Click on Options to activate Excel Options window
- Activate the Advanced tab
- Scroll down to the General section
- Enter the path of your folder into the field next to At startup, open all files in:
Unfortunately, you need to enter the folder location as a string, since Excel doesn’t have a file selection window for this feature. Fortunately, Windows 10 has a feature that allows us the copy the folder location as a text. Here is how:
- Open the File Explorer and locate the folder that contains the files
- While holding down the SHIFT key, right-click on the folder
- Click on Copy as path
This will copy the path of the folder. You can now paste the folder path into the Excel Options to a startup folder.
- Excel opens only the files directly under the target folder, not those in the sub-folders.
- Only Excel files are opened. Other file types will be ignored.