Fix Excel Closing Local Workbooks Without a Save Prompt
Question details
The user needs Excel to prompt them to save changes before closing local workbooks.

- 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.
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.
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.
In Excel, select File > Account > Update Options > Update Now. Restart Excel after any updates are installed.
On Windows, close Excel, press Windows+R, enter excel /safe, and select OK.
Open your local test workbook, make a change, and close it using the window's Close button. Check whether Excel asks you to save.
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.

Repair Microsoft Office and check AutoRecover settings
Use these steps if the save prompt is still missing after updating Excel and testing add-ins.
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.

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.




