A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
The AutoSave toggle only appears in Excel 365 when all of these conditions are met:
- The file is stored in OneDrive or SharePoint
- AutoSave works in Microsoft 365 only when the file is saved to OneDrive or SharePoint.
- If the file is on a local drive (for example,
C:\Users\...), the AutoSave control will not be available.
- The file is opened from within Excel via OneDrive/SharePoint
- Open Excel.
- Select File > Open.
- Choose the OneDrive (personal, work, or school) or SharePoint location.
- Browse to the folder and open the file from there.
- Opening from File Explorer, Finder, or the taskbar “Recent” list can prevent AutoSave from turning on or appearing; close the file and reopen it as above.
- The file type supports AutoSave
- AutoSave is not available for some formats such as CSV, or older formats like
.xls,.ppt, or.doc. - Save the workbook as a modern format (e.g.,
.xlsx) in OneDrive/SharePoint using File > Save As and selecting a OneDrive/SharePoint location.
- AutoSave is not available for some formats such as CSV, or older formats like
- AutoSave is enabled in Excel options
- Go to File > Options > Save.
- Ensure the AutoSave-related checkbox is ticked (AutoSave settings may be disabled for some files, especially large files or those on SharePoint).
- An active Microsoft 365 subscription is in use
- AutoSave is only available with an active Microsoft 365 subscription.
If the file meets all of the above (modern format, stored in OneDrive/SharePoint, opened from within Excel from that cloud location, AutoSave enabled in Options, and an active subscription), the AutoSave toggle should reappear in the title bar. If it still does not appear, verify that OneDrive sync is not paused and that the file is not embedded inside another Office file or in slide show mode (for PowerPoint scenarios).
Note: AutoRecover is separate and still works for local files; its settings are under File > Options > Save.
References: