How to Make a Custom Excel Template Load Automatically from XLSTART
Question details
The user needs a custom Excel template (.xltx) to load automatically for all new workbooks using the XLSTART folder.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting up a customized template with specific styles and formatting to act as the default blank workbook whenever the application is launched.
- Observed behavior
- The custom template placed in the XLSTART folder or custom template folder is ignored, and new workbooks continue to load with the default system formatting instead of the custom styles.
Ensure you have file explorer permissions to access hidden AppData folders, and save any unsaved workbooks before restarting the application to apply the new template settings.
Rename the Template to the Default Localized Name
To force Excel to use your custom template from the XLSTART folder, the file must be named exactly according to the default workbook name for your installed language.
Placing an .xltx file in the XLSTART directory is not enough on its own. The application relies on a strict, language-dependent file name to recognize which file should override the default blank workbook. Custom names (like MyTemplate.xltx) will be ignored by the startup sequence.
Open File Explorer and navigate to the directory where you saved your customized .xltx template file.
Right-click the template file and select 'Rename'. Change the file name exactly to 'Book.xltx' if you are using the English version of the software.
If your software is installed in a language other than English, use the localized default workbook name. For example, rename it to 'Libro.xltx' for Spanish or 'Livre.xltx' for French.
Copy or move the correctly named template file into your XLSTART folder. The typical path on Windows is C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART.
Close all active instances of the spreadsheet application. Reopen the program and click on 'Blank workbook' (or press Ctrl+N) to verify that your custom template styles are successfully applied.

Easily Set a Default Custom Template in WPS Spreadsheets
Instead of navigating hidden system folders like XLSTART and worrying about language-specific file names, WPS Spreadsheets allows you to easily save and apply custom templates directly from the user interface. Enjoy a lighter, faster spreadsheet experience that is fully compatible with Microsoft Excel formats.
- 1. Create your custom layout: Open WPS Spreadsheets, set up your preferred cell formats, fonts, margins, and adjust column widths to your liking.
- 2. Save as a template: Click the 'Menu' button in the top left, select 'Save As', and choose 'WPS Spreadsheets Template (*.ett)' or 'Excel Template (*.xltx)'. Save it to an easily accessible location.
- 3. Open the template manager: Click on 'Menu' > 'New' and select 'New from Other Templates' to access the built-in template management interface.
- 4. Set as the default template: Locate your newly saved custom template in the local templates section, right-click its thumbnail, and select the option to set it as the default template for all new workbooks.

Frequently Asked Questions
Where is the XLSTART folder located on Windows?
The XLSTART folder is typically found at `C:\Users\[Your Username]\AppData\Roaming\Microsoft\Excel\XLSTART`. If you use a 32-bit version of Office on a 64-bit machine, there may also be a secondary folder at `C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART`.
Can I put an .xlsm macro-enabled file in the XLSTART folder?
Yes, you can place macro-enabled templates (.xltm) or workbooks (.xlsm) in the XLSTART folder. However, to act as the default blank workbook, the template generally needs to be named correctly, such as Book.xltm.
Why is my Book.xltx opening in Protected View?
Files in the XLSTART folder might open in Protected View if the directory isn't designated as a Trusted Location. Go to Options > Trust Center > Trust Center Settings > Trusted Locations, and add your XLSTART folder path to resolve this.
What happens if I put multiple files in the XLSTART folder?
The application will automatically attempt to open every valid spreadsheet file located in the XLSTART folder each time you launch the program. To avoid multiple windows popping up unnecessarily, only keep your single required startup template inside this folder.




