Office Settings & Configuration

How to Fix Excel 2021 AutoSave Option Missing for OneDrive Files

Anum Mushtaq Oct 19, 2026 869 views

Question details

The user needs to enable or find the AutoSave option for cloud files in Excel 2021.

How to Fix Excel 2021 AutoSave Option Missing for OneDrive Files

Product: Excel 2021 Professional Plus
Device & OS: Windows 11
Scenario: Opening and editing workbooks stored in a linked OneDrive account.
Observed behavior: The AutoSave toggle switch is entirely missing or unavailable in the Excel ribbon, despite functioning normally in Microsoft 365 versions of Word on the same device.

Before you start

Verify that your OneDrive desktop client is actively running in your system tray and successfully signed into the same Microsoft account you are using for Excel.

Solution 1Recommended

Manually Save and Sync Workbooks to OneDrive

Since Excel 2021 does not support the continuous AutoSave toggle, use the manual save function to push updates to the cloud.

Excel 2021 uses a perpetual license, which inherently does not include the real-time AutoSave toggle switch found in Microsoft 365 subscription apps. However, you can still save files directly to OneDrive by triggering a manual save, which will automatically sync the newest version to the cloud.

Locate the Save Icon

Look at the Quick Access Toolbar in the top-left corner of the Excel window for the floppy disk Save icon.

Trigger a Manual Save

Click the Save icon, or alternatively, press 'Ctrl + S' on your keyboard regularly while working on your document.

Verify Cloud Synchronization

Immediately after saving, check the Save icon. A temporary synchronization indicator (small circular arrows) will appear, confirming your latest changes are successfully synced to OneDrive.

Manually Save and Sync Workbooks to OneDrive

Version Limitation: The missing AutoSave toggle is an expected behavior in Office 2021 Professional Plus. It is an exclusive feature reserved for Microsoft 365 subscription versions.

Solution 2

Use Excel for the Web for Real-Time AutoSave

Access your OneDrive workbook via a web browser to utilize automatic saving without upgrading your desktop license.

Free Microsoft Office alternative

Looking for Seamless Cloud AutoSave? Try WPS Office

Avoid confusing version limitations and missing features. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office, complete with an integrated Cloud workspace that automatically saves your files as you work, entirely for free.

1. Install WPS Office: Download and install the free WPS Office suite on your Windows PC.
2. Open Your File: Launch WPS Spreadsheets and open your existing .xlsx workbook.
3. Enable Cloud Sync: Turn on WPS Cloud Auto-Roaming to ensure every edit is automatically saved and backed up to the cloud.

Built-in Cloud Auto-Roaming for automatic real-time document synchronizationFully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formatsFree to use with a familiar, easy-to-navigate tabbed interfaceLightweight software that won't slow down your Windows 11 PC

microsoft office alternative - wps office

Frequently Asked Questions

Why do I have the AutoSave toggle in Word but not in Excel on the same PC?

This happens when Word is installed or activated via a Microsoft 365 subscription, while Excel is running on a perpetual Office 2021 license. The AutoSave toggle switch for cloud files is exclusively tied to Microsoft 365 subscription applications.

Can I manually add the AutoSave button to the Excel 2021 Quick Access Toolbar?

No. Even if you access the Excel Options menu and attempt to customize the ribbon or Quick Access Toolbar to add the AutoSave toggle, the button will remain inactive or grayed out because the underlying feature is not supported in Office 2021.

How do I know if my manual saves in Excel 2021 are actually syncing to OneDrive?

When you click the Save icon or press Ctrl+S, a small circular synchronization arrow will briefly appear over the Save icon in the top-left corner. This visual cue indicates the file has been successfully uploaded to your OneDrive account.

Office App Problems