Template Issues

How to Fix Excel Templates Opening for Editing Instead of Creating New Workbooks

Tauseeq MagsiTauseeq Magsi Nov 3, 2026 869 views

Question details

Users need to generate a new workbook from an Excel template, but double-clicking the file opens the original template for editing instead.

How to Fix Excel Templates Opening for Editing Instead of New Workbooks
Product
Microsoft Excel
Device & OS
Windows
Scenario
Double-clicking an .xlt or .xltm file in Windows File Explorer to start a fresh spreadsheet project.
Observed behavior
The application opens the template file in edit mode, risking accidental overwrites, rather than generating an unsaved, new workbook based on the template.
Before you start

Verify that your Microsoft 365 applications are fully updated and check if this issue happens with all Excel templates or just specific ones.

Solution 1Recommended

Open the Template Directly from the Excel App

Bypass Windows file association issues by storing the template in the correct directory and opening it directly from within Excel.

When double-clicking a file from the desktop or server fails to trigger the 'New' action, using the built-in File menu ensures Excel handles the template correctly.

1
Move the template file

Copy your .xlt or .xltm template file to the following path: C:\Users\YourUserName\Documents\Custom Office Templates.

2
Open Excel

Launch the Microsoft Excel application from your Start menu.

3
Create from template

Click on 'File', select 'New', click the 'Personal' tab, and click your template to create a new workbook.

Open the Template Directly from the Excel App
Best Practice: Storing custom templates in the default 'Custom Office Templates' folder prevents syncing and permissions issues common on shared servers.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet and Template Management

If Microsoft Excel continues to experience file association or environment conflicts, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing workbooks and templates without the complex background issues.

Highly compatible with Microsoft Excel formats including .xlsx, .xlt, and .xltmFree and lightweight alternative to Microsoft 365Built-in professional template library for instant productivityFamiliar user interface ensuring easy migration
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel template open as a template instead of a new document?

This generally happens due to incorrect Windows file associations, where the default double-click action is set to 'Open' rather than 'New', or due to background software conflicts preventing Excel from creating a new instance.

Where is the default location for personal Excel templates?

By default, personal custom templates in Windows should be stored in C:\Users\YourUserName\Documents\Custom Office Templates.

How do I force an Excel template to open as a new workbook?

Instead of double-clicking the file in File Explorer, launch the Excel application directly. Go to 'File' > 'New', select the 'Personal' tab, and choose your template from there.

Are .xlt and .xltm files different?

Yes. The .xlt format is the older Excel 97-2003 template format, whereas .xltm is a modern, macro-enabled template format used by newer versions of Excel.