Automatically Open Excel File at Startup?
Yes, you can make Excel automatically open a specific file when the application starts, either by placing the file (or a shortcut to it) in the XLStart folder or by using the alternate startup folder setting. This article explains both methods, how to choose between them, common pitfalls, and how to revert the change.
How Excel’s Startup Folders Work
Excel checks two folders when it launches and opens every workbook found in them. The first is the XLStart folder, which is created during installation and is specific to your user profile. The second is an optional alternate startup folder that you can designate in Excel’s options. Files in either location open automatically, but they behave differently in subtle ways—for example, files in the alternate folder may not be fully trusted if macros are involved, and the XLStart folder is the only one that supports certain add-in behaviors.
You can also use a personal macro workbook (PERSONAL.XLSB) stored in XLStart, but that is a separate feature for storing macros, not for opening data files.
Method 1: Using the XLStart Folder (Simplest)
The XLStart folder is the most reliable way to auto-open a workbook. Here’s how to set it up on Windows (the process is similar on Mac, but the folder path differs).
- Find the XLStart folder path. In Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. The XLStart path is listed there (usually
C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART). - Copy the workbook you want to auto-open into that folder. You can also create a shortcut to the file and place the shortcut in XLStart—this keeps the original file in its current location.
- Restart Excel. The workbook should open automatically.
If you use multiple workbooks, just place all of them in the folder. Excel opens them in the order they appear in the folder (alphabetical on most systems).
Method 2: Using the Alternate Startup Folder
If you prefer not to clutter the XLStart folder, or if you want to easily change which files open without moving them, you can set an alternate startup folder.
- Go to File > Options &strong> Advanced.
- Scroll down to the General section.
- In the At startup, open all files in box, type the full path to a folder (e.g.,
C:\ExcelAutoOpen). - Click OK and restart Excel.
Every workbook saved in that folder will open when Excel starts. Note that this folder is separate from XLStart—files in both locations will open, with XLStart files opening first.
How to Choose Between the Two Methods
The main trade-off is convenience versus visibility. The XLStart folder is hidden deep in the AppData folder, so it’s easy to forget it exists. The alternate startup folder is user-defined, so you can put it somewhere obvious like your Documents folder. However, the alternate folder only opens files that are directly in it—it does not scan subfolders. Also, if you use the alternate folder, be aware that Excel may show a security warning for files in that location if they contain macros, because it is not a trusted location by default. You can add the folder to the Trusted Locations list to suppress that warning.
For most people, the XLStart folder is the better choice because it’s the default, it’s reliable, and it doesn’t require any extra configuration. Use the alternate folder if you want to switch between different sets of startup files frequently without moving files in and out of XLStart.
Common Problems and How to Fix Them
- File doesn’t open: Double-check the folder path. In XLStart, a shortcut to the file works, but the shortcut must not be broken. If you used the alternate folder, make sure the file is saved directly in that folder, not in a subfolder.
- Excel opens a blank workbook instead of your file: This can happen if the file is corrupted or if Excel is set to ignore the startup folder. Check File > Options > Advanced > General and ensure the “At startup, open all files in” box is not empty if you intend to use the alternate folder.
- File opens but with a protected view warning: This is common for files downloaded from the internet. Right-click the file, select Properties, and check the “Unblock” box if it appears.
- Macros don’t run: If your workbook contains macros, Excel may disable them because the file is not in a trusted location. Add the folder to Trusted Center settings, or digitally sign the macro.
How to Stop a File from Opening Automatically
To remove the auto-open behavior, simply delete the file or shortcut from the XLStart folder, or clear the alternate startup folder path in Excel options. If you have a file that opens but you don’t know why, check both locations. Also, check if the file is saved as an add-in (.xlam) in the Library folder on Mac, or if it’s in the \\AppData\Roaming\Microsoft\Excel\XLSTART folder on Windows. Sometimes a workbook is set to open automatically because it’s in the “Recent” list, but that only affects the file list, not actual opening.
Alternatives to Auto-Open
If you need a file to be ready when you start Excel but don’t want it to open automatically, consider these alternatives:
- Pin the file to the Recent list: Click File > Open, then hover over the file in the Recent list and click the pin icon. It stays at the top for quick access.
- Create a desktop shortcut: Right-click the file and choose Send to > Desktop (create shortcut). Double-click the shortcut to open Excel and the file together.
- Use a template: If you want a new file with preset formatting, save it as an Excel template (.xltx) in the Templates folder. Then choose New > Personal to use it.
Frequently Asked Questions
Does this work on Mac?
Yes, but the folder path is different. On Mac, the XLStart folder is typically at /Users/[username]/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel. You can also set an alternate startup folder in Excel > Preferences > General.
Can I open a file automatically only on certain days?
Not with the built-in startup folders. You would need a macro or a third-party automation tool to conditionally open a file based on the date.
What if I want to open a file but not run its macros?
If the file is in the XLStart folder, macros are typically enabled because that folder is trusted by default. If you want to open the file without macros, hold down the Shift key while starting Excel. This bypasses startup folders and disables macros in that session.
Will the file open in a new window every time?
By default, each workbook opens in a separate window within the same Excel instance. If you want them in the same window, you can use the “View Side by Side” feature, but that’s manual. There is no built-in option to change the default window behavior for startup files.
Can I make Excel open a file that is stored on a network drive?
Yes, you can place a shortcut to a network file in the XLStart folder, or set the alternate startup folder to a network path. However, if the network is slow or unavailable, Excel may hang or show an error. It’s generally better to keep startup files local.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.