How to Fix Excel Says the Cell or Chart Is Protected
Question details
The user is unable to modify a cell or chart because Excel displays a warning that the worksheet is protected and must be unprotected before editing.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to edit data, modify a chart, or update formatting in a workbook, including shared workbooks that were previously editable.
- Observed behavior
- Excel blocks the edit and shows a pop-up message stating that the cell or chart is on a protected sheet and requires the user to unprotect it.
Verify if you have the password for the workbook, as the original author may have restricted editing. Keep in mind that general shared workbook permissions do not automatically override individual worksheet protection.
Unprotect the Worksheet via the Review Tab
The most direct way to resolve this error is to remove the worksheet protection from the Excel ribbon.
Worksheet protection is designed to prevent accidental changes to critical data. To edit a locked cell or chart, you must disable this protection.
Note that if the sheet was protected with a password, you will need to enter it to proceed. Shared file permissions do not bypass this security feature.
Open your Excel workbook and click on the 'Review' tab located in the top ribbon menu.
Click on the 'Unprotect Sheet' button in the Protect group. If the sheet was protected without a password, it will instantly unlock and you can begin editing.
If a password prompt appears, type the password provided by the document owner or your team, and click 'OK'.
Use WPS Spreadsheet to Edit and Protect Your Workbooks
WPS Office offers full compatibility with Microsoft Excel files. You can easily open your protected .xlsx files, unprotect them to make edits, and re-apply protection using WPS Spreadsheet's highly intuitive interface.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open your protected .xlsx workbook.
- 2. Access the Review tab: Click on the 'Review' tab in the top menu bar to access document security features.
- 3. Unprotect and edit: Click 'Unprotect Sheet', enter the password if required, and instantly resume editing your cells and charts.
Frequently Asked Questions
Why is my Excel sheet protected if it is a shared workbook?
Shared workbook permissions are separate from worksheet protection. Even if a workbook is shared for collaboration, individual sheets can still be locked by the author to prevent accidental changes to specific cells, formulas, or charts.
Can I unlock a protected Excel sheet without the password?
By default, Excel requires the original password to unlock a protected sheet. If you forget or do not have the password, you will need to contact the workbook's creator, as there is no built-in password recovery tool for worksheet protection.
How do I protect specific cells while leaving others editable?
Before protecting the sheet, select the cells you want users to edit, right-click, choose 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'. Then, go to Review > Protect Sheet to lock only the remaining cells.
Does WPS Office support Excel's worksheet protection?
Yes, WPS Office fully supports Microsoft Excel's sheet protection features. You can lock and unlock sheets, as well as set or enter passwords, exactly as you would in Microsoft Excel.
