Office Settings & Configuration

Stop Excel from Opening an XLSM File at Startup

Aamir Naveed AkramAamir Naveed Akram Nov 22, 2026 868 views

Question details

The user wants to prevent an XLSM workbook from opening automatically when Excel starts.

Stop Excel from Opening an XLSM File at Startup
Product
Microsoft Excel
Device & OS
not provided
Scenario
Excel starts with a macro-enabled workbook that the user does not want to open automatically.
Observed behavior
An XLSM workbook in an Excel startup folder can open automatically and appear to be the default workbook.
Before you start

Identify the name of the XLSM workbook that opens at startup. The folder path and Windows Run command below apply to Windows installations of Excel.

Solution 1Recommended

Move the XLSM Workbook Out of XLSTART

Use this method when the unwanted workbook is stored in Excel's user startup folder.

1
Close Excel

Close all open Excel workbooks and exit Excel.

2
Open the startup folder

On Windows, press Windows+R, enter %appdata%\Microsoft\Excel\XLSTART, and select OK.

3
Move the workbook

In the XLSTART folder, find the unwanted XLSM file and move it to another folder, such as Documents.

4
Restart Excel

Open Excel again and check that the XLSM workbook no longer opens automatically.

Move the XLSM Workbook Out of XLSTART
Keep other startup files: Move only the unwanted workbook. Files such as PERSONAL.XLSB may be used to store personal macros.
Free Microsoft Office alternative

Work with Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move everyday workbook tasks between applications. It does not change Excel's startup settings.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats including XLSX and XLSWork with spreadsheets without relying on Excel's startup foldersFree and lightweight for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does my XLSM workbook open whenever Excel starts?

The workbook may be in an XLSTART folder or in the folder specified under File > Options > Advanced > General as “At startup, open all files in.”

Where is the Excel XLSTART folder on Windows?

A common user location is %appdata%\Microsoft\Excel\XLSTART. Press Windows+R, enter that path, and select OK to open it.

Does moving the XLSM file delete it?

No. Moving it from XLSTART to another folder keeps the file available, but prevents that folder from causing Excel to open it at startup.

What if the workbook is not in my user XLSTART folder?

Check File > Options > Advanced > General for an alternate startup folder. Excel may also use an XLSTART folder in its installation location.

Should I move PERSONAL.XLSB out of XLSTART too?

Not unless you no longer want your personal macro workbook to load automatically. Move only the unwanted XLSM file if the goal is to stop that file from opening.