Template Issues

How to Find and Set the Correct Location for Personal Excel Templates

Camila MilosovichCamila Milosovich Nov 3, 2026 870 views

Question details

The user needs to locate or configure the correct folder for personal Excel templates so they appear when creating a new workbook.

How to Set the Default Location for Personal Excel Templates
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.
Before you start

Ensure you know the exact folder path on your Windows 10 device where your custom Excel template (.xltx) is currently saved.

Solution 1Recommended

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.

1
Open Excel Options

Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Options' at the bottom of the left-hand menu.

2
Access Save Settings

In the Excel Options dialog box, click on the 'Save' tab located in the left pane.

3
Set the Template Location

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).

4
Apply and Restart

Click 'OK' to save your changes. Restart Excel, navigate to File > New, and click on the 'Personal' tab to access your templates.

Configure the Default Personal Templates Location
Using Shared Network Folders: Placing a template in a shared network folder does not automatically make it visible to all users. Each individual user must have network access to the folder and manually configure their 'Default personal templates location' to that specific shared path.
Manage Templates Easily in WPS Office

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. 1. Create Your Template: Design your spreadsheet in WPS Spreadsheet, setting up your preferred formatting, formulas, headers, and layouts.
  2. 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. 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.
100% compatible with Microsoft Excel template formats (.xltx, .xlt)Free, lightweight, and fast alternative to Microsoft 365Massive built-in premium template library to jumpstart your workFamiliar tabbed user interface for a seamless transition
microsoft office alternative - wps office

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.