Permission & Access Issues

How to Fix 'Workbook Is Protected and Cannot Be Changed' Error in Excel

Bushra Parveen Oct 22, 2026 868 views

Question details

The user is unable to copy, move, delete, or rename worksheets because Excel indicates the workbook is protected.

How to Fix the 'Workbook Is Protected and Cannot Be Changed' Error in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to modify the structure of an Excel workbook, such as adding, deleting, or moving individual worksheets.
Observed behavior: Excel blocks the action and displays an error message stating that the workbook is protected and cannot be changed, even if the individual worksheets themselves are unprotected.

Before you start

Verify if you have the correct password for the file, as disabling workbook structure protection will require the original password if one was set by the author.

Solution 1Recommended

Disable Workbook Structure Protection in the Review Tab

Turning off the Protect Workbook feature will remove structural locks, allowing you to rename, move, copy, or delete worksheets again.

Workbook structure protection is independent of worksheet-level protection. Even if your individual sheets are completely unprotected, a locked workbook structure will prevent any sheet-level organizational changes.

Open the Review Tab

Navigate to the top ribbon menu in Excel and click on the 'Review' tab.

Click Protect Workbook

Look for the 'Protect Workbook' button in the Protect group. If it is highlighted or shaded, it means the workbook structure is currently protected. Click it to initiate unprotecting.

Enter the Password

If prompted by a dialog box, type the password originally set for this workbook and click 'OK'.

Disable Workbook Structure Protection in the Review Tab

Lost Passwords: If you do not know the password, you will need to contact the person who originally protected the file, as Excel cannot bypass this security feature natively.

Solution 2

Save a Copy to Troubleshoot File Corruption

If workbook protection is already disabled but you still encounter the error, the file itself or its underlying VBA project might be damaged.

Manage Spreadsheet Security

Easily Protect and Unprotect Workbooks with WPS Office

WPS Office provides a highly intuitive and familiar interface to manage spreadsheet security. You can easily unprotect workbooks or secure your data structure without navigating complicated menus.

1. Open the File in WPS Spreadsheet: Launch WPS Office and open your protected Excel workbook.
2. Navigate to the Review Tab: Click on the 'Review' tab located on the top ribbon menu.
3. Unprotect the Workbook: Click on 'Unprotect Workbook'. Enter the password if prompted, and you will immediately regain the ability to copy, move, or delete worksheets.

Seamlessly manage workbook and worksheet-level protection.Fully compatible with Microsoft Excel (.xlsx, .xls) files and their passwords.Free, lightweight, and fast alternative for all your spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between Protect Sheet and Protect Workbook?

'Protect Sheet' prevents users from editing the contents of individual cells within a specific worksheet. 'Protect Workbook' restricts structural changes, meaning users cannot add, delete, rename, hide, or unhide any worksheets within the entire file, regardless of cell-level protection.

Can I bypass the workbook password if I forgot it?

By default, Microsoft Excel does not provide a native way to bypass or recover a lost password due to security protocols. You must have the original password to unlock the workbook structure.

Why is the Protect Workbook button grayed out?

This usually happens if multiple sheets are currently selected (grouped), if the workbook is a Shared Workbook, or if you are viewing a file in Protected View. Try ungrouping sheets by right-clicking a sheet tab and selecting 'Ungroup Sheets', or enable editing if prompted by a yellow banner at the top of the screen.

Document & File Issues