What should be in xlstart folder

The other is created if you go to Tools Options, General tab, and enter a location in the At startup Tip: Here's where the trouble starts. In prior versions of Excel, it was simply referred to as Alternate Startup folder, which could be very confusing, and people would enter My Documents and other paths in there.

Then, when Excel starts up the next time, it tries to open all those files. To find the At startup, open all files in box in Excel , click Options on the Tools menu, and then click the General tab. The At startup, open all files in box is under General. You typically use startup folders to load Excel templates and add-ins. You can also use startup folders to load workbooks. When you load the following types of files from a startup folder, the files have the important characteristics that are described in the following list.

If you save a workbook named Book. The add-ins are loaded in memory. The add-ins run any auto macros. You can use these add-ins by whatever method the add-in provides for example, a command on a menu or a button on a toolbar. For example, the personal macro workbook Personal. When you use the alternative startup file location, you must specify a file path where there are recognizable file types such as templates, add-ins, and workbooks.

Look for the path for the location described as User StartUp. The path might look something like this:. 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:. 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:.

Then, when you start Excel, it automatically opens all workbook files in both the XLStart folders and the alternate folder that you specified. See also this tip in French: Comment ouvrir les classeurs automatiquement. If you encountered a bug or want to suggest a feature in Microsoft Office, we recommend you contact Microsoft Support.