This tutorial is about the steps required to automatically open excel files under specified folder during the startup of Excel 2016 & 2013.
Step 1: Launch Excel 2013, click the File menu then Options.
Step 2: In the Options window, click the Advanced tab and scroll down to General section.
Step 3: In the General section, specify the folder for “At startup, open all files in”
For this demo, we are going with the folder “excel_projects” under C:\Users\RShankar\Documents.
Step 4: Click OK button to confirm and save the changes.
Now when you launch excel, all excel files under excel_project folder will be opened. Please make sure to save only excel files under the folder otherwise you might notice errors when excel tries open other file types.