Excel AutoSave: How to Turn It Off and Keep Changes Safe

How-to basics · Updated November 20, 2026

To turn off AutoSave for the workbook you have open in Excel for Microsoft 365 on Windows, switch the AutoSave toggle at the upper-left of the Excel window to Off. To change the default for cloud files, go to File > Options > Save and clear AutoSave OneDrive and SharePoint Online files by default in Excel. AutoSave is different from AutoRecover, so you can turn off continuous saving without turning off Excel’s recovery feature.

AutoSave is designed to save changes continuously to files stored in OneDrive or SharePoint. Turning it off gives you more control over when changes are written to the file, but it also means you need to save regularly yourself. The steps below explain how to switch it off for one workbook, change the default, and avoid confusing AutoSave with related settings.

What You’ll Need

  • Excel for Microsoft 365 desktop on Windows for the main steps. You need permission to edit the workbook.
  • If the workbook is in OneDrive or SharePoint, an internet connection may be needed to sync changes when you save.
  • For the desktop toggle to be available, open a workbook that supports AutoSave, typically a file stored in OneDrive or SharePoint. Local files do not use cloud AutoSave in the same way.

Step-by-Step

  1. Open the workbook in the Excel desktop app. If you opened it in a browser, choose the option to open it in the desktop app, if available. Excel for the web saves changes automatically and does not provide the same AutoSave off switch as the desktop app. Check the file name and location so you know which copy you are editing; a downloaded copy and a OneDrive copy can be separate files.
  2. Find the AutoSave control. Look at the upper-left area of the Excel window, near the workbook name and Save icon. The toggle is labelled AutoSave. If it says On, Excel is saving changes to the cloud workbook as you work. If it already says Off, AutoSave is disabled for this workbook, although you should still save changes manually.
  3. Switch AutoSave off for this workbook. Click the AutoSave toggle and confirm that it changes to Off. This affects the workbook you currently have open; it does not necessarily turn off AutoSave for every other workbook. If you work in several cloud workbooks, check the toggle in each one rather than assuming the setting is shared across all open files.
  4. Change the default for cloud workbooks, if you want. In Excel for Windows, select File > Options > Save. Under the workbook-saving options, clear the checkbox labelled AutoSave OneDrive and SharePoint Online files by default in Excel. Select OK to apply the preference. This changes the default behavior for supported cloud files; it does not turn off AutoRecover. Check the toggle in a workbook you open afterward, because a file-specific state or your organization’s policies may affect what you see.
  5. Save the changes you want to keep. With AutoSave off, press Ctrl+S on Windows or select the Save icon. If Excel asks where to save, confirm the intended file name and location. Saving manually writes the current workbook changes to the file; switching AutoSave off does not automatically undo changes already made or restore an earlier version.
  6. Make sure the setting has the result you expect. Look for Off on the AutoSave toggle, then make a small, harmless change if appropriate. Do not rely on the cloud file updating immediately while AutoSave is off: use Save when you are ready to write your changes. If you need to keep a prior version, create a separate copy or use the available version history before making substantial edits.

Mac: In Excel for Mac, use the AutoSave switch near the top of the window to turn it off for the current supported workbook. The names and location of the default preference can vary by Excel build. If you want to change the default, open Excel > Preferences (or Excel > Settings in newer versions) and look under Save for the cloud AutoSave preference. If you cannot find that option, use the workbook’s switch and save manually. The Windows File > Options path does not apply on Mac.

Common Mistakes

  • Turning off AutoRecover instead. AutoSave controls continuous saving to supported cloud files. AutoRecover stores recovery information at intervals to help restore work after a crash. The setting in File > Options > Save for how often to save AutoRecover information is not the AutoSave toggle. For most people, it is sensible to leave AutoRecover enabled even when AutoSave is off.
  • Expecting the toggle to control every workbook. The switch at the top of the window is for the current workbook. Other open files may have AutoSave on, off, or unavailable, so check each file when the distinction matters.
  • Assuming Off means Excel has saved everything. Off means continuous saving is disabled; it does not save pending edits for you. Use Ctrl+S regularly and look for any save indicator or prompt before closing.
  • Editing the wrong copy. A file opened from OneDrive, a local download, and a copy attached to an email may have similar names but different locations. Confirm the path before you turn off AutoSave or save, especially if other people are editing a shared workbook.
  • Expecting AutoSave off to stop collaboration or version history. Those are separate features. Other people may still have access to the shared file, and the service may keep versions according to its settings. Turning off AutoSave is not a privacy or access-control change.

