There are 2 file types use the .XLTM file extension:
- Excel Open XML Macro-Enabled Spreadsheet Template
- Microsoft Excel Macro-Enabled Spreadsheet Template
1. Excel Open XML Macro-Enabled Spreadsheet Template
Template file created by Microsoft Excel, a spreadsheet program; contains default settings and layout properties for a macro-enabled spreadsheet; used to create a new macro-Enabled workbook (.XLSM file) that uses the Open XML format, which was introduced in Microsoft Office 2007.
XLTM files can be opened in Excel 2007 or later for Windows, or by Excel 2008 or later for Mac. They may also be opened by previous versions of Excel with Open XML component support.
NOTE: The difference between XLTM and .XLTX files is that XLTX files cannot be used to generate spreadsheets that enable macros.
Updated: January 19, 2010
2. Microsoft Excel Macro-Enabled Spreadsheet Template
An XLTM file is a macro-enabled template created by Microsoft Excel, a spreadsheet application included in the Microsoft Office suite. It contains predefined settings and layout information, including one or more macros, used to create .XLSM or .XLSX files. XLTM files are used to quickly create spreadsheets using default formatting and properties.
You can open XLTM files in Microsoft Excel (Windows, Mac, iOS, Android). Excel 2007 and later versions can open XLSM files by default, and earlier versions can open XLSM files if you have installed the Microsoft Office Compatibility Pack. For security reasons, Excel does not enable XLTM files' macros by default. To enable macros in an XLTM file, clickwhen prompted.
After you open your XLTM file in Excel, you can either edit the template the XLTM file contains, or you can use the XLTM file to create a new spreadsheet.
While XLTM files are typically legitimate Microsoft Excel spreadsheet templates, they may also be used to distribute and execute malware attacks on victims' computers. To protect against malicious XLSM attacks, never open or enable macros within an XLSM file unless you can verify its legitimacy and source.
Updated: October 13, 2020