Opening workbooks automatically

Excel 2016
If you work with the same workbooks every day, it will be helpful to open specific workbook files automatically whenever you start Excel. Any workbooks placed in the XLStart folder open automatically.

The location of the XLStart folder depends on the Windows configuration. To determine the location of the XLStart folder on your system, do the following:

   1.   On the File tab, click the Options button:

Excel 365 Options

   2.   In the Excel Options dialog box, on the Trust Center tab, click the Trust Center Settings... button:

Trast Center in Excel 365 Options

   3.   In the Trust Center dialog box, on the Trusted Locations tab, you will see a list of trusted locations:

Trast Center Locations in Excel 365

   4.   Look for the path for the location described as User StartUp. The path might look something like this:

C:\Users\<user name>\AppData\Roaming\Microsoft\Excel\XLSTART\

Another XLStart folder may be located here:

C:\Program Files\MSOffice\Office16\XLStart\

Any workbook files (excluding template files) stored in either of these XLStart folders open automatically when Excel starts. If one or more files open automatically from an XLStart folder, Excel won't start with a blank workbook.

Note: You can specify an alternate startup folder in addition to the XLStart folder, do the following:

   1.   On the File tab, click the Options button.

   2.   In the Excel Options dialog box, on the Advanced tab, scroll down to the General section and enter a new folder name in the At startup, open all files in field:

Start Up Location in Excel 365

Then, when you start Excel, it automatically opens all workbook files in both the XLStart folders and the alternate folder you specified.

See also this tip in French: Comment ouvrir les classeurs automatiquement.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.