Office Settings & Configuration

How to Fix Excel AutoSave Turning Off Repeatedly

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to troubleshoot and resolve an issue where the AutoSave feature in Microsoft Excel constantly disables itself.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working on an Excel workbook and attempting to keep the automatic cloud-saving feature enabled.
Observed behavior: The AutoSave toggle repeatedly switches off, failing to automatically save changes to the document.

Before you start

Ensure your computer is connected to a stable internet network and that you are actively signed into your Microsoft 365 account.

Solution 1Recommended

Verify OneDrive or SharePoint Sync Status

AutoSave is exclusively designed to work with files hosted on Microsoft's cloud services. Verifying your sync status ensures the feature can stay enabled.

Excel's AutoSave relies entirely on OneDrive or SharePoint. If your file is saved locally to your hard drive, or if your OneDrive client is paused or experiencing sync errors, AutoSave will automatically turn off to prevent data conflicts.

Save the file to the Cloud

Click on 'File' > 'Save As' and select your connected OneDrive or SharePoint account as the save location.

Check OneDrive Sync

Click the OneDrive cloud icon in your Windows taskbar to ensure it says 'Up to date' and that you are signed in without any error prompts.

Local Files: If you prefer saving files locally on your computer, Excel will use 'AutoRecover' instead of 'AutoSave'. AutoRecover saves backup copies periodically but does not save in real-time.

Solution 2

Convert the Workbook to a Supported File Format

AutoSave does not support older Excel formats or text-based spreadsheet formats.

Solution 3

Run a Quick Repair on Microsoft Office

If your file is properly synced and formatted but AutoSave still turns off, your Office installation may have corrupted files that need repairing.

Free Microsoft Office alternative

Try WPS Office for Reliable Document Saving and Sync

If you are frequently frustrated by Microsoft Excel's AutoSave issues and strict cloud dependencies, consider switching to WPS Office. It provides a highly compatible, free alternative with built-in, hassle-free automatic backups.

1. Download and Install: Visit the WPS Office website to download the free installer and follow the setup instructions.
2. Open Your Workbooks: Launch WPS Spreadsheets and seamlessly open your existing .xlsx or .xls files without losing formatting.
3. Enable Local or Cloud Backups: Go to 'Settings' > 'Backup Settings' to easily customize how and where your spreadsheets are automatically saved.

Completely free to use with a lightweight installationSeamlessly compatible with all Microsoft Excel formats (.xlsx, .xls, .csv)Familiar spreadsheet interface ensuring zero learning curveBuilt-in WPS Cloud and robust auto-backup features to prevent data loss

microsoft office alternative - wps office

Frequently Asked Questions

Why does AutoSave turn off when I save an Excel file locally?

The AutoSave toggle in the top-left corner of Microsoft Excel is specifically engineered for real-time co-authoring and cloud syncing via OneDrive or SharePoint. It cannot function on local drives. For local files, Excel uses a different feature called AutoRecover.

Does AutoSave work with older .xls files?

No, AutoSave requires modern XML-based file formats like .xlsx, .xlsm, or .xlsb. If you open a legacy .xls file, the AutoSave switch will automatically disable itself. You must convert the file via 'Save As' to enable the feature.

What is the difference between Excel AutoSave and AutoRecover?

AutoSave constantly pushes your real-time edits to the cloud (OneDrive/SharePoint) so that nothing is lost and others can collaborate. AutoRecover is a legacy feature that automatically saves a local backup copy of your file every few minutes in case Excel crashes unexpectedly.

Office App Problems