OneDrive File Issues

Why Excel AutoSave Works Only with OneDrive

Emma BrownEmma Brown Nov 13, 2026 868 views

Question details

The user wants to understand why Excel AutoSave is available only for Microsoft 365 files stored in OneDrive, OneDrive for Business, or SharePoint Online, and what to do when saving elsewhere.

Why Excel AutoSave Works Only with OneDrive
Product
Microsoft Excel (Microsoft 365)
Device & OS
not provided
Scenario
User is working in Excel and expects AutoSave to protect changes, but finds it inactive or missing for files outside OneDrive or SharePoint Online.
Observed behavior
Excel AutoSave remains unavailable for files saved to local drives, network shares, or unsupported third-party cloud services; those files rely on AutoRecover and manual saving.
Before you start

Check where the current workbook is saved and confirm you are signed in with the Microsoft 365 account that has access to OneDrive or SharePoint Online.

Solution 1Recommended

Move the Excel Workbook to OneDrive or SharePoint Online to Enable AutoSave

Use this solution when you need real-time AutoSave, version history, and collaboration for Excel files.

Excel AutoSave requires the Microsoft 365 cloud infrastructure because OneDrive and SharePoint Online store the file continuously, track changes, and support co-authoring. A local or third-party cloud copy cannot provide the same live connection.

1
Sign in to Microsoft 365 in Excel

Open Excel and sign in with your Microsoft 365 work, school, or personal account that has OneDrive or SharePoint Online access.

2
Use Save As and choose OneDrive

Click File > Save As, then select OneDrive, OneDrive for Business, or SharePoint Online as the destination.

3
Turn on AutoSave

After the file is saved to the supported cloud location, confirm the AutoSave toggle in the top-left corner is set to On.

Move the Excel Workbook to OneDrive or SharePoint Online to Enable AutoSave
AutoSave ready: Once the file is stored in OneDrive or SharePoint Online, Excel saves changes automatically while you edit.
Free Microsoft Office alternative

Get WPS Office for Free Cloud-Friendly Editing Without Microsoft AutoSave Limits

WPS Office is a free, lightweight, easy-to-use Office alternative that opens and saves Excel workbooks in .xlsx format, offers a familiar interface, and works with your local files or WPS cloud storage without locking core saving features to Microsoft OneDrive.

  1. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
  2. 2. Install and launch WPS Office: Open the installer, follow the prompts, and launch WPS Office after installation.
  3. 3. Open your Excel workbook: Click the File menu or use the home screen to open an existing .xlsx workbook and continue editing.
Free to download and use for everyday spreadsheet tasksOpens, edits, and saves Microsoft Excel .xlsx files with formatting preservedFamiliar ribbon-style interface for a smooth switch from Microsoft ExcelLocal file control plus optional WPS cloud storage without AutoSave restrictionsLightweight performance with Word, Excel, and PDF tools in one suite
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel AutoSave work with Dropbox or Google Drive?

No. Excel AutoSave is designed for Microsoft 365 files stored in OneDrive, OneDrive for Business, or SharePoint Online. Files in Dropbox or Google Drive are treated as non-AutoSave locations.

Can I turn on AutoSave for a local Excel file?

No. A workbook must first be saved to OneDrive or SharePoint Online. For local files, enable AutoRecover and save manually.

Why is my AutoSave toggle grayed out in Excel?

The toggle is usually grayed out because the file is not saved to OneDrive or SharePoint Online, you are not signed in to Microsoft 365, or the file format is not compatible.

Does WPS Office have an AutoSave feature?

WPS Office includes its own document protection and recovery options, and it can open and save .xlsx files. However, Excel AutoSave is a Microsoft 365 feature tied to OneDrive or SharePoint Online.