Permission & Access Issues

Fix an Excel Worksheet That Opens Protected and Cannot Be Edited

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

The user needs to identify and remove the restriction preventing edits to an Excel worksheet after a Windows update.

Fix an Excel Worksheet That Opens Protected and Cannot Be Edited
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.
Before you start

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.

Solution 1Recommended

Enable editing for a trusted workbook in Protected View

Use this solution when Excel displays a yellow Protected View security bar.

1
Check the security bar

Open the workbook in Excel and look for a yellow Protected View bar near the top of the window.

2
Verify the source

Confirm that you trust the file and its sender before allowing editing, especially if it was downloaded or received as an attachment.

3
Enable editing

Select Enable Editing on the yellow bar. If the workbook still cannot be edited, check for sheet protection or file permissions.

Enable editing for a trusted workbook in Protected View
Keep untrusted files protected: Do not enable editing if you cannot verify the file's source.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface to ease migration from ExcelWork with worksheets, formulas, and common spreadsheet toolsInstall a lightweight office suite with a free option
microsoft office alternative - wps office

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.