Stop Excel from Opening an XLSM File at Startup
Question details
The user wants to prevent an XLSM workbook from opening automatically when Excel starts.

- 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.
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.
Move the XLSM Workbook Out of XLSTART
Use this method when the unwanted workbook is stored in Excel's user startup folder.
Close all open Excel workbooks and exit Excel.
On Windows, press Windows+R, enter %appdata%\Microsoft\Excel\XLSTART, and select OK.
In the XLSTART folder, find the unwanted XLSM file and move it to another folder, such as Documents.
Open Excel again and check that the XLSM workbook no longer opens automatically.

Check Excel's Alternate Startup Folder
Use this check if the XLSM file is not in the user XLSTART folder or still opens after you move it.
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.

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.




