This will show you all the trusted locations (including the Excel StartUp location)
In the Excel Options dialog box, click on Trust Center (in the left pane of the dialog box).Open a new workbook or an existing workbook.So, if you want a specific Excel workbook (or even multiple workbooks) to open when Excel starts, you need to place this workbook in this XLStart folder.Īnd to do this, you first need to know where to find this XLStart folder.īelow are the steps to get the path of the XLStart folder: There is an XLStart folder in your system that determines which files to open when Excel starts.īy default, this folder is empty, which is the reason that you see a start screen or a blank workbook when you start Excel. Open a Specific Workbook when Excel Starts Now when you start Excel from now on, it will open a blank workbook and not show the start screen. Scroll down and in the ‘Start up options’ and uncheck the one that says – ‘Show the start screen when this application starts’.In the Excel Options dialog box, make sure General is selected in the left pane.Start Excel and open a new workbook by clicking on Blank workbook in the start screen (or you can open any existing saved workbook).When you enable this option, whenever you start Excel, it will open a new blank workbook. So let’s quickly go through the different options and learn how you can customize Excel startup. Note: This behavior of showing start screen on startup has become a default from Excel 2013 onwardsįrom the start screen, you can choose to open a new workbook or you can choose from the existing templates in Excel (there are some useful templates on this list).Įxcel allows you to customize the startup behavior where you can specify if you want to open a new blank workbook (instead of the start screen), or a specific Excel file, or even all the files in a specific folder. When you start Excel, the default behavior is that it opens the start screen that shows the recent workbooks and templates (as shown below). Start Excel and open all the Excel files in a folder.Start Excel and open a specific workbook or template.Start Excel and show the start screen (or open a blank workbook).With Excel, you can customize the startup behavior to: Open Related Excel Files When you Open a Specific Workbook (using VBA)Īutomatically Open Files When You Start Excel.Open Excel Files Automatically When You Start Your Computer/Laptop.Prevent Excel Files from Opening Automatically.Open Workbook/Worksheet Templates when Excel Starts.Automatically Open Workbooks in a Specific Folder.Open a Specific Workbook when Excel Starts.Automatically Open Files When You Start Excel.
0 kommentar(er)
