Fix an Excel Sheet That Won’t Unprotect on SharePoint
Question details
The user needs to remove protection from one worksheet in an Excel workbook stored on SharePoint.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- The user enters the worksheet password and tries to remove protection from a shared workbook.
- Observed behavior
- The worksheet remains protected, although the Manage Protection controls are accessible.
Confirm that you have the worksheet protection password and edit access to the SharePoint workbook. Check the file name and location so you are working with the intended workbook version.
Remove worksheet protection in desktop Excel
Use desktop Excel to distinguish between pausing protection and removing it from the affected worksheet.
In SharePoint, select the workbook and choose Open > Open in app, or use the corresponding Open in Desktop App option.
Click the tab for the worksheet that remains protected, then open the Review tab.
Select Unprotect Sheet and enter the worksheet password if prompted. If you see Manage Protection, use it to turn off sheet protection rather than only pausing protection.
Save the workbook, close it, and reopen it from SharePoint. Select the same worksheet and check whether protection is still off.

Check SharePoint access and co-authoring conflicts
Use these checks if the change does not persist or the workbook behaves differently in the browser.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats. Open existing workbooks to make the transition easier; use Excel and SharePoint to resolve their protection and access issues.

Frequently Asked Questions
Why can I edit a sheet after pausing protection but still see it as protected?
Pausing protection can allow temporary editing without removing the protection settings. Use Review > Unprotect Sheet, or turn off sheet protection through Manage Protection if that option is available.
Do I need SharePoint edit permission to remove worksheet protection?
You need permission to edit and save changes to the workbook. Select the file in SharePoint and open Manage access, or ask the owner to check your access.
What if the password works but the sheet becomes protected again?
Check that you removed rather than paused protection, save the workbook, and reopen it from SharePoint. If the change still does not persist, close other sessions and check for co-authoring conflicts or an incorrect workbook version.
Is worksheet protection the same as workbook protection?
No. Worksheet protection controls changes to a sheet, while workbook protection can restrict changes to the workbook’s structure. Select the affected sheet and use Review > Unprotect Sheet for worksheet protection.




