When you work with protected sheets in Excel, Copilot cannot modify locked cells, insert or delete rows and columns, or change sheet-level protection settings. Protected sheets restrict editing to only unlocked cells, and Copilot must follow the same rules as the user. This article explains exactly which actions Copilot can and cannot perform on a protected sheet, how to configure protection to allow Copilot to help, and what to do when Copilot refuses a request due to protection.
Key Takeaways: Copilot Editing Limits on Protected Sheets
- Review > Protect Sheet > Select unlocked cells: Copilot can edit only cells that are unlocked and that the user has permission to edit under the protection settings.
- Review > Protect Sheet > Protect worksheet and contents of locked cells: Copilot cannot change cell formatting, insert rows or columns, or delete rows or columns on a protected sheet.
- Review > Protect Sheet > Select locked cells (unchecked): Copilot cannot select or modify locked cells even if the user requests a change to those cells.
How Sheet Protection Affects Copilot Commands
Sheet protection in Excel is a security feature that restricts what users can do in a worksheet. When a sheet is protected, the user can only edit unlocked cells and perform actions that the sheet owner explicitly allowed during protection setup. Copilot operates under the same permissions as the user. This means Copilot cannot bypass protection rules. If the user cannot edit a locked cell, Copilot cannot edit it either. If the user cannot insert rows, Copilot cannot insert rows. This design ensures that Copilot does not create a security loophole.
The protection settings are defined when you protect the sheet from the Review tab. The Protect Sheet dialog box lists a set of checkboxes for actions that users can still perform after protection is applied. These actions include selecting locked cells, selecting unlocked cells, formatting cells, inserting or deleting rows and columns, sorting, and using AutoFilter. Copilot respects every one of these settings. For example, if the sheet owner unchecks Format cells, Copilot cannot change font, color, borders, or number formatting on any cell, locked or unlocked.
What Copilot Can Edit on a Protected Sheet
Copilot can edit any unlocked cell on a protected sheet. Unlocked cells are those where the Locked property is unchecked in the Format Cells dialog box before protection is applied. When a user asks Copilot to update a value in an unlocked cell, Copilot can perform that edit. Copilot can also apply formulas to unlocked cells, provided the user did not disable formula editing in the protection settings. Additionally, if the sheet owner allowed AutoFilter during protection, Copilot can filter data on the sheet.
What Copilot Cannot Edit on a Protected Sheet
Copilot cannot edit locked cells under any circumstances. Locked cells are those where the Locked property is checked. Copilot cannot insert or delete rows or columns, even if those actions would affect only unlocked cells. Copilot cannot change cell formatting, including font, fill color, borders, or alignment, unless Format cells was explicitly allowed in the protection settings. Copilot cannot unprotect the sheet or modify the protection password. Copilot cannot add, move, or delete worksheets within the workbook.
Steps to Allow Copilot to Work on a Protected Sheet
If you want Copilot to help edit data on a protected sheet, you must configure the protection settings correctly. Follow these steps to unlock cells and set the right permissions.
- Unlock the cells Copilot should edit
Select the cells you want Copilot to modify. Right-click and choose Format Cells. On the Protection tab, uncheck Locked. Click OK. This step must be done before you protect the sheet. - Protect the sheet with the right permissions
Go to the Review tab and click Protect Sheet. In the dialog box, enter a password if needed. In the list of allowed actions, check Select unlocked cells and any other actions you want Copilot to perform. For example, check Format cells if Copilot should change cell formatting in unlocked cells. Click OK. - Test Copilot with a simple edit request
In the Copilot pane, type a command like Update cell A1 to 100. Copilot should respond that it can perform the edit. If Copilot says the action is not allowed, review the protection settings and the cell lock status.
If Copilot Still Has Issues After the Main Fix
Sometimes Copilot refuses to edit a cell even when the cell appears unlocked. Check these common problems.
Copilot Says It Cannot Edit Because the Sheet Is Protected
This message appears when Copilot tries to edit a locked cell or perform an action that is not allowed. Verify that the cell is truly unlocked by checking the Format Cells > Protection tab. Also confirm that the protection settings include the action Copilot is attempting. For example, if Copilot tries to insert a row but Insert rows is unchecked in the Protect Sheet dialog box, Copilot will refuse.
Copilot Cannot Select Locked Cells for Context
When the sheet is protected and the Select locked cells permission is unchecked, Copilot cannot read the content of locked cells. This means Copilot cannot use locked cell values as context for generating formulas or summaries. To fix this, unprotect the sheet, check Select locked cells in the Protect Sheet dialog, and re-protect the sheet.
Copilot Fails to Apply Formatting to Unlocked Cells
If Copilot cannot change formatting on unlocked cells, the Format cells permission is likely disabled. Unprotect the sheet, check Format cells in the allowed actions list, and re-protect the sheet. Copilot will then be able to apply formatting changes to unlocked cells.
| Action | Protected Sheet (locked cells) | Protected Sheet (unlocked cells) |
|---|---|---|
| Edit cell value | Not allowed | Allowed if Select unlocked cells is checked |
| Apply formula | Not allowed | Allowed if Select unlocked cells is checked |
| Change cell formatting | Not allowed | Allowed only if Format cells is checked |
| Insert or delete rows | Not allowed | Not allowed unless Insert rows/Delete rows is checked |
| Filter data | Not allowed | Allowed only if Use AutoFilter is checked |
| Unprotect sheet | Not allowed | Not allowed |
You can now configure sheet protection to let Copilot edit unlocked cells while keeping locked data secure. To extend this capability, try combining Copilot with named ranges that reference only unlocked cells. This approach lets Copilot generate formulas and summaries based on protected data without directly editing locked cells. For advanced scenarios, use the Review > Unprotect Sheet command temporarily, make changes with Copilot, and then re-protect the sheet with the same password.