Fix Excel for Mac AutoSave Unavailable on OneDrive or SharePoint
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.

- 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.
Ensure that your Mac is connected to a stable internet connection and that you are signed into the correct Microsoft 365 account within Excel.
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.
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).
Scroll down the left sidebar and click on 'Privacy & Security'.
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.
Completely quit and reopen Excel and OneDrive to apply the new permission settings, then open a cloud document to test the AutoSave feature.

Check Microsoft 365 Office Cloud Policies
Your organization's Microsoft 365 IT administrator may have configured a policy that explicitly disables the AutoSave feature across the tenant.
Test AutoSave with Newly Created Files
Determine if the AutoSave issue is specific to a corrupted workbook, a legacy file format, or if it affects all files in your cloud environment.
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. Download WPS Office for Mac: Visit the official WPS Office website and download the macOS installation package.
- 2. Open Your Spreadsheets: Launch WPS Office and directly open your existing Excel workbooks without losing any formatting.
- 3. Enable Cloud Sync: Sign in to your free WPS account to easily save and automatically sync your documents using WPS Cloud.

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.




