Allow Editing of Unlocked Cells in a Protected Excel Worksheet on SharePoint
Question details
Users need to allow editing of unlocked cells in a protected Excel worksheet that has been shared through SharePoint and is opened in Excel for the web.
- Product
- Microsoft Excel for the web / SharePoint
- Device & OS
- not provided
- Scenario
- A workbook works correctly in desktop Excel, but after being shared through SharePoint and opened in Excel for the web, users cannot edit the cells that should be editable.
- Observed behavior
- Cells that should be editable remain blocked in Excel for the web even though the worksheet is protected.
Open the workbook in Excel for the web and confirm that you have edit permission. Identify which cells must remain protected before changing any locking settings.
Unlock the sheet, mark only protected cells as locked, and protect again in Excel for the web
Use this method when a protected workbook is already shared through SharePoint and users cannot edit unlocked cells in Excel for the web.
Excel for the web applies worksheet protection based on the Locked property of each cell. If too many cells are marked Locked when the sheet is protected, cells that should be editable remain blocked. Clearing Locked from all cells, marking only the cells you want protected, and then protecting the sheet again restores the expected editing behavior.
Go to SharePoint, open the workbook in Excel for the web, and make sure you are signed in with edit permissions.
Click the select-all triangle at the top-left corner of the sheet, then right-click and choose Format Cells > Protection. Clear the Locked check box and click OK.
Select the cells or ranges that users must not edit, right-click the selection, choose Format Cells > Protection, check Locked, and click OK.
Go to the Review tab, select Protect Sheet, choose the actions users are allowed to perform such as Select unlocked cells, set an optional password, and click OK.
Refresh or reopen the workbook through SharePoint with a user account that should edit only the unlocked cells and confirm those cells are editable while locked cells remain protected.
Use WPS Spreadsheets to Edit Protected Excel Workbooks Without SharePoint Web Restrictions
When Excel for the web and SharePoint prevent unlocked cells from being edited, WPS Office offers a free, lightweight way to open, inspect, and edit protected workbooks locally with familiar Excel-compatible tools. It supports your existing workbook structure and helps you avoid SharePoint-only editing restrictions.
- 1. Download WPS Office Free: Download WPS Office from the official WPS website and install it on the device where you need to edit the workbook.
- 2. Open the protected workbook in WPS Spreadsheets: Launch WPS Spreadsheets, open the workbook from SharePoint or a local copy, and check whether the unlocked cells are editable.
- 3. Review worksheet protection settings: Use the Review tab and protection options in WPS Spreadsheets to confirm locked and unlocked cell ranges before uploading or sharing the workbook again.
Frequently Asked Questions
Why can users edit unlocked cells in desktop Excel but not in Excel for the web?
Excel for the web applies worksheet protection according to the Locked property of each cell. If the sheet is protected while too many cells are marked Locked, even cells that should be editable remain blocked. Unlock the whole worksheet, lock only the cells that must be protected, and protect the sheet again.
How do I unlock all cells in Excel for the web?
Select all cells, go to Format Cells > Protection, clear the Locked check box, and click OK. This removes the Locked property from the entire worksheet before you reapply protection.
How do I protect only certain cells in Excel for the web?
After unlocking all cells, select the specific cells that should remain protected, open Format Cells > Protection, check Locked, and click OK. Then go to the Review tab and select Protect Sheet.
Does this method work for workbooks shared through SharePoint?
Yes. Apply the Locked and protection settings in Excel for the web or desktop Excel, then share the workbook through SharePoint. Users opening it in Excel for the web will be able to edit the unlocked cells while protected cells remain restricted.
Do I need a password to protect the worksheet?
A password is optional when protecting the sheet. If you set one, keep it because Excel for the web requires the password to change or remove worksheet protection later.
