How to Close Excel Without Saving Changes

How-to basics · Updated November 20, 2026

To close Excel without keeping your latest edits in the desktop app, close the workbook or exit Excel, then choose Don’t Save when prompted. This discards changes made since the last save. If AutoSave has already synced those changes to OneDrive or SharePoint, closing the file may not undo them; see the troubleshooting section for recovery options.

These steps are for Excel for Microsoft 365 on Windows. Before you start, check that you have the correct workbook open and understand which edits you want to discard. The same choice can remove many changes at once, and the discard action is not reliably reversible.

What You’ll Need

  • The Excel workbook you want to close, open in the desktop app.
  • A moment to check whether the file is local or stored on OneDrive or SharePoint, where AutoSave may have already saved edits.

Step-by-Step

  1. Check the workbook and its save status. Look at the workbook name in the title bar and confirm it is the file you intend to close. If the file is stored in OneDrive or SharePoint, look for the AutoSave switch near the upper-left corner of the Excel window. If it is on, some recent changes may already be saved. A cloud icon or a message such as Saved can also indicate that syncing has taken place, though the exact indicator can vary. If you need to preserve any new work, save a copy before proceeding.
  2. Decide whether to close only the workbook or all of Excel. To close the current workbook, press Ctrl+W or click the workbook window’s X in the upper-right corner. If you have several workbooks open, make sure the active one is the file you mean to discard; Excel may remain open with the other workbooks. To exit Excel entirely, press Alt+F4 on Windows or click the Excel window’s X. The same save prompt can appear either way.
  3. Wait for the save prompt. If Excel detects changes that have not been saved, it asks whether to save them before closing. The options usually include Save, Don’t Save, and Cancel. Read the workbook name in the prompt if one is shown. Don’t Save is the option that closes the workbook without retaining those unsaved edits; Cancel returns you to the workbook.
  4. Choose Don’t Save. Click Don’t Save to discard the changes made since the last save and close the workbook. Do not choose Save if your goal is to discard edits. If you are unsure, choose Cancel first, inspect the workbook, and then close it again when you are certain. A new workbook that has never been saved may show a slightly different prompt, but the discard option still closes it without creating a saved file.
  5. Confirm the result. Check that the workbook window has closed. If Excel is still open, that is normal when you closed only one workbook or have others open. If you exited the app, Excel should close. If a second prompt appears for another workbook, decide separately whether to save or discard that file; don’t assume the first choice applies to every open workbook.
  6. Use the Mac equivalent when needed. In Excel for Mac, press Command+W to close the active workbook window, or use Command+Q to quit Excel. When a save prompt appears, choose Don’t Save to discard unsaved changes. Closing a window and quitting the app are different actions on Mac, just as closing a workbook and exiting Excel are different on Windows.
  7. Handle Excel for the web differently. Excel for the web generally saves changes to OneDrive or SharePoint automatically. Closing the browser tab is not a dependable way to discard edits, and you may not get the desktop app’s Don’t Save prompt. If you have only just made an unwanted edit, try Undo while the workbook is open. If the changes have already been saved, use version history if it is available for the file, or ask the file owner or administrator about restoring an earlier version.

Common Mistakes

Clicking Save by habit. Save keeps the current edits, so it does the opposite of what you want. Pause at the prompt and check that you are selecting Don’t Save. If you accidentally save, don’t make more edits while you consider recovery options; additional changes can make it harder to identify the version you need.

Assuming the X always exits Excel. In a setup with multiple open workbooks, closing one workbook can leave the Excel application running. That does not mean the discard failed. Check whether another workbook remains open, and close it separately only if you intend to.

Confusing AutoRecover with AutoSave. AutoRecover is intended to help recover work after an unexpected shutdown; it is not a control that guarantees edits will be discarded. AutoSave can sync edits to cloud storage while you work. Choosing Don’t Save discards pending changes in the desktop workbook, but it cannot reliably reverse changes that have already been synced.

Choosing Cancel and expecting Excel to close. Cancel means stop the closing process and return to the workbook. It is useful if you need to inspect the file or save a copy, but you must close it again and choose Don’t Save to discard the edits.

