Does Excel Save Automatically? AutoSave Explained

How-to basics · Updated November 22, 2026

Yes, Excel can save changes automatically, but whether it does depends mainly on where the workbook is stored. In Microsoft 365 for Windows, AutoSave continually saves supported workbooks stored on OneDrive or SharePoint; a workbook saved only on your computer generally needs you to save it yourself, with AutoRecover offering a separate safety net.

What Excel’s AutoSave Does

AutoSave writes changes to the workbook as you work, rather than waiting for you to press Save. When it is active, the AutoSave switch appears near the upper-left corner of the Excel window. For an eligible cloud-stored file, it is usually turned on automatically, though you can switch it off.

AutoSave is useful when you make frequent edits or collaborate with other people. For example, if you update a sales figure in a workbook stored in OneDrive, Excel can save that edit to the cloud without requiring a separate Ctrl+S. Other people with access may then see the change, depending on their connection and how quickly the update syncs.

Automatic saving does not mean that every change is instantly visible everywhere. An edit may take a short time to sync, especially with a slow or interrupted internet connection. Check Excel’s status indicators and the AutoSave switch if you need to confirm that a change has been saved. For important work, pressing Ctrl+S is still a sensible way to request a save.

When AutoSave Is Available

In Excel for Microsoft 365 on Windows, AutoSave is intended for files stored in OneDrive or SharePoint. The file must be signed in to an account with access to that location. A workbook saved in a local folder such as Documents, or on a removable drive, does not receive the same cloud AutoSave behavior simply because Excel is open.

To use it, save the workbook to OneDrive or a SharePoint library. You can choose a cloud location through File > Save As, then select the relevant OneDrive or SharePoint location. After the workbook is saved there, look for the AutoSave switch at the top of the Excel window. If it is available and on, Excel saves changes to that cloud file as you work.

  • OneDrive: A personal or work OneDrive location stores the workbook online and supports cloud saving when you are signed in.
  • SharePoint: A workbook in a SharePoint document library can support AutoSave and collaboration, subject to your organization’s access and configuration.
  • Local or removable storage: Use Ctrl+S to save changes. AutoRecover may help after a crash, but it is not continuous saving to that file.

Excel for the web saves workbooks stored in OneDrive or SharePoint automatically as you edit; there is no separate desktop-style Save command needed for ordinary edits. The precise interface differs from desktop Excel, but the basic distinction remains: cloud storage is what enables automatic saving and sharing.

AutoSave Versus AutoRecover

AutoSave and AutoRecover sound similar, but they solve different problems. AutoSave saves ongoing changes to a cloud workbook. AutoRecover periodically keeps recovery information that may help restore work after Excel closes unexpectedly. It is designed as a fallback, not as a substitute for saving your file.

On Windows, review AutoRecover settings in File > Options > Save. The options include saving AutoRecover information at a chosen interval and keeping the last AutoRecovered version if you close without saving. The interval is configurable, so do not assume that a recovery copy includes every edit. If Excel or Windows fails between recovery saves, some recent work may be missing.

If Excel closes unexpectedly, it may show a Document Recovery pane when you reopen the program. Open the available recovered version and save it under a clear name. You can also look in File > Info for workbook-management or recovery options, including Recover Unsaved Workbooks when Excel has a recoverable copy. Availability depends on whether recovery information exists.

AutoRecover is not the same as a backup. It may not preserve every file, every change, or a usable version after every type of failure. For work you cannot afford to lose, save deliberately and keep a separate backup or use a managed cloud location with version history.

How to Check Whether a Workbook Is Saving

Do not rely on the word AutoSave alone; check the actual workbook and its location. In desktop Excel, first look at the switch near the upper-left corner. If it is on, confirm that the workbook is stored in OneDrive or SharePoint and that you are signed in. If the switch is off or unavailable, use Save or Ctrl+S and investigate the location.

  1. Check the workbook’s name and storage location in Excel, or use File > Save As to see where it is saved.
  2. If it is a local file and you want cloud AutoSave, save a copy to OneDrive or SharePoint.
  3. Confirm that AutoSave is on and watch for any syncing or sign-in warning in the Excel window.
  4. Make a small change, wait for the save or sync status to settle, and check the file from its cloud location if appropriate.
  5. For a critical workbook, press Ctrl+S before closing and confirm that Excel does not report a saving problem.

