Permission & Access Issues

Remove File, Sheet, and Workbook Protection in Excel for Mac

Steve KSteve K Nov 13, 2026 869 views

Question details

The user wants to remove passwords and all worksheet and workbook protection from an Excel file on a Mac.

Remove File, Sheet, and Workbook Protection in Excel for Mac
Product
Microsoft Excel for Mac, version 16.36
Device & OS
Mac / macOS; OS version not provided
Scenario
A previously protected Excel file needs to be saved without file-access passwords, worksheet restrictions, or workbook structure protection.
Observed behavior
The file has protection enabled. File passwords, worksheet protection, and workbook protection must be removed separately.
Before you start

Have the passwords for opening or modifying the file and for any protected sheets or workbook structure ready. A workbook can have multiple protection layers, so removing one does not necessarily remove the others.

Solution 1Recommended

Remove passwords to open or modify the Excel file

Use this method when Excel asks for a password before opening the file or allowing changes.

1
Open the file with editing access

Open the workbook in Excel for Mac and enter the password when prompted. If Excel asks for a password to modify the file, enter it rather than choosing Read Only.

2
Clear the file passwords

Choose File > Save As, then select Options. Delete the entries in the Password to open and Password to modify fields, if present, and select OK.

3
Save the unprotected file

Select Save. If you are saving over the original file, confirm Replace when prompted.

4
Check the saved file

Close the workbook and reopen the saved file. Confirm that it opens without a password prompt and allows editing without a password to modify.

File passwords are separate from sheet protection: Clearing the passwords to open or modify does not turn off worksheet or workbook structure protection. Use the following methods to remove those restrictions.
Free Microsoft Office alternative

Edit your unprotected Excel workbook with WPS Office

After removing protection in Excel for Mac, use WPS Office as a free, lightweight alternative for everyday spreadsheet editing. Its familiar interface and Microsoft Excel format compatibility help you migrate smoothly without recreating your workbook. WPS does not bypass unknown Excel passwords.

Open and edit unprotected spreadsheets after removing Excel file and sheet restrictions.Supports Microsoft Excel .xlsx and .xls formats.Familiar spreadsheet controls make the transition from Excel easier.Free, lightweight Office tools for everyday spreadsheet work.
microsoft office alternative - wps office

Frequently Asked Questions

Why are some cells still locked after I remove the file password?

The password to open or modify a file is separate from worksheet protection. Select the affected worksheet, then choose Tools > Protection > Unprotect Sheet or Review > Unprotect Sheet. Enter its password if prompted and save the workbook.

Do I need to unprotect each worksheet individually?

Yes. Worksheet protection applies to each sheet separately. Click each protected sheet tab, run Unprotect Sheet, and then choose File > Save after finishing.

Which protection prevents me from renaming or deleting worksheet tabs?

Workbook structure protection can restrict those actions. Choose Tools > Protection > Unprotect Workbook, enter the password if prompted, and save the file.

Can I remove protection if I do not know the password?

These steps require the password whenever Excel prompts for one. If no password was set for sheet or workbook protection, the Unprotect command may work without a prompt. Otherwise, ask the file owner for the password or an unprotected copy; these instructions do not bypass passwords.

How can I confirm that all protection has been removed?

Save, close, and reopen the workbook to check that no file password is requested. Then check editing on each worksheet and try a workbook structure action, such as renaming a sheet, to verify that the remaining restrictions are gone.