Office Apps Crashing

Fix Excel Closing Local Workbooks Without a Save Prompt

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

The user needs Excel to prompt them to save changes before closing local workbooks.

Fix Excel Closing Local Workbooks Without a Save Prompt
Product
Microsoft Excel
Device & OS
not provided
Scenario
Closing a locally stored workbook after making changes.
Observed behavior
Excel may close the workbook without asking to save, potentially losing unsaved changes.
Before you start

Create a test workbook on your computer, save it, and then make a new change so there is an unsaved edit to check. The Safe Mode and Office repair steps below apply to Windows.

Solution 1Recommended

Update Excel and test add-ins in Safe Mode

Use this method to check whether an outdated Office installation or a COM add-in is interfering with the save prompt.

1
Update Office

In Excel, select File > Account > Update Options > Update Now. Restart Excel after any updates are installed.

2
Start Excel in Safe Mode

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK.

3
Test the save prompt

Open your local test workbook, make a change, and close it using the window's Close button. Check whether Excel asks you to save.

4
Disable COM add-ins

If the prompt appears in Safe Mode, restart Excel normally. Select File > Options > Add-ins, choose COM Add-ins in the Manage list, and select Go. Clear the add-in checkboxes, then re-enable them one at a time and repeat the close test to identify the cause.

Update Excel and test add-ins in Safe Mode
Test more than one workbook: Repeat the test with another local workbook to see whether the behavior affects a specific file or Excel more broadly.
Free Microsoft Office alternative

Edit local spreadsheets with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and support for Microsoft Office formats make it easy to move existing files into WPS Spreadsheets.

Edit local workbooks in WPS SpreadsheetsOpen and save Microsoft Excel formats such as XLSXUse a familiar spreadsheet interfaceWork with existing Office files in a lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Excel ask me to save when I close a workbook?

Excel normally prompts when a workbook has unsaved changes. If it closes without prompting after an edit, test Excel in Windows Safe Mode by pressing Windows+R and entering excel /safe; an add-in or installation issue may be involved.

How do I find the add-in causing the problem?

If the prompt works in Safe Mode, open Excel normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage list and choose Go. Disable the add-ins, then re-enable and test them one at a time.

Where are Excel's AutoRecover settings?

Go to File > Options > Save. Enable Save AutoRecover information and, if available, Keep the last AutoRecovered version if I close without saving.

Can AutoRecover restore every unsaved change?

No. AutoRecover saves information at intervals, so changes made after the last recovery save may be lost. It also does not replace the normal save prompt.

How can I check which Excel version I have?

In Excel, select File > Account and look under Product Information. Include the version details if you contact Microsoft Support.