On a Mac, Excel also supports AutoSave for eligible OneDrive and SharePoint files, although controls and menus can appear in different places from Windows. The Mac keyboard shortcut for saving is Command+S rather than Ctrl+S. Excel for the web uses a browser interface and saves cloud edits automatically.

Why AutoSave Might Be Off or Unavailable

The most common reason is that the workbook is not stored in OneDrive or SharePoint. A file on your desktop, a network location, or a USB drive may still be editable in Excel, but that does not make it an AutoSave cloud workbook. Save it to a supported cloud location if you want that behavior.

Other causes can include being signed out, lacking permission to edit the cloud file, or having a connection or synchronization problem. A work or school organization may also control access to storage or sharing features. If AutoSave is off unexpectedly, try these checks:

  • Confirm that Excel is signed in to the account that owns or can edit the file.
  • Check whether the workbook is actually in OneDrive or a SharePoint library, rather than a synced local copy or a different folder.
  • Look for a warning about permissions, upload, or synchronization, and resolve it before assuming the latest edit reached the cloud.
  • Use Save As to create a cloud-stored copy if the current file’s location or format prevents the option from being available.
  • Save manually before closing if you are unsure whether a recent change has finished syncing.

AutoSave can also be switched off intentionally. Turning it off does not mean Excel will save every edit in another way; for a local workbook, you still need to save manually. You can leave AutoRecover enabled as an additional recovery measure, but remember that its periodic copies may lag behind your latest work.

AutoSave, Version History, and Backups

Saving a workbook and keeping earlier versions are related but distinct. AutoSave updates the current cloud file. Version history, when available for a file in OneDrive or SharePoint, can let you view or restore an earlier version. It is particularly useful if an edit is saved successfully but later turns out to be wrong.

Version history is not a promise that every keystroke has a separately recoverable version, nor is it a substitute for a backup strategy. How history is retained can depend on the storage service and organization settings. If you are considering restoring an older version, check what will be replaced and, when practical, save a copy of the current workbook first.

A practical approach is to combine several safeguards: use cloud storage for AutoSave, keep version history available where your account supports it, press Save before closing important files, and maintain a separate backup for high-value work. Those measures address different risks: forgotten manual saves, accidental edits, and loss of access to the primary file.

Should You Turn AutoSave Off?

For most ordinary cloud workbooks, leaving AutoSave on is convenient because it reduces the chance of losing unsaved edits. It is especially helpful when you collaborate or move between devices. Still, there are situations where a person may prefer to edit a separate copy or switch AutoSave off temporarily, such as when experimenting with a workbook and not wanting each change written immediately to the shared file.

Before changing the setting, consider who else may be using the workbook. If it is shared, your edits may be saved for collaborators as you work. A safer way to experiment is often to create a separate copy with Save As and make changes there. If you do turn AutoSave off, save deliberately with Ctrl+S on Windows or Command+S on Mac, and do not treat AutoRecover as a replacement.

Frequently Asked Questions

Does Excel save automatically if I close it?
If AutoSave is on for a supported OneDrive or SharePoint workbook, changes are saved as you work. For a local workbook, closing Excel does not reliably save your latest edits for you. Save first if you are uncertain.

Does Excel save automatically to my computer?
Not in the same continuous way as AutoSave to OneDrive or SharePoint. For a workbook stored locally, press Ctrl+S on Windows or Command+S on Mac. AutoRecover may retain recovery data, but it is not a guaranteed copy of every change.

How often does Excel AutoSave?
AutoSave updates an eligible cloud workbook as changes are made, typically within seconds, but timing can vary with connection and synchronization conditions. AutoRecover is different: its interval is set in Excel’s Save options and may leave a gap between the latest edit and recovery information.

Where are AutoRecover settings in Excel?
In Excel for Microsoft 365 on Windows, open File > Options > Save. There you can review the AutoRecover interval and the option to keep the last recovered version when closing without saving.

Can I recover an Excel file I forgot to save?
Possibly. Reopen Excel and check for the Document Recovery pane, or look under File > Info for Recover Unsaved Workbooks. Recovery depends on Excel having saved usable recovery information, so it cannot be guaranteed.

Does AutoSave keep old versions of my workbook?
AutoSave updates the current file; version history is a separate feature of OneDrive or SharePoint that may allow earlier versions to be viewed or restored. Availability and retention depend on the storage location and its settings.

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.