AutoSave (the toggle in the top-left of the Excel ribbon, not to be confused with the older AutoRecover feature) has a specific set of requirements that all need to be true at once for it to work. If even one isn't met, you'll either find the toggle greyed out and unclickable, or — more frustratingly — find that it appears to be on but isn't actually saving your changes.
What AutoSave actually requires
- The file must be stored on OneDrive or SharePoint. AutoSave does not work for files saved to a local drive, a USB drive, or a traditional (non-SharePoint) network share. This is the single most common reason it's unavailable — many people expect AutoSave to work like AutoRecover, saving locally, but it specifically requires cloud storage to function at all.
- You need an active Microsoft 365 subscription (not a one-time-purchase Office license). AutoSave is a Microsoft 365 subscription feature; it's not included with Office Home & Student or other perpetual-license versions.
- The file format needs to be a modern Office format — .xlsx, not the older .xls format. Files in legacy formats need to be converted first.
- You need to be signed in to the Microsoft 365 account that has access to that OneDrive/SharePoint location.
Fix: move the file to OneDrive and re-save in the right format
- If your file is currently saved locally, click File → Save a Copy (or Save As)
- Choose OneDrive as the save location (you'll need to be signed into your Microsoft 365 account first if you aren't already)
- If you're prompted about the file format, make sure it's saving as .xlsx, not .xls
- Once saved to OneDrive in the right format, the AutoSave toggle in the top-left should become clickable — turn it on
If you're on a work computer: check whether you're signed into Excel with your work Microsoft 365 account specifically (not a personal Microsoft account) — the OneDrive location AutoSave needs has to match the account you're actually signed into within Office, and it's easy to be signed into Windows with one account while Excel uses a different one.
If AutoSave is on but doesn't seem to actually be saving
This is a different, less common situation — usually one of these:
- Connectivity issue. AutoSave needs an internet connection to actually push changes to OneDrive/SharePoint. If you've been working offline (intermittent wifi, airplane mode, VPN drop), changes accumulate locally and sync once connectivity returns — check the AutoSave status indicator next to the toggle, which usually shows "Saving..." or an error icon if something's stuck.
- Sync conflict. If the file is also being edited by someone else, or OneDrive sync itself is having issues (worth checking the OneDrive icon in your system tray for a warning symbol), AutoSave can stall.
- Add-ins interfering. Some third-party Excel add-ins, particularly ones that hook into file save events, can occasionally conflict with AutoSave. Try File → Options → Add-ins, then disable add-ins one at a time to isolate whether one is the cause.
A practical safety net regardless
Even with AutoSave working correctly, it's worth keeping the traditional AutoRecover feature enabled too (File → Options → Save, check "Save AutoRecover information"), since it provides a local backup safety net independent of your internet connection or OneDrive sync status — useful in the rare case AutoSave silently fails without you noticing immediately.