How to Find and Set the Correct Location for Personal Excel Templates
Question details
The user needs to locate or configure the correct folder for personal Excel templates so they appear when creating a new workbook.

- Product
- Excel
- Device & OS
- Windows 10
- Scenario
- Creating a new workbook using a previously saved custom Excel template.
- Observed behavior
- The custom Excel template does not appear under the Personal templates tab when navigating to File > New.
Ensure you know the exact folder path on your Windows 10 device where your custom Excel template (.xltx) is currently saved.
Configure the Default Personal Templates Location
Specify the exact folder path in Excel options to ensure your custom templates consistently appear under the Personal tab.
By default, Excel may leave the personal templates location blank. To make your custom templates accessible from the 'New' menu, you must manually point Excel to the specific folder where your templates are stored.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on the 'Save' tab located in the left pane.
Scroll down to the 'Save workbooks' section and locate the 'Default personal templates location' text box. Enter the exact folder path where your custom templates are saved (for example, C:\Users\YourName\Documents\Custom Office Templates).
Click 'OK' to save your changes. Restart Excel, navigate to File > New, and click on the 'Personal' tab to access your templates.

Create and Manage Custom Spreadsheet Templates with WPS Office
WPS Office provides an intuitive, user-friendly way to save, manage, and reuse custom spreadsheet templates without wrestling with complicated folder path configurations.
- 1. Create Your Template: Design your spreadsheet in WPS Spreadsheet, setting up your preferred formatting, formulas, headers, and layouts.
- 2. Save as a Custom Template: Click 'Menu' in the top left, select 'Save As', and choose 'WPS Spreadsheet Template (*.ett)' or 'Excel Template (*.xltx)' from the file type dropdown menu.
- 3. Access Your Templates Quickly: When opening WPS Spreadsheet, simply click 'New' and navigate to your custom templates or browse your local files to instantly load your saved layout.

Frequently Asked Questions
Why is my Personal templates tab missing in Excel?
The 'Personal' tab will not appear under File > New if the 'Default personal templates location' box in Excel Options > Save is completely empty. You must specify a valid folder path containing at least one template for the tab to generate.
Will putting a template in a shared network drive make it available to everyone automatically?
No. Simply placing a template in a shared folder is not enough. While the file is accessible, each user must individually configure their Excel 'Default personal templates location' settings to point to that specific shared network path.
What file format should I use when saving my custom Excel template?
You should save your workbook as an Excel Template (.xltx). If your workbook contains active macros that you need to retain, you must save it as an Excel Macro-Enabled Template (.xltm) instead.




