How to Prevent Apple Numbers from Unlocking Protected Excel Workbooks
Question details
The user needs to prevent Apple Numbers from bypassing or removing worksheet protection features in Excel files, particularly for self-grading tests where an open-password cannot be used.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Distributing a protected, self-grading Excel test to students or users without allowing them to bypass locked formula cells by opening the file in Apple Numbers.
- Observed behavior
- Apple Numbers opens standard .xlsx files but often ignores or removes the worksheet protection, allowing unauthorized modifications to restricted cells.
Ensure you have a backup of your original Excel workbook before changing file formats, as macros and certain specific formatting might behave differently during the transition.
Save the Workbook as an Excel Binary File (.xlsb)
Apple Numbers does not support the .xlsb format, which effectively prevents users from opening and bypassing the protection in Numbers while keeping Excel features fully intact.
By saving the file as a binary workbook, users on Apple devices will be forced to use Microsoft Excel or a fully compatible alternative like WPS Office to open the test, ensuring your cell protections remain enforced.
Open your protected .xlsx workbook in Microsoft Excel or WPS Office.
Click on 'File' (or 'Menu') and select the 'Save As' option.
In the file format dropdown menu, select 'Excel Binary Workbook (*.xlsb)'.
Click 'Save'. Distribute this .xlsb version to your students or recipients.

Require a Password to Open the Workbook
If you are able to distribute a password to your users, encrypting the file at the workbook level will prevent Apple Numbers from opening it without authorization.
Export the Workbook as a PDF
If recipients only need to read the content and do not need to interact with self-grading features or input fields, a PDF is universally secure against unauthorized editing.
Use WPS Office to Create and Protect Binary Workbooks
WPS Office Spreadsheet provides robust worksheet protection and fully supports creating and saving in the .xlsb format, ensuring your self-grading tests remain secure and cannot be bypassed by unsupported applications like Apple Numbers.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your self-grading test or spreadsheet.
- 2. Apply worksheet protection: Go to the 'Review' tab and select 'Protect Sheet' to lock your formula cells.
- 3. Configure protection settings: Enter a protection password and check the allowed permissions for users.
- 4. Save as Excel Binary format: Click 'Menu', select 'Save As', and choose 'Excel Binary Workbook (*.xlsb)' from the dropdown.
- 5. Share securely: Distribute the .xlsb file. Users will need a compatible suite like WPS Office or Excel, preventing Apple Numbers from bypassing the lock.

Frequently Asked Questions
Why does Apple Numbers bypass Excel worksheet protection?
Apple Numbers uses a different file architecture and does not natively support all advanced Excel features. When it translates an .xlsx file into its own environment, it often drops worksheet-level protections, allowing users to view and edit previously locked cells.
Can I completely prevent Apple Numbers from opening an .xlsx file?
Not natively within the .xlsx format unless you apply a file-open password (encryption). If you cannot share a password for a test environment, changing the format to .xlsb is the most effective workaround, as Numbers currently lacks support for opening binary workbooks.
Does saving as .xlsb affect my Excel macros or formulas?
No, the .xlsb (Excel Binary Workbook) format supports all standard Excel features, including complex formulas, macros, and conditional formatting. It simply stores the data in a binary format rather than XML, which makes it smaller and faster to open in fully compatible spreadsheet software.