Tips

  • Save at deliberate checkpoints. When AutoSave is off, save after completing a meaningful section of work and before closing Excel. For a long editing session, use a simple rhythm such as saving after each finished table, chart, or group of changes rather than waiting until the end.
  • Keep AutoRecover enabled. In Windows, review File > Options > Save and confirm that Save AutoRecover information every is selected with an interval you can live with. AutoRecover is a safety net, not a replacement for saving. Recovery data may not include every change since the last interval.
  • Use a copy when experimenting. If you are testing formulas, formatting, or a major restructuring, use File > Save As to create a separate working copy first. That gives you a clear fallback and avoids relying on the AutoSave switch as an undo or backup system.
  • Remember the Mac shortcut difference. Save with Ctrl+S on Windows and Command+S on Mac. The AutoSave switch is the same basic control, but menu names and preferences can differ by platform and update.
  • Coordinate on shared files. If teammates are editing the same workbook, let them know you have disabled AutoSave and agree how changes will be saved. Unsaved edits on one device may not be visible to collaborators, and saving later can create confusing update or conflict behavior.

Troubleshooting

The AutoSave toggle is missing or unavailable. Confirm that you are using the desktop app, not Excel for the web, and check whether the file is stored in OneDrive or SharePoint. The feature may also be unavailable for a particular file type, an older workbook format, or a file that has not been saved to a supported cloud location. If needed, use File > Save As to save a copy in a supported location, then reopen that copy and check the toggle. Do not overwrite the original unless that is what you intend.

The toggle turns back on for another workbook. The control is per workbook, while the option in File > Options > Save sets the default for supported cloud files. Verify that the default checkbox is cleared, reopen the workbook, and inspect its toggle. If your work or school account manages Office settings, an administrator’s policy may limit what you can change; contact your IT support team if the preference is unavailable or keeps reverting.

Excel still appears to save changes. Check that you turned off the toggle in the exact workbook you are editing. A second workbook, browser tab, or copy may still have AutoSave enabled. Also distinguish saving from other activity: version history, coauthoring indicators, and cloud syncing can continue to appear even when automatic saving is off. Make a test edit, wait briefly, and check the toggle and file location before drawing a conclusion.

You closed Excel and cannot find recent edits. First reopen the workbook and check whether Excel offers a recovered version. If it is stored in OneDrive or SharePoint, check version history or the service’s recycle bin if an earlier copy may have been replaced or deleted. Recovery is not guaranteed, particularly if changes were never saved and no recovery data was available. To reduce the chance of a repeat, save more often and keep a separate copy before major edits.

Excel for the web keeps saving automatically. The browser version is built around automatic saving and does not offer the desktop AutoSave switch. Open the workbook in desktop Excel and turn off its toggle, or work on a separate downloaded copy if you specifically need to control when local edits are saved. Keep in mind that a downloaded copy will not automatically update the cloud original.

Frequently Asked Questions

Does turning off AutoSave turn off AutoRecover?
No. AutoSave controls continuous saving for supported cloud workbooks. AutoRecover is a separate recovery feature that saves information at intervals. You can disable AutoSave and leave AutoRecover enabled.

Can I turn off AutoSave for just one Excel file?
Yes. Open that file in the desktop app and switch its AutoSave toggle to Off. Other workbooks can keep their own settings. Check the toggle in each file rather than assuming one change applies everywhere.

Can I disable AutoSave in Excel for the web?
No equivalent off switch is available in Excel for the web; it saves online changes automatically. Use the desktop app for the workbook-level switch, or edit a separate downloaded copy if you need a file that does not continuously update online.

Will turning off AutoSave discard edits already made?
No. Switching it off does not erase edits already in the workbook, but it also does not save future edits automatically. Save manually to keep changes, or close without saving only if you intentionally want to discard unsaved work.

Why is AutoSave greyed out?
The workbook may be local, in an unsupported format or location, or opened in an app or mode that does not support the control. Try opening a supported cloud file in desktop Excel. If a work or school policy controls the setting, ask your administrator.

Do I need to turn off AutoSave to protect the original workbook?
Not necessarily. Use File > Save As to make a separate copy before editing if you want to preserve the original. AutoSave is about when changes are saved, not whether a file has a backup or whether other users can access it.

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.