Why Excel AutoSave Does Not Stay Enabled & How to Fix It
Question details
The user needs to understand why the AutoSave feature in Excel frequently disables itself and how to ensure files remain automatically saved without creating confusing duplicate copies.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Editing a spreadsheet and relying on the AutoSave toggle to automatically capture changes in real-time.
- Observed behavior
- The AutoSave toggle automatically turns off when opening certain files, particularly when accessing desktop shortcuts rather than directly from OneDrive, leading to version conflicts.
Ensure your computer has an active internet connection and that the OneDrive or SharePoint desktop synchronization app is running and logged into your account.
Save and Open the File Directly from OneDrive
Excel AutoSave requires files to be actively stored in and opened from a Microsoft cloud service like OneDrive or SharePoint.
A common mistake is opening an older, local desktop copy of a file that was previously uploaded to the cloud. When you do this, Excel cannot sync changes in real-time, causing AutoSave to disable. You must open the live cloud version.
Open File Explorer and move your Excel document into the local OneDrive synced folder.
Double-click the file from within the OneDrive directory rather than using an older local desktop shortcut.
Check the top-left corner of the Excel window to ensure the AutoSave toggle is switched to the 'On' position.

Enable AutoSave by Default in Excel Settings
If AutoSave is disabled for all newly opened cloud files, you may need to adjust your global Excel save options.
Use AutoRecover for Local Desktop Files
If you prefer not to use OneDrive, you cannot use AutoSave. Instead, configure AutoRecover to periodically back up your local files.
Try WPS Office for a Hassle-Free Spreadsheet Experience
Tired of dealing with complicated OneDrive synchronization and AutoSave issues? WPS Office offers a free, lightweight alternative with reliable local auto-backups, seamless optional cloud synchronization, and full compatibility with Microsoft Office formats.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your device.
- 2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up the office suite.
- 3. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly, without losing any formatting, data, or formulas.

Frequently Asked Questions
Why does AutoSave turn off when I save my document as an older Excel format?
Excel AutoSave requires modern file formats to function properly. If your file is saved as an older .xls document, AutoSave will automatically disable itself. You must navigate to File > Save As and convert the file to a modern .xlsx, .xlsm, or .xlsb format to restore AutoSave functionality.
Can I force AutoSave to work for files saved only on my local hard drive?
No, the AutoSave toggle located at the top left of the Excel window is strictly integrated with Microsoft's cloud services (OneDrive and SharePoint). For files stored locally on your desktop or documents folder, you must rely on the AutoRecover feature instead.
Why does AutoSave disable when my file contains certain unsupported features?
Certain legacy Excel features conflict with the real-time co-authoring engine that AutoSave relies on. Features like legacy shared workbooks, strict file encryption (passwords), or unsupported data-refresh settings will force AutoSave to turn off. Removing these legacy features will allow AutoSave to stay enabled.




