Office Settings & Configuration

Fix Excel Not Prompting to Save Changes When Closing a Workbook

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

Question details

The user wants Excel to prompt before closing a workbook with unsaved changes.

Fix Excel Not Prompting to Save Changes When Closing a Workbook
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.
Before you start

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.

Solution 1

Check AutoSave and test a local workbook

Use this test to determine whether automatic saving or the workbook location explains the missing prompt.

1
Check AutoSave

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.

2
Test a local copy

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.

Already-saved changes: Excel generally does not need to prompt if there are no unsaved changes when the workbook closes.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheets in a familiar interfaceUse a free, lightweight office suiteMove existing Office documents into a compatible workspace
microsoft office alternative - wps office

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.