Fix Excel Personal Templates Not Showing in File > New
Question details
The user is unable to locate their custom Excel templates under the Personal tab when trying to create a new spreadsheet file.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to create a new spreadsheet from a previously saved custom personal template.
- Observed behavior
- The saved custom template does not appear in the File > New > Personal section, even if it seems to be saved in the correct folder.
Ensure that your template file is saved in the correct format (.xltx for standard templates or .xltm for macro-enabled templates) rather than a standard workbook (.xlsx) format.
Verify and Update the Default Personal Templates Location
The most common reason custom templates do not appear is a mismatch between where the file is physically saved and the directory Excel has set as the default personal template location.
Excel relies on a specific folder path to populate the 'Personal' tab. If your custom .xltx files are saved anywhere outside of this designated path, the application will not display them.
Open your workbook and go to File > Save As. Choose 'Excel Template (*.xltx)' from the file format dropdown menu.
Navigate to File > Options to open the Excel Options dialog box.
Click on the 'Save' tab in the left-hand pane of the options window.
Find the field labeled 'Default personal templates location' and carefully note or copy the exact folder path listed there.
Open your computer's File Explorer, navigate to that exact folder path, and move or copy your .xltx file into it.
Close and reopen Excel. Go to File > New > Personal, and your custom template should now be visible and ready to use.

Use WPS Office for Hassle-Free Custom Templates
If you frequently encounter issues managing templates and configurations in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free alternative with an intuitive template management system.
- 1. Download and Install: Get WPS Office for free from the official website and follow the simple installation wizard.
- 2. Open WPS Spreadsheet: Launch WPS Office and select 'Spreadsheet' from the home screen.
- 3. Access Free Templates: Click on 'New' to browse the extensive library of free templates, or click 'Custom' to manage your personal templates easily.

Frequently Asked Questions
Where is the default template folder located in Windows?
By default, Microsoft Office saves personal templates in 'C:\Users\[YourUsername]\Documents\Custom Office Templates'. You can verify this path in the Excel Save options.
Can I use an .xlsx file as a template?
While you can open an .xlsx file and save over it to reuse its layout, it will not appear in the 'Personal' templates section. You must save it strictly as an .xltx or .xltm file to use the native template feature.
What is the difference between .xltx and .xltm formats?
An .xltx file is a standard Excel template format that does not support macros. An .xltm file is a macro-enabled template used for spreadsheets that contain VBA (Visual Basic for Applications) code.
Why did my pinned templates disappear in Excel?
Pinned templates may disappear from your recent list if the underlying template file has been moved, deleted, or renamed. Ensure the template file remains in its original folder path.




