Office Apps Freezing

Fix Excel Workbooks That Will Not Close With the X Button

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 870 views

Question details

The user needs to close the active Excel workbook with the X button when multiple workbooks are open.

Fix Excel Workbooks That Will Not Close With the X Button
Product
Microsoft Excel
Device & OS
not provided
Scenario
Multiple Excel workbooks are open, and the user clicks the X button on the active workbook.
Observed behavior
The active workbook does not close until the first workbook is closed.
Before you start

Check whether a save prompt or other dialog is hidden behind an Excel window. The Safe Mode and Office repair instructions below apply to Excel on Windows.

Solution 1Recommended

Test Excel in Safe Mode and check add-ins

Use this method to identify add-ins or startup items that may interfere with closing workbooks.

1
Start Excel in Safe Mode

Close Excel, press Windows+R, enter `excel /safe`, and select OK. Open multiple workbooks and test the X button on the active workbook.

2
Disable COM add-ins

If the issue disappears in Safe Mode, restart Excel normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and click Go. Clear an add-in checkbox, click OK, and retest.

3
Check Excel add-ins

In File > Options > Add-ins, select Excel Add-ins in the Manage list and click Go. Disable add-ins one at a time and test closing multiple workbooks after each change.

4
Inspect startup settings

Go to File > Options > Advanced > General and check the folder listed under 'At startup, open all files in.' Also inspect Excel's XLSTART folder and any custom startup macros for items that could affect closing workbooks.

Test Excel in Safe Mode and check add-ins
Identify the cause: If disabling an add-in resolves the issue, leave it disabled and check with its publisher for an update. Safe Mode is a diagnostic test; it does not permanently fix the cause.
Free Microsoft Office alternative

Open and Edit Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its support for Excel formats makes it easier to move existing workbooks into WPS, although it does not repair Microsoft Excel.

Open and edit multiple workbooks in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I start Excel in Safe Mode?

On Windows, press Windows+R, enter `excel /safe`, and select OK. Open multiple workbooks to see whether the X button works.

What should I do if the workbook closes normally in Safe Mode?

Restart Excel normally and go to File > Options > Add-ins. Use the Manage list to check COM Add-ins and Excel Add-ins, disabling them one at a time and retesting.

Where can I check files that open automatically with Excel?

Check File > Options > Advanced > General for the 'At startup, open all files in' folder. Also inspect Excel's XLSTART folder and any custom startup macros.

Will repairing Office delete my workbooks?

Office repair is intended to fix the Office installation, not delete personal workbooks. In Windows Settings, go to Apps > Installed apps, select Microsoft 365 or Office, and choose Modify to access repair options.