Excel AutoSave not working: how to fix it

Applies to: Excel for Microsoft 365 on Windows and Mac, the versions Microsoft lists on its AutoSave page. Excel 2024, 2021, 2019 and 2016 bought without a subscription don’t offer AutoSave on Windows, though they still have AutoRecover.

Match your symptom

What you see	Likely cause	Go to
No AutoSave switch at all	No Microsoft 365 subscription, or an older build	Fix 1, Fix 7
Switch grayed out on a new or local file	File isn’t saved to OneDrive or SharePoint	Fix 2
Switch grayed out on an older workbook	File uses the .xls format	Fix 3
Grayed out in the OneDrive folder on your PC	Sync paused or an outdated sync app	Fix 4
Grayed out on one cloud workbook only	Shared workbook, password, add-in or similar setting	Fix 5
Off for every new cloud file	The default was cleared in Excel Options	Fix 6
Turns off again after you switch it on	A setting in that workbook, or a per-file choice	Turns itself off

How AutoSave decides whether it can run

AutoSave and AutoRecover are different features, and mixing them up leads to the wrong fix. According to Microsoft’s What is AutoSave? page, AutoSave writes your changes to the file every few seconds and is on by default for files in OneDrive, OneDrive for work or school, and SharePoint Online. AutoRecover only keeps a recovery copy that Excel offers after a crash, and it works for local files too.

Because AutoSave saves to the original file in the cloud, Excel switches it off whenever it can’t do that safely. Microsoft lists these general reasons:

• The file is saved somewhere else, such as a folder on C:\, a file server, on-premises SharePoint or another cloud service, or it hasn’t been saved yet.
• The file uses an older format such as .xls.
• The file is in your local OneDrive folder and OneDrive sync is paused.
• The file syncs through an outdated version of the OneDrive sync app.
• The file is embedded inside another Office file.

Each fix below deals with one of these reasons, or with a setting that only applies to Excel.

Fix 1: Check your Microsoft 365 subscription and sign-in

Microsoft says the AutoSave switch doesn’t appear on Windows unless you’re a Microsoft 365 subscriber using a current version of the apps. A one-time purchase such as Office 2021 doesn’t include it, and an employer can restrict which versions its staff get.

1. In Excel, open File > Account.
2. Under Product Information, confirm that it names a Microsoft 365 subscription rather than a one-time Office version.
3. Under User Information, confirm that you’re signed in with the account that owns the subscription or, for work files, your work or school account.

If the product is a one-time purchase, AutoSave isn’t available and the fixes below won’t change that. Use the steps in Protect your work while AutoSave is off instead.

Fix 2: Save the workbook to OneDrive or SharePoint

A workbook on your desktop, a USB drive or a network share can’t use AutoSave, even with a subscription. Move it to the cloud:

1. Open the workbook and select File > Save As.
2. Choose OneDrive (personal or your organization’s), or a SharePoint site under Sites.
3. Pick a folder, keep the .xlsx type and select Save.
4. Check that the AutoSave switch in the top-left corner is now available, and turn it on.

From then on, open the file from that cloud location, not from an older copy on your PC. If a colleague may have it open at the same time and Excel reports it as locked, see Excel file is locked for editing by another user.

Fix 3: Convert an old .xls file to .xlsx

Microsoft names older formats such as .xls as a reason AutoSave stays off. A workbook in that format usually shows Compatibility Mode next to its name in the title bar.

1. Open the workbook and select File > Save As.
2. Choose the OneDrive or SharePoint folder you want.
3. Set the file type to Excel Workbook (*.xlsx), or Excel Macro-Enabled Workbook (*.xlsm) if it contains macros you need.
4. Select Save, close the file and open the new copy.

The old .xls file stays where it was. Keep it until you’ve confirmed that formulas and formatting look right in the new file.

Fix 4: Resume or update OneDrive sync

If you open workbooks from the OneDrive folder in File Explorer, Excel depends on the OneDrive app to reach the cloud copy. Microsoft says AutoSave is disabled when that sync is paused or when the sync app is out of date.

1. Select the OneDrive cloud icon in the notification area of the taskbar.
2. If it shows that syncing is paused, open the gear menu and choose to resume syncing.
3. Wait until OneDrive reports that your files are up to date, then reopen the workbook.

