File Sharing Problems

Fix Excel Sharing Violations When Saving XLSM Files to Google Drive on Mac

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user needs to save an Excel XLSM workbook to a Google Drive folder on a Mac without a sharing violation.

Product
Microsoft Excel and Google Drive for desktop
Device & OS
macOS
Scenario
An XLSM workbook was copied from OneDrive to a Google Drive File Stream folder and then edited in Excel.
Observed behavior
Excel reports a sharing violation and creates temporary files when saving. Repeated attempts may also produce format warnings.
Before you start

Confirm that Google Drive for desktop is running and that the workbook is not open on another device or in another app. Check that you can edit the destination folder in Finder.

Solution 1Recommended

Grant Full Disk Access to Excel and Google Drive

Use this fix when Excel reports a sharing violation while saving to a Google Drive folder on macOS.

1
Open privacy settings

On your Mac, open Apple menu > System Settings > Privacy & Security > Full Disk Access. On older macOS versions, open System Preferences > Security & Privacy > Privacy > Full Disk Access.

2
Enable access for both apps

Turn on Full Disk Access for Microsoft Excel and Google Drive. If an app is missing, use the add button and select it from Applications; authenticate if prompted.

3
Restart and test

Quit Excel and Google Drive, reopen both apps, then open the workbook from its Google Drive folder and select File > Save.

Check both permissions: Granting access to Excel alone may not resolve the issue; check Google Drive as well.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move existing files. It does not fix Excel's Google Drive sharing violation; check macro support before relying on it for XLSM workbooks.

Open and edit spreadsheets in a familiar interfaceCompatible with common Excel formats, including XLSXWork with spreadsheet files stored locally or in a synced folderMove existing Office documents into a lightweight, easy-to-use suite
QA img-9

Frequently Asked Questions

Why does Excel create temporary files when a save fails?

Excel uses temporary files during the save process. If a sharing violation interrupts the save, some may remain. Close the workbook and confirm the saved file is intact before removing any leftovers.

Do I need to grant Full Disk Access to both Excel and Google Drive?

In the reported case, enabling Full Disk Access for both apps resolved the issue. Check both under System Settings > Privacy & Security > Full Disk Access, then restart the apps.

Can this sharing violation happen with an XLSX file too?

Yes. A similar problem was reported with a new XLSX file without macros, so the issue is not necessarily caused by the XLSM format or VBA.

What happens if I save an XLSM workbook as XLSX?

The XLSX format does not retain VBA macros. In Excel's File > Save As dialog, keep the macro-enabled XLSM format if the workbook contains macros you need.