Can’t Save Excel File on Mac? Fixes That Work
If you can’t save an Excel file on your Mac, the problem is usually a permission issue, a locked file, or a conflict with iCloud or OneDrive syncing. This guide walks through the most common causes and step-by-step fixes to get you saving again.
Why Saving Fails on Mac
Excel for Mac stores files locally or in the cloud, and each location has its own failure points. The most frequent culprits are:
- File permissions: The folder or file is read-only, or your user account lacks write access.
- File lock: The file is marked as locked in Finder or in Excel’s info panel.
- Cloud sync conflicts: OneDrive, iCloud Drive, or Dropbox is holding a lock on the file.
- Excel’s autosave cache: A corrupted temporary file prevents a clean save.
- Disk full or network issue: Not enough space or an unstable connection to a network drive.
Fix 1: Check and Repair File Permissions
macOS uses POSIX permissions to control who can read and write files. If the folder containing your Excel file is read-only, Excel will show a “You don’t have permission” error.
- In Finder, right-click the file or folder and choose Get Info.
- Scroll to Sharing & Permissions at the bottom.
- If your username shows Read only, click the lock icon and change it to Read & Write.
- For the folder itself, also ensure the Apply to enclosed items button is clicked after changing permissions.
If permissions look fine but saving still fails, try repairing disk permissions via Disk Utility (though modern macOS versions handle this automatically, it’s worth a try if other fixes fail).
Fix 2: Unlock the File
A file can be locked in two places: in Finder and inside Excel.
In Finder, select the file, press Command+I, and uncheck the Locked checkbox. In Excel, open the file, go to Review tab, and if “Unprotect Sheet” or “Unprotect Workbook” is available, click it. Also check the file’s Info panel in Excel (File > Info) for a “Protect Workbook” option that might be blocking edits.
Fix 3: Resolve Cloud Sync Conflicts
If your file lives in OneDrive or iCloud Drive, the sync client might be holding a lock. Symptoms include a save that hangs or an error about the file being in use.
- Wait a few minutes and try again—sync conflicts often resolve themselves.
- Check the cloud provider’s menu bar app for sync errors or a paused status.
- Try moving the file to a local folder (like Documents) and saving there. If that works, the cloud sync was the issue.
- For OneDrive, right-click the file in Finder and choose Always keep on this device to force a local copy.
Fix 4: Clear Excel’s Temporary Cache
Excel creates temporary files to track unsaved changes. If these get corrupted, saving can fail. To clear them:
- Quit Excel completely (Command+Q).
- In Finder, press Command+Shift+G and go to
~/Library/Containers/com.microsoft.Excel/Data/Library/Caches. - Delete the contents of the TemporaryItems folder and the com.microsoft.Excel folder inside Caches (Excel will recreate them).
- Restart Excel and try saving again.
This does not delete your actual workbook—only temporary files.
Fix 5: Save As a New File
If nothing else works, use File > Save As (or File > Duplicate then save the duplicate) to create a fresh copy. This bypasses any corruption in the original file’s metadata. Choose a different filename or location, then verify the new file saves correctly.
What to Do If the File Is on a Network Drive
Network drives (SMB, AFP, or a shared server) can have their own permission rules. If you can’t save, try:
- Copying the file to your Desktop, saving there, then copying it back.
- Checking with the network administrator if you have write access to the folder.
- Using File > Export to save a copy locally instead of overwriting the network file.
Frequently Asked Questions
Why does Excel say “The file is locked for editing”?
This usually means another user (or another instance of Excel) has the file open. On a Mac, check if the file is open in another tab or window. If you’re on a shared network drive, ask colleagues to close it. You can also try opening the file in read-only mode and then using Save As to create a new version.
Can I recover an unsaved Excel file on Mac?
Yes. Open Excel, go to File > Open, then click Recent and look for Recover Unsaved Workbooks at the bottom. Excel also autosaves to ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery (or similar path). If you quit without saving, this is the first place to look.
Why does Excel crash when I try to save?
A crash on save often points to a corrupted add-in or a problem with the file’s formatting. Try saving as a different format (e.g., .xlsx instead of .xls) or disabling add-ins in Tools > Add-ins. Also, update Excel via the Mac App Store or Microsoft AutoUpdate—many save-related bugs are fixed in updates.
Does Excel for Mac have the same save features as Windows?
Mostly, but there are differences. The Save and Save As commands work the same, but the keyboard shortcut for Save As is Command+Shift+S (not F12 as on Windows). Autosave for cloud files works if you’re signed into OneDrive, but local files don’t autosave by default.
Why can’t I save to iCloud Drive?
iCloud Drive can fail if the file is too large, if iCloud is paused, or if the folder hasn’t downloaded locally. Check System Settings > Apple ID > iCloud to ensure iCloud Drive is on. If the file is large, try saving to a local folder first, then drag it into iCloud Drive in Finder.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.