Excel AutoSave Not Working: What to Check First
Excel AutoSave is most useful when a workbook is stored in OneDrive, OneDrive for Business, or SharePoint. If the AutoSave switch is missing, disabled, or not saving changes, the file location and account status are the first things to check.
Quick Checks
- Confirm the workbook is saved to OneDrive or SharePoint.
- Check that you are signed into the correct Microsoft account.
- Make sure the file is not read-only.
- Confirm your Microsoft 365 app is up to date.
- If changes did not sync, check Excel's unsaved changes or version history.
AutoSave Depends on Where the File Is Stored
Microsoft describes AutoSave as a Microsoft 365 feature that saves files automatically while you work when files are stored in OneDrive, OneDrive for Business, or SharePoint Online. If your workbook is only saved on a local drive, AutoSave may not behave the same way.
Use Save As or Save a Copy to place the workbook in OneDrive or SharePoint, then check whether AutoSave becomes available.
Check Account and Sync Status
If the workbook is already in OneDrive or SharePoint, confirm that Excel is signed into the same account that owns or can edit the file. Also check OneDrive sync status. If sync is paused or disconnected, changes may not reach the cloud.
If Changes Did Not Save
Open the workbook and check whether Excel shows unsaved changes. For cloud-backed files, version history may also help you recover a previous copy.
Be careful before restoring an older version. Preview it first so you do not replace newer work you still need.
If AutoSave Saved Something You Did Not Want
AutoSave can preserve changes continuously. If you meant to use an existing workbook as a starting point, use Save a Copy before editing. If changes were already saved, check version history and restore the correct version only after previewing it.
Sources
- Microsoft Support: What is AutoSave?
- Microsoft Support: Get help with unsaved changes in Excel
- Microsoft Support: Recover an earlier version of an Office file