If the cloud icon shows an error, or files never finish syncing, work through OneDrive not syncing in Windows 11 first. If you paused sync on purpose, our guide on how to stop OneDrive from syncing explains the trade-offs, including losing AutoSave for those files.

Fix 5: Remove Excel features that block AutoSave

When the file is in the right place and format but AutoSave is still grayed out for that one workbook, look at its settings. Microsoft lists several Excel features that turn AutoSave off, each with its own fix:

• Shared Workbook: the legacy shared workbook feature blocks AutoSave. Turn it off and share the file from OneDrive or SharePoint instead, since co-authoring replaces it.
• Password encryption: a workbook encrypted with a password can’t use AutoSave. If you’re allowed to, remove the password under File > Info > Protect Workbook > Encrypt with Password by clearing the box. Microsoft suggests sensitivity labels as an alternative where your organization uses them.
• Restricted access: set the workbook to Unrestricted Access, again using sensitivity labels instead if you need protection.
• Workbook snapshot: a snapshot opened from SharePoint is a copy, not the file. Open the workbook itself from the library.
• Add-ins: an add-in can stop AutoSave. Open File > Options > Add-ins, choose COM Add-ins in the Manage list, select Go, and clear add-ins one at a time to find the one responsible.
• Compatibility check on save: under File > Info > Check for Issues > Check Compatibility, clear Check compatibility when saving this workbook.
• Embedded objects: replace embedded objects with links where you can.

Change only settings you own. A password, restricted access or sensitivity label on a work file was usually set for a reason, so check with whoever manages the file before removing it.

Fix 6: Turn the AutoSave default back on

Excel has an option that decides whether AutoSave starts on for OneDrive and SharePoint files. If someone cleared it, every new cloud workbook opens with AutoSave off, even though the switch still works.

1. In Excel, open File > Options > Save.
2. Select the box that turns on AutoSave for OneDrive and SharePoint Online files by default in Excel.
3. Select OK and restart Excel.

Microsoft notes that this option is set separately in each Office app, so Word and PowerPoint keep their own setting.

Fix 7: Update or repair Office

Microsoft says AutoSave needs current versions of the Microsoft 365 apps on Windows. To install the latest updates, open File > Account > Update Options > Update Now in Excel, then restart it. If your organization manages updates, this button may be hidden or locked, and your IT team controls the version you get.

If the switch is missing or misbehaves in every workbook even on a current build, a damaged installation is possible. Our guide on how to repair Microsoft Office covers Quick Repair and Online Repair.

When AutoSave turns itself off

Excel remembers your AutoSave choice for each file. If you switched it off for one workbook, it stays off the next time you open that workbook, which can look like Excel turning it off on its own. Turn the switch back on for that file and it stays on.

If the switch flips back to off while you work, or every time you reopen the file, Excel may have found one of the blockers in Fix 5, or the sync problem in Fix 4. Check those first. Also check whether the copy you opened is the cloud file or a local copy with the same name, for example one from your Downloads folder or an email attachment. A local copy can’t use AutoSave.

Protect your work while AutoSave is off

Until AutoSave works again, or if your version of Excel doesn’t include it, other features still protect you:

• AutoRecover: Microsoft says AutoRecover keeps protecting you when AutoSave is off. Its interval and file location are set under File > Options > Save.
• Save often: press Ctrl + S after any change you don’t want to redo.
• Save a Copy before big edits: because AutoSave writes changes to the original file, Microsoft suggests File > Save a Copy first when you want the original left as it was.

If a crash has already cost you work, the steps in how to recover an unsaved Word document use the same AutoRecover and version history features found in Excel, though the menu names differ slightly.

Known issues

As of November 2026, Microsoft’s Fixes or workarounds for recent issues in Excel for Windows page, last updated in September 2026, lists no issue about AutoSave being grayed out, turning off or failing to save to OneDrive or SharePoint.

If AutoSave stops working right after an Office update, check that page again, since Microsoft adds issues as they’re confirmed.

Related guides

• OneDrive not syncing in Windows 11: how to fix it
• Excel file is locked for editing by another user: how to fix it
• How to repair Microsoft Office (Quick Repair and Online Repair)
• How to recover an unsaved Word document
• How to stop OneDrive from syncing (without losing files)

Official sources

• Microsoft: What is AutoSave?
• Microsoft: Fixes or workarounds for recent issues in Excel for Windows