Office Settings & Configuration

How to Fix AutoSave Toggle Missing in Excel 2019 and 2021

Algirdas Jasaitis Oct 1, 2026 868 views

Question details

The user is unable to find or enable the AutoSave toggle in Excel 2019 or 2021, despite it working in Word and files being saved to OneDrive.

Why Is the AutoSave Toggle Missing in Excel 2019 or 2021?

Product: Microsoft Excel 2019, Excel 2021
Device & OS: not provided
Scenario: Attempting to enable real-time AutoSave for workbooks stored in OneDrive or SharePoint.
Observed behavior: The AutoSave toggle is completely missing from the Excel toolbar, even after repairing or reinstalling Office.

Before you start

Before troubleshooting, ensure you have an active internet connection and that your Microsoft account is properly signed in to both Excel and OneDrive.

Solution 1Recommended

Verify Your Office License and Version Compatibility

The AutoSave toggle in the top-left corner is primarily a Microsoft 365 exclusive feature. Perpetual licenses like Office 2019 and 2021 generally do not support this real-time toggle.

Microsoft designed the real-time AutoSave toggle specifically for Microsoft 365 subscription users. If you are using a perpetual license like Office 2019 or Office 2021, the feature is fundamentally limited or absent by design, even if it occasionally appears in other apps like Word due to version mismatches.

Open Account Settings

Open Microsoft Excel, click on 'File' in the top-left corner of the ribbon, and select 'Account' from the bottom-left menu.

Check Product Information

Under the 'Product Information' section on the right, look at the license type. Verify if it says 'Microsoft 365' or 'Office 2019/2021'.

Confirm Version Limitations

If your license is Office 2019 or 2021, the missing toggle is expected behavior. You will need to rely on the traditional AutoRecover feature instead.

Verify Your Office License and Version Compatibility

Perpetual License Limitation: If you have Office 2019 or 2021, you must rely on the traditional AutoRecover feature to save backups rather than the real-time AutoSave toggle.

Solution 2

Enable AutoRecover Settings in Excel Options

Since real-time AutoSave isn't supported on perpetual versions, configure AutoRecover to automatically save backup copies of your work at set intervals.

Solution 3

Open Files Directly from OneDrive or SharePoint

For users who do have a supported build (or upgraded to Microsoft 365), AutoSave only activates if the file is explicitly opened from a cloud location.

Free Microsoft Office alternative

Switch to WPS Office for Built-In Cloud Sync and Auto Backup

Tired of dealing with confusing license restrictions and missing AutoSave features in Excel 2019 or 2021? WPS Office provides a free, lightweight alternative with seamless cloud synchronization and reliable auto-backup features, ensuring your spreadsheets are always safe without needing an expensive subscription.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Sign In for Cloud Sync: Create a free account or sign in to activate WPS Cloud, enabling automatic backups for all your files.
3. Open and Edit Safely: Open your existing Excel (.xlsx) files in WPS Spreadsheet and enjoy peace of mind with continuous auto-saving.

Includes WPS Spreadsheet, a robust alternative to Microsoft Excel with perfect compatibility for .xlsx formats.Built-in Cloud Sync automatically saves your documents across Windows, Mac, iOS, and Android devices.Completely free to use, saving you from expensive recurring subscription fees.Familiar user interface means zero learning curve when migrating from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why is AutoSave showing in Word but not in Excel?

This can happen if the Word document is saved and opened directly from OneDrive, while the Excel file is stored locally. It may also occur due to version-specific bugs in how Office 2019 or 2021 interacts with OneDrive sync for different applications.

What is the difference between AutoSave and AutoRecover?

AutoSave is a real-time saving feature primarily for Microsoft 365 users that instantly syncs changes to OneDrive or SharePoint. AutoRecover is a legacy feature available in all versions (including 2019 and 2021) that creates a local backup copy of your file at specified minute intervals in case of an unexpected crash.

Can I get the real-time AutoSave toggle in Excel 2019 or 2021?

Generally, no. The real-time AutoSave toggle located in the title bar is exclusively designed for Microsoft 365 subscriptions. Excel 2019 and 2021 users must manually save or rely on the AutoRecover feature to prevent data loss.

Office App Problems