Fix Excel Sharing Violations When Saving XLSM Files to Google Drive on Mac
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.
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.
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.
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.
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.
Quit Excel and Google Drive, reopen both apps, then open the workbook from its Google Drive folder and select File > Save.
Turn off Google Drive's Office real-time presence
Try this if the sharing violation continues after checking Full Disk Access.
Save a local copy before moving it to Google Drive
Use a local save to check whether the Google Drive folder or sync process is involved.
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.

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.