Discarding the wrong workbook. If several files are open, the prompt may refer to a different workbook than the one you had in mind. Read the file name carefully. If it is unclear, cancel the prompt and use the workbook tabs or window list to check which file is active.

Tips

When you might need some edits later, save a separate copy instead of choosing between keeping everything and discarding everything. Use File > Save As to create a copy with a different name or location, then close the original and choose Don’t Save if its unsaved changes should be removed. This is especially useful for a workbook that contains both useful work and temporary experiments.

For cloud workbooks, check AutoSave before making changes you may want to throw away. Turning AutoSave off can prevent subsequent edits from syncing automatically, but it does not roll back edits that were already saved. If you turn it off, save deliberately when you do want to keep changes, and be mindful that other people may be editing a shared workbook too.

If you are closing Excel because it is frozen, give it a moment to respond before using force quit or ending the task. A forced shutdown can lose unsaved work, but it may also leave a recovery copy to review when Excel starts again. If Excel displays a recovery pane on reopening, inspect recovered files carefully rather than assuming they represent the version you wanted to keep.

For important files, consider keeping a dated backup before making a risky batch of edits. A backup gives you a clear fallback without relying on the closing prompt, AutoRecover, or cloud version history. Avoid overwriting the only copy when you are unsure which version contains the correct data.

Troubleshooting

No save prompt appears. Excel may not detect any unsaved changes, or the changes may already have been saved. If the workbook closes and you later see the edits in the file, check whether it is a cloud workbook with AutoSave enabled. Use version history to look for an earlier saved version, if your OneDrive or SharePoint permissions and retention settings allow it. For a local file, check whether you have a backup or another copy; closing again will not necessarily undo a completed save.

The prompt has no Don’t Save option. Read the full message before choosing. A prompt may be asking about a different issue, such as a file format or a feature that cannot be stored in the current format. If you are uncertain, choose Cancel and return to the workbook. You can then use File > Save As to make a separate copy in a suitable format, or investigate the message before closing.

Excel keeps asking about another file. You may have more than one workbook open, and each can have its own unsaved changes. Decide for each prompt whether to save or discard that particular workbook. If the workbook name is not clear, cancel, switch to the relevant workbook, and close it individually so you can see which file each prompt concerns.

The workbook reopens with recovered edits. Excel may offer AutoRecovered material after a crash or unexpected closure. Review the recovered workbook and compare its name and contents with the saved file. If you do not want the recovered changes, close that recovered copy and avoid saving over the original. Recovery behavior can vary with Excel settings, file location, and how the app stopped.

Cloud changes were already saved. First, stop editing the current version. Open version history for the OneDrive or SharePoint file, identify a version saved before the unwanted changes, and review it before restoring. Restoring an earlier version can affect other collaborators’ work, so check with them when the file is shared. If version history is unavailable, contact the file owner or administrator; the ability to recover older versions depends on the service and account settings.

Excel is not responding. Wait briefly in case Excel is processing a large workbook. If it remains unresponsive, force-closing the app is a last resort, because it can lose work and may trigger recovery on the next launch. After restarting, review any recovery pane and verify the saved original before replacing or deleting anything.

Frequently Asked Questions

Does Don’t Save delete the workbook?

No. For an existing workbook, it closes the file and discards changes made since the last save; it does not normally delete the saved workbook. A new workbook that has never been saved is simply closed without being saved as a file.

Can I undo after choosing Don’t Save?

Usually, you cannot use Ctrl+Z to bring back changes after the workbook has closed. If Excel offers a recovered copy when reopened, review it, but recovery is not guaranteed. For a cloud file, check version history for an earlier or later saved version.

What if I want to keep some edits but discard others?

Before closing, undo or remove the edits you do not want, then save the workbook. Alternatively, use File > Save As to make a separate copy, so you can preserve one version while discarding changes in the other. Don’t Save treats all unsaved changes in that workbook as a group.

Does closing the browser tab discard an Excel for the web workbook?

No. Excel for the web normally saves changes automatically to its cloud location. Use Undo for a recent unwanted change or look for an earlier version in version history; simply closing the tab is not a reliable discard method.

Will Don’t Save affect other workbooks I have open?

It applies to the workbook named in the save prompt. Other open workbooks remain open, and they may show their own prompts when you close them or quit Excel. Check each prompt before choosing an option.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.