Why Excel Sheet Protection Is Lost When Opened in Apple Numbers
Question details
The user needs to understand why locked cells and worksheet protection are not enforced when an XLSX file is opened in Apple Numbers instead of Microsoft Excel.

- Product
- Microsoft Excel (XLSX), Apple Numbers, WPS Office Spreadsheets
- Device & OS
- macOS / iOS (Apple Numbers)
- Scenario
- The user downloads an XLSX workbook and opens it in Apple Numbers, expecting Excel worksheet protection to remain active.
- Observed behavior
- Apple Numbers does not read or enforce all Excel sheet protection settings, so locked cells, password protection, sorting, and filtering controls may be lost or ignored.
Before choosing a fix, confirm the XLSX file still has protection enabled by opening it in Microsoft Excel or WPS Office. Note the protection type, such as locked cells, password protection, sorting, and filtering rules, so you can verify it after switching apps.
Open the Protected XLSX in WPS Office Spreadsheets to Preserve Worksheet Protection
Use this method when you do not have Microsoft Excel and need a free way to keep Excel locked cells, passwords, sorting, and filtering rules active on your Mac or Windows PC.
Apple Numbers does not read or enforce all XML-based Excel sheet protection. WPS Office Spreadsheets opens XLSX files natively, so Excel worksheet protection remains readable and active.
Launch WPS Office, click Spreadsheets, then go to File > Open and select the downloaded XLSX file.
Go to the Review tab and click Protect Sheet to see whether protection is active and to enter the sheet password if prompted.
Select a locked cell and try to edit it, then test sorting and filtering restrictions to confirm that the Excel protection settings are still enforced.

Open the Workbook in Microsoft Excel for Mac or Windows to Confirm Protection
Use this method when you have Microsoft Excel and need to verify the original XLSX sheet protection exactly as Microsoft Office created it.
Open Protected Excel Workbooks in WPS Office Without Losing Sheet Protection
WPS Office Spreadsheets reads XLSX worksheet protection directly, so you can keep locked cells, password restrictions, sorting rules, and filtering rules enforced without relying on Apple Numbers or Microsoft Excel.
- 1. Download WPS Office Free: Visit the official WPS Office download page and install WPS Office on your Mac or Windows PC.
- 2. Open the protected workbook in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, then use File > Open to select the XLSX file.
- 3. Check worksheet protection: Go to the Review tab and click Protect Sheet to confirm that the worksheet protection is active.
- 4. Verify locked cells and restrictions: Try editing a locked cell and test the sorting and filtering controls to confirm the Excel protection settings are enforced.

Frequently Asked Questions
Does Apple Numbers support password-protected Excel sheets?
Apple Numbers can open many XLSX files, but it does not fully enforce all Excel worksheet protection. Password-protected sheet rules, locked cells, sorting restrictions, and filtering restrictions may be lost or ignored. Open the file in Microsoft Excel or WPS Office to preserve them.
Why do locked cells become editable in Apple Numbers?
Excel sheet protection is stored in the sheet XML inside the XLSX file. Apple Numbers does not read or enforce all of that XML protection information, so locked cells appear editable. Use Excel or WPS Office to open the same file and keep the protection active.
Can I reapply Excel sheet protection after opening the file in Apple Numbers?
Apple Numbers has limited worksheet protection controls and may not recreate an Excel-equivalent protected sheet. Open the original XLSX in Microsoft Excel or WPS Office and go to Review > Protect Sheet to confirm or restore the protection.
Will WPS Office preserve Excel sorting and filtering restrictions?
WPS Office Spreadsheets is designed for XLSX compatibility and can open workbooks with Excel sheet protection. Check the protection under Review > Protect Sheet, then test sorting and filtering to confirm the restrictions are still enforced.




