How to Fix Excel Templates Opening for Editing Instead of Creating New Workbooks
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.

- 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.
Verify that your Microsoft 365 applications are fully updated and check if this issue happens with all Excel templates or just specific ones.
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.
Copy your .xlt or .xltm template file to the following path: C:\Users\YourUserName\Documents\Custom Office Templates.
Launch the Microsoft Excel application from your Start menu.
Click on 'File', select 'New', click the 'Personal' tab, and click your template to create a new workbook.

Perform a Windows Clean Boot to Identify Conflicts
Determine if third-party background applications or company software policies are interfering with default file actions.
Contact Your Microsoft 365 Administrator
If multiple users in your company environment experience the same issue despite troubleshooting, advanced logs and Microsoft Support escalation are required.
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.

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.




