To disable workbook-structure protection in Excel for Microsoft 365 on Windows, open the workbook, choose Review > Protect Workbook, enter the password if Excel asks for it, and confirm. Save the workbook afterward. You need permission to change the file and, if protection is password-protected, the correct password. This turns off restrictions on workbook structure, such as adding, deleting, moving, hiding, or renaming sheets; it does not automatically unprotect individual worksheets or remove a password required to open the file.
What You’ll Need
- The workbook open in desktop Excel. Excel for Microsoft 365 on Windows is the main walkthrough below. If you are using Excel for the web, open the file in the desktop app to manage workbook-structure protection.
- Permission to edit the workbook. A read-only file, restricted folder, or organization policy may prevent you from saving changes even after protection is turned off.
- The protection password, if one was set. Excel asks for it when you remove password-protected workbook structure. The password is separate from any password required to open an encrypted file.
- A safe copy of the file. Save a working copy before changing protection, especially if the workbook is shared or important.
Step-by-Step
- Open the workbook in Excel. Start Excel for Microsoft 365 on Windows and open the file you want to change. If it came from email, a shared drive, or a cloud folder, check that you have opened the correct copy. If the file opens in Protected View, select Enable Editing only if you trust its source and are authorized to edit it. Protected View is a separate security feature; it is not the same as workbook-structure protection.
- Save a separate copy before changing anything. Choose File > Save As, select a location you can access, and give the copy a clear name. If the workbook is stored in OneDrive or SharePoint, make sure you are not unintentionally replacing a shared original. A copy gives you a fallback if you remove restrictions and later discover that other people rely on them.
- Check that workbook structure is what is protected. Select the Review tab and find Protect Workbook in the Protect group. The command may appear selected or highlighted when structure protection is on. This protection applies to the workbook’s sheet organization: it can prevent actions such as inserting, deleting, moving, renaming, hiding, or unhiding sheets. It does not necessarily stop you from changing cell values on an unprotected sheet.
- Do not confuse it with worksheet protection. On the same Review tab, Protect Sheet controls editing on an individual worksheet. If you cannot change cells but can still add or rename sheets, the sheet may be protected instead. If you need to edit cells, select the affected sheet and use Review > Unprotect Sheet, then enter that sheet’s password if prompted. Turning off Protect Workbook alone will not remove worksheet protection, and unprotecting a sheet will not unlock workbook structure.
- Turn off workbook protection. On the Review tab, select Protect Workbook. If Excel displays a password box, type the password for workbook structure and select OK. Passwords are case-sensitive, so check capitalization and keyboard layout. In some builds, the command opens a dialog showing protection options; clear the workbook-structure option and confirm the change. The exact dialog wording can vary slightly by Excel version.
- Confirm that the restriction is gone. Check whether the Protect Workbook command is no longer shown as active. Then try the specific action you needed, such as renaming a sheet tab or inserting a new worksheet. You do not have to make a lasting change just to test it: you can cancel a rename or undo a test insertion before saving. If the action is still blocked, check whether the worksheet itself is protected or whether the file is read-only.
- Save the change. Press Ctrl+S on Windows. If Excel asks whether to save changes, confirm. If the file is shared, wait for the save or synchronization indicator to finish before closing it. If you worked on a copy, verify that you are saving the copy and not the protected original. Reopen the saved copy if practical and check that the workbook remains unprotected.
On Mac: Open the workbook in Excel for Mac, select Review > Protect Workbook, and enter the password when prompted. The ribbon layout and dialog labels may differ slightly from Windows, but the workbook-protection command is on the Review tab. Save with Command+S. On Excel for the web, open the file in the desktop app if you need to remove workbook-structure protection; availability of protection controls in the browser can differ, and the desktop steps are the dependable option.
Common Mistakes
- Choosing Unprotect Sheet for a workbook-structure lock. These are separate protections. If you need to rename or move a tab, use Protect Workbook. If you need to edit locked cells, use Unprotect Sheet on that particular worksheet.
- Assuming the password to open the file is the same one. A password that appears before the workbook opens may encrypt the file. The password requested by Protect Workbook controls structure. One may be set without the other, and knowing one does not guarantee that you know the other.
- Expecting protection removal to fix every editing problem. A file may be read-only, opened from a location where you lack write access, or subject to sharing permissions. A locked cell may also be on a protected sheet. Identify the specific restriction instead of repeatedly clicking the workbook command.
- Saving over the only copy. Removing structure protection may make it easier for someone to change the workbook’s layout. Preserve an original or confirm that the workbook owner wants the protection removed before replacing a shared file.
- Trying passwords without checking carefully. Passwords are case-sensitive. Confirm Caps Lock, the keyboard language, and whether the password includes spaces. Repeated guesses will not reveal the password and may waste time.
Tips
- Ask the workbook owner what needs to change. If you only need to update a value, the owner may be able to unlock the relevant cells or provide an editable copy without removing protections from every sheet or from the workbook structure.
- Keep a note of the protection change. For a shared or business workbook, record who authorized the change, which copy was updated, and whether protection should be restored after the edit. This helps prevent accidental layout changes later.
- Check the file format and save status. Modern Excel workbooks are commonly saved as .xlsx or .xlsm. If you are working with an older format or a file in a synced location, confirm Excel saved the change in the intended file and did not create a second copy with a different name.
- Restore protection only deliberately. If the workbook is meant to keep its sheet structure fixed, select Review > Protect Workbook again after your work and set a password only if you can store it securely and share it with the people who need it.
Troubleshooting
Excel asks for a password you do not know. Contact the workbook creator, owner, or your organization’s file administrator and request the password or an authorized unprotected copy. Check an approved password manager or your team’s documentation if the password was previously recorded. Excel does not provide a supported way to reveal or bypass a forgotten workbook-protection password. Do not assume a password-removal tool is safe; it may damage the file or expose its contents.
The command is unavailable or looks different. Confirm that the workbook is open in desktop Excel and that you are on the Review tab. If the file is opened in a browser, choose the option to open it in the desktop app. If Excel is in a simplified ribbon layout, expand the ribbon or look for the protection command in the Review tab’s available controls. The command may also be inaccessible if the workbook is read-only or your organization has restricted editing.
You can change sheet tabs but still cannot edit cells. Workbook structure may already be unprotected, while the worksheet is protected. Select the affected sheet and use Review > Unprotect Sheet. If Excel asks for a password, you need the worksheet’s password, which may differ from the workbook-structure password.
You cannot save after removing protection. Use File > Save As to save a new copy in a folder where you have permission. Check whether the title bar indicates read-only access, whether another user has locked the file, and whether OneDrive or SharePoint is still syncing. If the workbook is shared, ask its owner or administrator to grant editing access rather than trying to change the protection setting again.
You cannot open the workbook at all. A password prompt before the workbook opens usually indicates file encryption, not Protect Workbook structure protection. You need the opening password from the file owner. If the file is damaged or Excel reports a format problem, make a copy first and ask the owner for a fresh file; disabling workbook structure protection cannot repair an encrypted or corrupted file.
Frequently Asked Questions
Does disabling Protect Workbook delete or change my data?
No. It removes the restriction on workbook structure; it does not, by itself, delete sheets or alter cell contents. However, it allows authorized editors to make structural changes, so save a backup if the original layout matters.
Can I disable it without the password?
If a password protects the workbook structure, Excel requires the correct password to turn that protection off. Ask the owner for it or request an authorized copy. There is no supported password-recovery command in Excel that reveals a forgotten password.
Why can I edit cells but not rename a worksheet?
The workbook structure is likely protected. Use Review > Protect Workbook and enter its password to disable the restriction. Cell editing and sheet-tab changes are controlled by different protection settings.
Is Protect Workbook the same as password-encrypting a file?
No. Workbook-structure protection limits changes to sheet organization after the workbook is open. File encryption requires a password to open the file. Removing structure protection does not remove an opening password or decrypt the workbook.
Will the change apply to everyone who shares the workbook?
It applies to the saved file, so people opening that updated copy will generally see the changed protection state. If someone else has a separate copy, or your edits have not synced, that copy may remain protected. Confirm the correct shared file saved successfully.
Can I do this in Excel for the web?
For workbook-structure protection, use desktop Excel if the browser version does not offer the needed control. In Excel for the web, choose the command to open the workbook in the desktop app, then use Review > Protect Workbook and save your changes.
Related
- How to Delete an Excel File on the Web in OneDrive
- How to Delete an Excel File in Windows 11
- How to Delete an Excel File in a Browser: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Count Cells by Color in Excel: Methods and Their LimitsExcel has no built-in worksheet function that reliably counts cells by fill color alone. For a quick count,…
- How to Insert a Functioning Checkbox in Microsoft WordTo insert a checkbox you can click to check or clear, use Word’s Check Box Content Control: show…
- Can You Group Rows in Excel for Sorting? Here’s HowYes—but Excel’s Group command does not make rows stay together when you sort. To keep related records together,…
- Add an Auto Reply to a Shared Mailbox in Outlook 365To add an automatic reply to a shared mailbox, open that mailbox in Outlook on the web and…
- Goal Seek in Excel: Steps, Examples, and Calc DifferencesIn Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek, then specify the…
- How to Find Double Spaces in a Word Document QuicklyTo find double spaces in a Word, open Home > Find > Advanced Find, enter two presses of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.