Close the Startup folder, log off and then back on and watch your desired objects open. Thus, we do not to add the short cut in the Excel start up folder. To find the At startup, open all files in box in Excel 2003, click Options on the Toolsmenu, and then click the General tab.. To find the At startup, open all files in box in Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Advanced.The At startup, open all files in box is under General. When I run any Excel files, 4 other files are automatically opened at the same time. It is easy to make workbooks automatically. Hi, As far as I know, if we add the Excel file\template in Excel xlstart folder (C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart. ), it will automatically open the file\template when you start Excel. There are two methods and you can use anyone of them to open Excel sheet at startup in Excel 2013/2016. Run a Macro Automatically on Opening Excel Workbook – Solution(s): We can use Workbook_Open() method or Auto_Open() method to achieve this. Open another File Explorer window, navigate to the folder containing the file you use daily, select the file, and drag it to the XLSTART folder. How can I make this stop? Run a Macro Automatically – Example Cases: Following are the list of situations where we need to run a macro automatically on opening an excel workbook. Microsoft Word and Excel 2019 automatically opens upon startup I have installed ms office 2019 two days ago. When you start Excel, all the files that are located in the XLStart folder are automatically opened. I followed an instruction that said to copy & paste a shortcut to the file in the Excel Startup folder. Now use the right-click to drag the desired program file, folder, or document into the Startup folder and choose “Create shortcuts here” from the context menu. That’s it. Option Two: Use Your Own Folder Close the Startup folder, log off and then back on and watch your desired objects open. Re: Automatically open a form on startup. How to place shortcuts in the Startup folder. Open Excel Sheet at Startup in Excel 2013/2016. Here's how to open an Excel file automatically on boot up For those of us who use an Excel file frequently this procedure is a big help: First, put the Excel file or a shortcut to the file in your XLStart folder. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened. I want to automatically open an Excel file when I start Excel. Note. Next time you close an Excel file you could open Task Manager and see if Excel is still running. They will open automatically whenever Excel opens, opening after Add-ins but before other any workbooks. Now use the right-click to drag the desired program file, folder, or document into the Startup folder and choose “Create shortcuts here” from the context menu.