File Format & Compatibility

Why Excel Sheet Protection Is Lost When Opened in Apple Numbers

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 868 views

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.

Why Excel Sheet Protection Is Lost When Opened in Apple Numbers
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 you start

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.

Solution 1Recommended

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.

1
Open the workbook in WPS Spreadsheets

Launch WPS Office, click Spreadsheets, then go to File > Open and select the downloaded XLSX file.

2
Check the sheet protection status

Go to the Review tab and click Protect Sheet to see whether protection is active and to enter the sheet password if prompted.

3
Test locked cells and restrictions

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 Protected XLSX in WPS Office Spreadsheets to Preserve Worksheet Protection
Protection preserved: If the worksheet remains protected in WPS Office, continue using WPS Office or Microsoft Excel for future edits and avoid re-saving through Apple Numbers.

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. 1. Download WPS Office Free: Visit the official WPS Office download page and install WPS Office on your Mac or Windows PC.
  2. 2. Open the protected workbook in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, then use File > Open to select the XLSX file.
  3. 3. Check worksheet protection: Go to the Review tab and click Protect Sheet to confirm that the worksheet protection is active.
  4. 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.
Preserves Excel sheet protection, including locked cells and password rulesOpens and saves .xlsx files with Microsoft Excel format compatibilityFree, lightweight, and familiar ribbon interface on macOS and WindowsAvoids relying on Apple Numbers to enforce Excel worksheet security
microsoft office alternative - wps office

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.