Fix an Excel Template That Opens the Original File
Question details
The user needs a shared macro-enabled Excel template to create a new workbook rather than open the original template for editing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Users open a macro-enabled template stored on a network drive to create new workbooks.
- Observed behavior
- Excel opens the original template file, which users could overwrite when saving.
Check that the shared file has the .xltm extension and note whether users open it directly or through a shortcut. Confirm your Excel version and ask whether the same behavior occurs for other users.
Test how the Excel template is opened
Compare the network template with a local copy and a newly created template to narrow down the cause.
In the network folder, double-click the .xltm file itself rather than a shortcut. Opening a template through Excel's File > Open command can open the template for editing instead of creating a workbook.
If users normally use a shortcut, compare its target and behavior with the .xltm file opened directly from the network folder.
Copy the .xltm file to a local folder, then double-click the copy. If it creates a new workbook locally but not on the network, investigate the network path or shortcut.
In Excel, create a blank workbook and use File > Save As to save it as an Excel Macro-Enabled Template (*.xltm). Close Excel, then double-click the test template to see whether it creates a new workbook.
If a new workbook opens, use File > Save As to give it a new name and location. Choose a macro-enabled workbook format if the new workbook needs to retain macros.

Update Excel and test for add-in conflicts
Use this approach when the problem also occurs with a local or newly created template.
Repair Office and isolate Windows startup conflicts
Try these Windows troubleshooting steps if the template still opens incorrectly after updating and testing add-ins.
Work with Spreadsheet Templates in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday spreadsheet work. It does not repair Excel's template-opening behavior, and macro-enabled templates should be tested for compatibility before migration.

Frequently Asked Questions
Why does Excel open my template for editing?
Opening an .xltm file through File > Open can open the template itself for editing. To test creation of a new workbook, double-click the template directly in its folder.
How can I tell whether the network shortcut is causing the problem?
Double-click the .xltm file directly in the network folder, then compare the result with opening it through the shortcut. Also test a local copy to help separate a network or shortcut issue from an Excel issue.
How do I create a new macro-enabled Excel template for testing?
Create a blank workbook in Excel, select File > Save As, and choose Excel Macro-Enabled Template (*.xltm). Close it, then double-click the saved template to test whether it creates a new workbook.
What should I do if the template works in Excel Safe Mode?
Restart Excel normally and check File > Options > Add-ins. Under Manage, select COM Add-ins and choose Go, then disable add-ins one at a time and retest.
Can WPS Office fix Excel's template-opening issue?
No. WPS Office is an alternative spreadsheet application, not a repair tool for Excel. Test any macro-enabled template and its macros for compatibility before relying on it in WPS.




