Fix Excel Not Prompting to Save Changes When Closing a Workbook
Question details
The user wants Excel to prompt before closing a workbook with unsaved changes.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Closing an Excel workbook after making changes.
- Observed behavior
- Excel closes the workbook without displaying the usual save-changes prompt, while Word behaves normally.
Check whether the workbook is stored locally or in OneDrive or SharePoint, and note whether AutoSave is on. The Safe Mode and Office repair steps below apply to Windows.
Check AutoSave and test a local workbook
Use this test to determine whether automatic saving or the workbook location explains the missing prompt.
Open the workbook in Excel and look for the AutoSave toggle near the top of the window. If the file is in OneDrive or SharePoint and AutoSave is on, changes may already be saved, so a closing prompt may not appear.
Use File > Save As to save a copy to a local folder. Make a visible change in a cell, then close the workbook and check whether Excel asks you to save it.
Test Excel in Safe Mode and disable add-ins
Use Safe Mode on Windows to check whether an add-in is interfering with the save prompt.
Update or repair the Office installation
Try this if the prompt is still missing after checking AutoSave and add-ins.
Work with Excel workbooks in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet for an easy transition, although it will not repair Excel's save-prompt behavior.

Frequently Asked Questions
Why doesn't Excel ask me to save a workbook stored in OneDrive?
If AutoSave is on, Excel may have already saved your changes. Check the AutoSave toggle near the top of the workbook window.
How can I tell whether an Excel add-in is causing the problem?
On Windows, press Windows + R, enter excel /safe, and select OK. If the prompt works in Safe Mode, check add-ins under File > Options > Add-ins.
Should Excel prompt if I haven't changed anything?
No. Excel generally prompts when there are unsaved changes, so make a visible cell edit before testing the close behavior.
What if the issue happens only with one workbook?
Test a different local workbook. If only one file is affected, check its AutoSave status and whether it contains macros or other automation that controls closing.





