Fix Excel for Mac Grant Access and Workbook Opening Errors
Question details
The user needs to open Excel workbooks on a Mac without repeated Grant Access prompts or file-opening errors.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Opening local or remotely stored workbooks in Excel for Mac, including files accessed by automated workflows.
- Observed behavior
- Excel may display a Grant Access dialog and then report that a workbook is read-only, encrypted, corrupted, or unavailable.
Note the affected workbook's location and whether the error also occurs when you open the file directly in Excel. If the file is on a server or cloud drive, confirm that the location is connected and accessible in Finder.
Check Excel's macOS privacy permissions
Use this when macOS privacy controls may be blocking Excel from accessing the workbook.
Quit Excel, then 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 Microsoft Excel in the Full Disk Access list. If it is not listed, use the add button and select Microsoft Excel from Applications; authenticate if prompted.
Reopen Excel and use File > Open to select the affected workbook. If macOS asks for access, review and approve the prompt.

Test a local copy and check the workbook
Use a local copy to distinguish a location or access problem from a problem with the workbook itself.
Update Excel and macOS
Use this if the opening error persists across files or after checking permissions and location.
Open workbooks with WPS Office for Mac
WPS Office is a free, lightweight Office alternative with a familiar interface. Its spreadsheet editor supports common Excel formats, making it easy to move between office suites. It does not fix Excel's macOS permissions or sandbox restrictions.

Frequently Asked Questions
Why does Excel keep asking me to grant access on my Mac?
macOS privacy controls or application sandboxing can limit access to some locations. Check Excel under System Settings > Privacy & Security > Full Disk Access, then restart Excel and test the file again.
What should I do if Full Disk Access does not help?
Copy one affected workbook to Documents in Finder and open it through Excel > File > Open. Also test a new workbook to determine whether the issue is tied to the original file or location.
How can I check whether a workbook is locked?
Select the workbook in Finder and choose File > Get Info. Look for the Locked checkbox and review Sharing & Permissions.
Can a server or cloud location cause the error?
Yes. If the location is unavailable or Excel cannot access it, the workbook may fail to open. Confirm the location is accessible in Finder and test a copy in Documents.
Will WPS Office fix Excel's Grant Access prompt?
No. WPS Office is an alternative spreadsheet application, not a fix for Excel's permissions or sandboxing. You can try opening a compatible XLS or XLSX file in WPS Spreadsheet, subject to file access and password requirements.




