'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Set a Custom Excel Startup Template in Windows
Question details
The user wants to configure Microsoft Excel 365 to automatically load a custom workbook template upon starting the application or creating a new file.
- Product
- Microsoft Excel 365
- Device & OS
- Windows
- Scenario
- Starting a new workbook or launching the Excel application for daily tasks.
- Observed behavior
- Excel does not automatically use the custom Book or Sheet templates when starting a new workbook, despite the user placing them in several different template and XLStart folders.
Ensure you have write permissions to your Windows AppData folder and verify that hidden files and folders are set to visible in your Windows File Explorer settings.
Save and Place Book.xltx in the Correct XLStart Folder
Save your custom template with the exact required name and file extension in the specific roaming AppData directory for Excel.
Excel requires specific file names (Book.xltx for workbooks and Sheet.xltx for worksheets) to recognize them as default templates automatically. Placing them in the correct user-specific XLStart folder ensures they load properly when you launch the app or press Ctrl+N.
Open your customized workbook in Excel. Click 'File' > 'Save As', select 'Excel Template (*.xltx)' from the file type dropdown, and name the file exactly 'Book.xltx'.
Open Windows File Explorer and navigate to: C:\Users\[YourUserName]\AppData\Roaming\Microsoft\Excel\XLSTART (replace [YourUserName] with your actual Windows username).
Move or save the Book.xltx file into this XLSTART folder. Close all active Excel windows and restart the application.
Once Excel is open, press the 'Ctrl+N' shortcut on your keyboard to generate a new workbook and verify that it uses your custom template formatting.
Remove Duplicate or Conflicting Templates
Clear out conflicting files from other startup folders to prevent Excel from getting confused when loading your preferred custom template.
Use WPS Office for Easy Template Management
If you are frustrated by Excel's complicated startup folder configurations, try WPS Office. It provides a lightweight, highly compatible alternative with a straightforward built-in template management system that makes standardizing your daily tasks effortless.
- 1. Download WPS Office: Download and install WPS Office for free from the official website to your Windows PC.
- 2. Access the Template Library: Launch WPS Spreadsheet and instantly access both local and premium online templates directly from the intuitive New Tab screen.
- 3. Save Custom Templates Easily: Format any document and simply choose 'Save As' > 'WPS Template (.ett)'. Your template will automatically be neatly organized in your personal Custom Templates folder for one-click access.
Frequently Asked Questions
Why does File > New > Blank Workbook ignore my Book.xltx template in Excel 365?
Depending on your Excel 365 deployment settings, the Start screen and the 'Blank Workbook' button under 'File > New' may use a hardcoded internal blank state rather than your Book.xltx. To reliably use your custom startup template, press Ctrl+N or disable the Start screen altogether in Excel's General Options.
Can I use an .xlsx file as my default Excel startup template?
No, Excel requires default startup files placed in the XLStart folder to be saved specifically in the Excel Template format (.xltx, or .xltm if it contains macros). Saving it as a standard .xlsx workbook will prevent the auto-load feature from working.
Where is the XLStart folder located in Windows 11?
For most Office 365 installations on Windows 11, the primary user-specific XLStart folder is located at C:\Users\[YourUserName]\AppData\Roaming\Microsoft\Excel\XLSTART. You may need to enable 'Show hidden files' in File Explorer's View menu to locate the AppData directory.
