30 Advanced Excel Tips for 2026

Excel Champs / Advanced Excel / How to Turn OFF the AutoSave Feature in Excel
By Puneet Gogia (Microsoft MVP)

How to Turn OFF the AutoSave Feature in Excel

Click the AutoSave switch at the top-left of the Excel window to turn it off for the file you have open. Excel remembers that choice for that file the next time you open it.

To turn it off for every file, go to File ? Options ? Save, clear AutoSave files stored in the Cloud by default in Excel and click OK. New files then open with AutoSave off, and you can still switch it on for any one file.

AutoSave only runs on files saved to OneDrive or SharePoint. For a file on your own computer the switch stays off, and clicking it asks you to move the file to OneDrive.

Turning AutoSave off does not turn off AutoRecover. AutoRecover keeps a separate recovery copy every few minutes so you can get your work back after a crash, and it never overwrites your file. Set how often it runs under File ? Options ? Save ? Save AutoRecover information every.

If you are turning it off to try changes without touching the original, you can leave AutoSave on and use File ? Save a Copy first. To undo changes that have already saved, go to File ? Info ? Version History and restore an earlier version.

Let’s say you are preparing a financial report and testing different strategies. You don’t want to save changes automatically because you might need to revert to the original data. Turning OFF AutoSave helps you experiment without worrying about losing the initial information.

AutoSave is a feature that Microsoft introduced in the Microsoft 365 apps, including Excel. It works with files stored in OneDrive and SharePoint and saves your changes every few seconds as you work. Each save replaces the file, but you can still go back to an older copy with Version History.

turn-off-autosave-feature

Now as we have seen there are a few situations where you don’t need it and want to turn it off. In this tutorial, I have shared two simple ways to do this. And I have also shared which method I use myself.

Turn OFF AutoSave from Excel Options

You can turn off AutoSave from Excel Options for the entire Excel application. Below are the steps you need to follow:

autosave-from-excel-options
  1. Click the “File” tab in the Excel Window’s top-left corner. This will take you to the backstage view, where you can access various options. On the left side, you will see options like Save, Save As, and Open.
  2. Once in the menu, click Options to open the Excel Options. It’s usually located at the bottom of the menu on the left side. Clicking ‘Options’ will open a new window called Excel Options.
  3. Look at the list on the left side of Excel Options and click “Save.” This will display the save options in the main part of the window. Here, you can customize how Excel saves your workbooks.
  4. In the main part of the window, you will see a section called “Save workbooks.” Look for the checkbox that says “AutoSave files stored in the Cloud by default in Excel.” Uncheck this box to turn off AutoSave for these files.
  5. After unchecking the AutoSave box, click the “OK” button at the bottom of the window. This action will save your changes and close the Excel Options.

Once you save these settings, Excel will stop turning AutoSave “On” for the files you open or save in OneDrive or SharePoint.

But a file you already have open will still have AutoSave “On”, and you need to turn it off from the AutoSave button, which you have on the quick access toolbar.

Turn OFF AutoSave Without Turning it OFF from Options

AutoSave is a fantastic feature that helps you save files. So instead of turning it off from Excel Options, I’d recommend you use the toggle button on the Quick Access Toolbar to turn it off and on.

turn-off-autosave-without-turning-it-off

You’ll see the Quick Access Toolbar and the AutoSave toggle button at the top-left corner of the Excel window. If AutoSave is currently on, the toggle will show On. Click the AutoSave toggle button to turn it off. The setting stays with that file, so the next time you open it, AutoSave stays off.

I like to turn off AutoSave from here most of the time, as it lets me choose for each workbook. If I want to turn it off only for a single workbook, I don’t need to do so for the entire Excel.

Are There Any Benefits of Turning OFF AutoSave

Yes, there are a few benefits:

  • Overwriting Workbook Data: Important data is protected from being automatically overwritten. If you make a mistake or change something unintentionally, you can close the workbook without saving it, and your original data will remain safe.
  • Control Saves – With AutoSave off, you decide when to save your changes. This means you won’t automatically save mistakes or changes. You have full control over what gets saved and when.
  • Change Freely – When trying out different changes or scenarios in a workbook, turning off AutoSave means you don’t have to worry about losing your original data.

Turn OFF AutoSave with VBA

If you want a workbook to always open with AutoSave off, you can use the AutoSaveOn property in the Workbook_Open event (in the ThisWorkbook module). The workbook needs to be saved as a macro-enabled file (.xlsm):

Private Sub Workbook_Open()
ThisWorkbook.AutoSaveOn = False
End Sub

AutoSave vs AutoRecover

Turning off AutoSave doesn’t turn off AutoRecover, and that’s a good thing. AutoRecover saves a temporary recovery copy every few minutes (10 by default), so you can get your work back if Excel crashes. It doesn’t change your actual file. You can change the interval in File ➜ Options ➜ Save ➜ “Save AutoRecover information every”.

On a Mac, you’ll find the same AutoSave setting in Excel ➜ Preferences ➜ Save.

Frequently Asked Questions

Why is the AutoSave button greyed out?

AutoSave only works for files saved in OneDrive or SharePoint, in a current file format (.xlsx, .xlsm or .xlsb). For a file on your computer or an old .xls file, the button is off and can’t be turned on.

How do I get back an older version after AutoSave?

Click the file name at the top of the Excel window and choose Version History (or go to File ➜ Info ➜ Version History). Open an older version and click Restore.

Does turning off AutoSave stop saving to OneDrive?

No. The file stays in OneDrive; it just isn’t saved automatically. Press Ctrl + S whenever you want to save your changes.