Fix Microsoft Excel Error 1004: Cannot Access Read-Only Document on Mac
Question details
User needs to resolve Excel Error 1004 on macOS when a macro cannot access a workbook because of folder permissions or read-only file status.

- Product
- Microsoft Excel for macOS
- Device & OS
- macOS
- Scenario
- Running a macro in Excel for macOS and the workbook is blocked by restricted folder access or read-only status.
- Observed behavior
- Excel displays Error 1004: Cannot access read-only document, and the macro cannot access the workbook.
Before changing permissions, close the workbook and confirm whether the file is stored in Desktop, Documents, or another macOS-protected folder. Also check whether the workbook or its folder is marked read-only.
Grant Excel Folder Access in macOS Privacy Settings
Use this first when Excel Error 1004 appears because macOS blocks Excel from opening a workbook outside an approved folder, such as Desktop or Documents.
macOS privacy controls can prevent Excel from accessing certain folders, especially when a macro tries to open a workbook.
Open System Preferences > Privacy & Security > Privacy, or open System Settings on newer macOS versions and go to Privacy & Security.
Select Files and Folders or Full Disk Access, find Microsoft Excel, and enable access to the folder that contains the workbook, such as Desktop or Documents.
Close and reopen Excel, open the workbook, and run the macro again to confirm that Error 1004 no longer appears.

Clear Read-Only Status from the Workbook
Use this if folder access is already granted but the workbook itself is marked read-only, preventing macros from opening or saving changes.
Switch to WPS Office Free for Excel-Compatible Spreadsheets on Mac
WPS Office is a free, lightweight Office suite for macOS that opens, edits, and saves .xlsx and .xls workbooks with high compatibility. It offers a familiar ribbon interface and seamless migration, which can help you keep working when Microsoft Excel macro or permission errors interrupt your workflow.

Frequently Asked Questions
Why does Excel Error 1004 say cannot access read-only document on Mac?
It usually means macOS privacy settings are blocking Excel from accessing the folder, or the workbook has read-only status. Check System Preferences > Privacy and the file's Get Info permissions.
How do I grant Excel permission to access Desktop or Documents on Mac?
Open System Preferences > Privacy & Security > Privacy, select Files and Folders or Full Disk Access, find Microsoft Excel, and enable access to the relevant folder.
How do I clear read-only status from an Excel workbook on Mac?
Select the workbook in Finder, press Command-I, expand Sharing & Permissions, set your account to Read & Write, or uncheck Locked, then reopen the file.
Does WPS Office support Excel workbooks with macros?
WPS Office opens and edits Excel-format workbooks with high compatibility and provides a familiar interface. Macro support varies, so test the file in WPS Office if your workflow relies on complex VBA macros.
Is Error 1004 a WPS Office error?
No, Error 1004 is a Microsoft Excel macro/runtime error. WPS Office does not fix Microsoft Excel itself, but it can open many Excel-format workbooks for routine editing.




