Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Before you start Microsoft Office Excel, you can make sure that a specific workbook or a workbook template or worksheet template that has custom settings opens automatically when you start Excel. If you no longer need a specific workbook to open, you can stop it from being opened when you start Excel. If a workbook that is opened when you start Excel contains automatic macros, such as Auto_Open, those macros will run when the workbook opens. If needed, you can prevent them from running automatically when you start Excel. Automatically open a specific workbook when you start Excel To automatically open a specific workbook when you start Excel, you can place that workbook in the XLStart folder, or you can use an alternate startup folder in addition to the XLStart folder. Locate the XLStart folder Any workbook, template, or workspace file that you place in the XLStart folder is automatically opened when you start Excel. To find out the path of the XLStart folder, check the Trust Center settings.

To do so: • Click File >Options. • Click Trust Center, and then under Microsoft Office Excel Trust Center, click Trust Center Settings. • Click Trusted Locations, and then verify the path to the XLStart folder in the list of trusted locations.

How to Reset and Clear All Items in Windows 7. Windows Recent AutomaticDestinations. Having to go to%appdata% microsoft windows recent. Appdata Microsoft Windows Recent Automaticdestinations Excel 2010. AppData Roaming Microsoft Windows Recent.%AppData% Microsoft Windows Recent.

Use an alternate startup folder • Click File >Options >Ek Second. Jo Zindagi Badal De. 2010. Advanced. • Under General, in the At Startup, open all files in box, type the full path of the folder that you want to use as the alternate startup folder. Because Excel will try to open every file in the alternate startup folder, make sure that you specify a folder that contains only files that Excel can open. Note: If a workbook with the same name is in both the XLStart folder and the alternate startup folder, the file in the XLStart folder opens. Stop a specific workbook from opening when you start Excel Depending on the location of the workbook that is automatically opened when you start Excel, do any of the following to make sure that the workbook no longer opens upon startup. • If the workbook is stored in the XLStart folder, remove it from that folder. • If the workbook is stored in the alternate startup folder, do the following.

Tip: You can also right-click that icon, click Properties, and then remove any references to the workbook on the Shortcut tab. Automatically open a workbook template or worksheet template when you start Excel You can save workbook settings that you frequently use in a workbook template, and then automatically open that workbook template every time that you start Excel. • Do one of the following: • To use a workbook template, create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting that you want to use in new workbooks that will be based on the workbook template. • To use a worksheet template, create a workbook that contains one worksheet.