File Cannot Open

Fix Excel for Mac Grant Access and Workbook Opening Errors

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user needs to open Excel workbooks on a Mac without repeated Grant Access prompts or file-opening errors.

Fix Excel for Mac Grant Access and Workbook 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.
Before you start

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.

Solution 1Recommended

Check Excel's macOS privacy permissions

Use this when macOS privacy controls may be blocking Excel from accessing the workbook.

1
Open privacy settings

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.

2
Allow Excel 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.

3
Restart and test

Reopen Excel and use File > Open to select the affected workbook. If macOS asks for access, review and approve the prompt.

Check Excel's macOS privacy permissions
Permission may not be the only cause: Full Disk Access may not resolve every sandbox or automation issue. If the error continues, test a local copy and check whether the problem is specific to the workbook.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in WPS Spreadsheet on MacCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree, lightweight alternative for everyday office work
microsoft office alternative - wps office

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.