Fix an Excel Worksheet That Opens Protected and Cannot Be Edited
Question details
The user needs to identify and remove the restriction preventing edits to an Excel worksheet after a Windows update.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- A workbook is opened in Excel after a Windows update, and the user wants to edit its worksheet.
- Observed behavior
- The workbook opens in a protected or restricted state and does not allow editing.
Open the workbook and note any security banner or message, including whether it mentions Protected View, read-only access, or a protected sheet. Check whether the file is stored locally, on OneDrive, or on SharePoint.
Enable editing for a trusted workbook in Protected View
Use this solution when Excel displays a yellow Protected View security bar.
Open the workbook in Excel and look for a yellow Protected View bar near the top of the window.
Confirm that you trust the file and its sender before allowing editing, especially if it was downloaded or received as an attachment.
Select Enable Editing on the yellow bar. If the workbook still cannot be edited, check for sheet protection or file permissions.

Check worksheet and workbook protection
Use this solution when editing is blocked by protection settings rather than a Protected View banner.
Check read-only settings and file permissions
Use this solution when the file opens read-only or your account lacks permission to edit it.
Edit Compatible Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working in a familiar environment; existing passwords and access permissions still apply.

Frequently Asked Questions
How can I tell whether Excel is using Protected View?
Look for a yellow Protected View bar near the top of the workbook. If you trust the file and its source, select Enable Editing on that bar.
Why can't I edit cells after enabling editing?
The worksheet may still be protected. Select the affected sheet and check Review > Unprotect Sheet. You may need a password from the owner.
What should I do if a OneDrive workbook is view-only?
Confirm that you are signed in to the account with access, then ask the file owner to grant edit permission through OneDrive or SharePoint.
Does workbook protection prevent all cell edits?
Not necessarily. Workbook structure protection typically restricts actions such as adding or renaming sheets. To check cell-editing restrictions, look for sheet protection under Review.
Can a Windows update cause Excel to open a file as protected?
A change in security settings or policies may affect how a file opens, but the exact cause depends on the message shown. Check Protected View, file properties, and permissions first; ask your IT administrator about security policies if needed.




