Office Settings & Configuration

Fix Excel AutoSave Missing for a Shared Workbook

Maira Mehtab Sep 20, 2026 869 views

Question details

A user is attempting to find and enable the AutoSave feature while editing a shared Excel workbook, but the option has completely disappeared from their interface.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Collaborating on a shared workbook hosted on OneDrive or SharePoint alongside coworkers.
Observed behavior: The AutoSave toggle is missing or disabled for one specific user, even though other collaborators can see and use the feature. Standard Office repairs and updates have not resolved the issue.

Before you start

Before troubleshooting, verify whether the AutoSave toggle is missing only from this specific shared workbook or if it is completely absent from all your OneDrive and SharePoint files.

Solution 1Recommended

Check Quick Access Toolbar and Sync via Web App

The AutoSave toggle might be accidentally removed from your ribbon, or there may be a temporary synchronization glitch that can be bypassed by launching the file from the web app.

Sometimes UI customizations hide the AutoSave button, making it appear missing. Additionally, launching a shared file directly from Excel for the Web forces the desktop app to establish a fresh sync connection to SharePoint or OneDrive.

Restore AutoSave to Quick Access Toolbar

Open Excel and go to File > Options > Quick Access Toolbar. In the 'Choose commands from' dropdown, select 'All Commands'. Scroll down, select 'AutoSave', click 'Add', and then click 'OK'.

Open the File in Excel for the Web

Navigate to your OneDrive or SharePoint portal in your web browser and open the affected shared workbook.

Force Open in Desktop App

While viewing the workbook in your browser, click the 'Viewing' or 'Editing' dropdown menu on the top ribbon and select 'Open in Desktop App' to launch it in your local Excel program.

File Format Requirement: Ensure the file is saved as a modern .xlsx or .xlsm format. AutoSave does not support older .xls files or CSVs.

Solution 2

Test Excel in Safe Mode and Perform Online Repair

Third-party add-ins or corrupted Office installation files can interfere with the AutoSave and co-authoring functionality.

Free Microsoft Office alternative

Try WPS Office for Seamless Cloud Collaboration

If Microsoft Excel's AutoSave continues to cause issues, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust built-in cloud sync, ensuring your edits are always safe when working on shared workbooks.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
2. Open Your Shared Workbook: Launch WPS Spreadsheets and open your existing .xlsx file without worrying about format conversion.
3. Enable Cloud Backup: Log in to your WPS account, save the file to WPS Cloud, and enable Auto-Backup to keep your data secure continuously.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in WPS Cloud functionality for real-time auto-saving and backups.Free to use with a lightweight installation that won't bog down your system.Familiar ribbon interface for a zero-learning-curve migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the AutoSave button completely greyed out in Excel?

AutoSave is only available when the file is saved to Microsoft cloud services like OneDrive, OneDrive for Business, or SharePoint Online. If the file is saved locally or is in an older format like .xls, the toggle will be disabled.

Does AutoSave work on local network drives?

No. Microsoft Excel's native AutoSave feature does not support standard local network drives or third-party cloud storage solutions out of the box. It strictly requires OneDrive or SharePoint integration.

Can a coworker accidentally turn off AutoSave for everyone?

If a coworker opens the shared workbook using a version of Excel that doesn't support co-authoring, or if they add a feature that blocks simultaneous editing (like certain macros or data encryption), it can temporarily disable AutoSave for all other users currently in the file.

How do I recover changes if AutoSave failed on a shared document?

You can check for uncommitted changes by going to File > Info > Manage Workbook and looking under 'Unsaved Workbooks'. Alternatively, check the local AutoRecover directory on your PC, usually located at C:\Users\[Username]\AppData\Roaming\Microsoft\Excel\.

Office App Problems