Office for Mac Issues

Fix Excel for Mac AutoSave Unavailable on OneDrive or SharePoint

Kushani NimanthikaKushani Nimanthika Oct 22, 2026 870 views

Question details

Users are unable to use the AutoSave feature in Excel for Mac for files stored in OneDrive or SharePoint, often accompanied by a yellow server-workbook read-only message.

Fix Excel for Mac AutoSave Unavailable on OneDrive or SharePoint
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Attempting to sync or automatically save Excel workbooks stored in Microsoft cloud locations.
Observed behavior
The AutoSave toggle is missing or unavailable, and a yellow server-workbook message indicates the file is read-only.
Before you start

Ensure that your Mac is connected to a stable internet connection and that you are signed into the correct Microsoft 365 account within Excel.

Solution 1Recommended

Grant Full Disk Access to Office and OneDrive in macOS

macOS privacy settings may be blocking Excel and OneDrive from accessing the necessary system files to perform cloud synchronization and AutoSave.

Starting with macOS Mojave, Apple introduced strict privacy protections that require you to explicitly grant applications permission to access certain folders. If Excel or OneDrive lacks Full Disk Access, AutoSave may fail.

1
Open macOS System Settings

Click the Apple menu in the top-left corner of your Mac's screen and select 'System Settings' (or 'System Preferences' on older macOS versions).

2
Navigate to Privacy & Security

Scroll down the left sidebar and click on 'Privacy & Security'.

3
Enable Full Disk Access

Click on 'Full Disk Access'. Find 'Microsoft Excel', 'Microsoft Word', and 'OneDrive' in the application list. Toggle the switches next to them to the 'On' position.

4
Restart Your Applications

Completely quit and reopen Excel and OneDrive to apply the new permission settings, then open a cloud document to test the AutoSave feature.

Grant Full Disk Access to Office and OneDrive in macOS
Admin Authentication: You will be prompted to enter your Mac administrator password or use Touch ID to modify Full Disk Access settings.
Free Microsoft Office alternative

Try WPS Office for Mac as a Seamless Alternative

If you are struggling with Excel for Mac's AutoSave issues and complex Microsoft 365 tenant policies, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet solution with built-in cloud sync, ensuring your work is saved securely without the hassle.

  1. 1. Download WPS Office for Mac: Visit the official WPS Office website and download the macOS installation package.
  2. 2. Open Your Spreadsheets: Launch WPS Office and directly open your existing Excel workbooks without losing any formatting.
  3. 3. Enable Cloud Sync: Sign in to your free WPS account to easily save and automatically sync your documents using WPS Cloud.
Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV file formats.Built-in WPS Cloud ensures your spreadsheets are automatically backed up and synced.Free, lightweight, and highly optimized for macOS performance.Familiar tabbed user interface, requiring zero learning curve for Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the AutoSave button grayed out in Excel for Mac?

The AutoSave button is typically grayed out if the file is saved locally on your Mac instead of a cloud location (OneDrive or SharePoint), if the file is in an older format like .xls, or if macOS privacy permissions are blocking Excel's cloud sync operations.

What does the yellow server-workbook read-only message mean?

This message indicates that the workbook is locked by the server. This often happens if another user is editing the file in a version of Excel that does not support co-authoring, or if strict check-out policies are enabled in your SharePoint document library.

Can I use Excel's AutoSave with third-party cloud storage like Google Drive or Dropbox?

No, the native AutoSave toggle in Microsoft Excel for Mac only works when files are saved to Microsoft's own cloud services: OneDrive, OneDrive for Business, or SharePoint Online.

How do I ensure my Excel files don't lose data if AutoSave fails?

While troubleshooting AutoSave, you can manually save your work frequently using the Command + S shortcut. Additionally, enable AutoRecover by going to Excel > Preferences > Save to create local backup copies on your Mac at regular intervals.