A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
If Excel became read-only after a macOS update, use this path:
- Update Office for Mac to the latest supported version. Microsoft states that affected Microsoft 365 apps on macOS can enter reduced functionality mode, where files can be opened, viewed, and printed but not edited, saved, or created. Full functionality is restored after updating to the required version.
- If updates are managed centrally in the organization, contact the help desk instead of troubleshooting further.
- If Excel is still read-only after the update, fully quit the app, reopen it, and then sign out and sign back in from the app’s Account settings.
- Check whether the workbook itself was set to open as read-only:
- In Excel, go to File > Always Open Read-Only.
- If it is checked, clear it.
- If the workbook is only prompting for read-only recommendation:
- Open the workbook.
- Go to File > Passwords.
- Clear Read-only recommended if it is selected.
- If the file was intentionally protected, check whether a password to modify was set:
- Go to File > Passwords.
- A Password to modify can be used to control changes.
Important:
- If a workbook is shared, anyone with Write privileges can clear the read-only status.
- Microsoft cannot retrieve forgotten passwords.