How to Fix Excel Cannot Save to an External Drive on Mac
Question details
The user is unable to save Excel files to an external or removable drive because macOS privacy permissions were previously denied and no longer prompt.
- Product
- Microsoft Excel
- Device & OS
- macOS Ventura
- Scenario
- Attempting to save a workbook directly to an external USB or hard drive after accidentally denying access to removable volumes during initial setup.
- Observed behavior
- Excel fails to save the file and does not prompt the user for permission again. The application is also missing from the macOS Files and Folders privacy settings.
Ensure that your external drive is properly plugged in, recognized by macOS, and formatted with a Mac-compatible file system such as APFS or ExFAT before modifying system privacy settings.
Enable Removable Volumes Access in Mac Settings
Check the built-in privacy settings to see if Excel is listed and simply toggle the permission back on.
macOS manages access to external storage through the Privacy & Security menu. If you accidentally clicked 'Don't Allow' when Excel previously asked for permission, it restricts the app from writing data to external drives.
Click the Apple menu in the top-left corner of your screen and select System Settings.
Scroll down the left sidebar and click on Privacy & Security, then find and click on Files and Folders on the right pane.
Look for Microsoft Excel in the list of applications. If it is present, toggle the switch next to 'Removable Volumes' to turn it on.
Close Excel completely and reopen it, then try saving your spreadsheet to the external drive again.
Reset macOS Privacy Permissions via Terminal
If Excel is entirely missing from the Files and Folders list, resetting the privacy database forces macOS to ask for permission again.
Contact Apple or Microsoft Support
If the permission prompt still does not trigger after a reset, deeper system-level support may be required.
Try WPS Office for Mac to Save Spreadsheets Flawlessly
If Microsoft Excel continues to struggle with macOS external drive permissions, consider switching to WPS Office. It provides a lightweight, highly compatible alternative that natively supports saving all your spreadsheets directly to external drives without persistent permission bugs.
- 1. Download WPS Office: Visit the official WPS Office website and download the macOS installer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and instantly open your existing .xlsx files with perfect formatting preservation.
- 3. Save to External Drive: Click Save As to seamlessly save your work directly to your USB or external hard drive without privacy prompt issues.
Frequently Asked Questions
Why does Mac ask for permission to access removable volumes?
macOS includes strict data privacy protections. It requires you to explicitly grant applications permission to read and write to external storage devices like USB flash drives and external hard drives to protect your personal files from malicious software.
Will granting Full Disk Access fix the Excel saving issue?
Not always. Full Disk Access is a separate permission tier in macOS. If an application was specifically denied 'Removable Volumes' access under the Files and Folders section, Full Disk Access may not override that specific denial.
What should I do if my external drive is read-only on Mac?
If the drive is formatted in NTFS (the Windows standard), macOS can natively read it but cannot write or save files to it. You will need to copy the files to your Mac, reformat the drive to ExFAT or APFS using Disk Utility, or install third-party NTFS driver software.
Can I manually add an app to the Files and Folders privacy list?
No, macOS does not provide a manual '+' button for the Files and Folders privacy section. Applications must attempt to access the protected area and request access organically. If they fail to prompt, resetting the app's privacy permissions via Terminal is usually the only way to trigger a new request.
