Office Settings & Configuration

How to Fix Excel Saving New Workbooks as XLSM Instead of XLSX

Elise WilliamsElise Williams Oct 29, 2026 873 views

Question details

User wants to configure Excel to save new workbooks as standard .xlsx files instead of defaulting to the macro-enabled .xlsm format.

How to Fix Excel Saving New Workbooks as XLSM Instead of XLSX
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating and saving a new workbook in Microsoft Excel.
Observed behavior
Excel automatically suggests the .xlsm (macro-enabled) format when saving a new workbook, overriding the standard default settings.
Before you start

Ensure you have closed all active Excel windows and know how to view hidden folders on your operating system to access the AppData directory.

Solution 1Recommended

Replace the Macro-Enabled Template in the XLSTART Folder

The primary cause of this issue is a hidden macro-enabled template (Book.xltm) stored in your Excel startup folder that overrides the standard format.

When Excel launches, it automatically loads any templates found in the XLSTART directory. If a custom macro template named Book.xltm is present, Excel assumes all new files should be based on this macro-enabled document, forcing the default save type to .xlsm.

1
Locate the XLSTART folder

Open File Explorer and navigate to your XLSTART folder. The path is typically C:\Users\[Your Username]\AppData\Roaming\Microsoft\Excel\XLSTART.

2
Open the overriding template

Look for a file named Book.xltm in this folder. Double-click to open it fully in Microsoft Excel.

3
Save as a standard template

In Excel, click 'File' > 'Save As'. Choose 'Excel Template (*.xltx)' from the format dropdown, name the file Book.xltx, and save it in the same XLSTART folder.

4
Remove the old template

Close Excel completely. Return to the XLSTART folder in File Explorer and delete the old Book.xltm file.

5
Verify the fix

Restart Excel and create a blank workbook. Click 'Save' to confirm that the default file format is now the standard .xlsx.

Replace the Macro-Enabled Template in the XLSTART Folder
Default format restored: By removing the .xltm extension template, Excel will revert to relying on its default core configuration for new workbooks.
Efficient Spreadsheet Tool

Easily Configure Default Save Formats in WPS Spreadsheets

If Excel's complex template structures are causing workflow interruptions, try WPS Office. It offers a highly intuitive settings menu that lets you quickly define default workbook save formats without digging through hidden system startup folders.

  1. 1. Access WPS settings: Launch WPS Spreadsheets, click the main 'Menu' button located in the top-left corner, and select 'Options'.
  2. 2. Open general save settings: In the Options dialog window, click on the 'General and Save' tab on the left panel.
  3. 3. Set your default format: Find the 'Save as default format' dropdown menu and select 'Microsoft Excel 2007-New Workbook (*.xlsx)'.
  4. 4. Save changes: Click 'OK' to apply. Every new workbook you create in WPS Office will now default to your chosen format automatically.
Easily configure your default workbook save formats directly from the primary settings menu.Offers outstanding compatibility with Microsoft Excel's .xlsx, .xls, and .xlsm formats.100% free, lightweight, and loads your spreadsheets in seconds without lag.
microsoft office alternative - wps office

Frequently Asked Questions

What is an XLSM file in Microsoft Excel?

An XLSM file is a macro-enabled spreadsheet created by Microsoft Excel. Unlike a standard XLSX file, it contains embedded VBA (Visual Basic for Applications) macros that are used to automate repetitive tasks.

Where is the XLSTART folder located?

The XLSTART folder is usually located at C:\Users\[Your Username]\AppData\Roaming\Microsoft\Excel\XLSTART. Any templates or workbooks stored in this folder are loaded automatically each time you open Excel.

Why did a Book.xltm file get placed in my startup folder?

A Book.xltm template is typically created when a user, an add-in, or a third-party application saves a customized template containing macros and places it in XLSTART to ensure those specific macros are available in every new workbook.

Will deleting Book.xltm affect my existing macros?

No. Deleting or replacing the Book.xltm template only impacts the default layout and formatting of blank, newly created workbooks. Your existing .xlsm files and the macros saved within them will remain completely unaffected.