Excel Protect Workbook Greyed Out? Fix It

Errors & fixes · Updated November 22, 2026

If the Protect Workbook button in Excel is greyed out, it usually means the workbook is already protected, or you are in a mode that disables the command (such as editing a sheet in a shared workbook, or the file is in compatibility mode). The quickest fix is to check whether the workbook structure is already locked: go to Review > Protect Workbook and if it appears highlighted (not greyed), click it to unprotect, then reapply if needed. If it remains greyed out, the cause is likely the workbook being in Shared Workbook mode (legacy), or the file is saved in an older format like .xls.

Why Is Protect Workbook Greyed Out?

The Protect Workbook command (which locks the structure – sheets can’t be moved, deleted, hidden, or renamed) is greyed out for a few specific reasons. The most common is that the workbook is already protected. When a workbook is protected, the button appears “pressed” (highlighted) but still clickable – so a greyed-out state is different. The real culprits are:

  • Shared Workbook mode: If you turned on Share Workbook (Review > Share Workbook – legacy feature), many protection commands are disabled, including Protect Workbook. You must turn off sharing first.
  • Compatibility mode: If the file is saved as .xls (Excel 97-2003), some features are limited. Save as .xlsx to enable all commands.
  • Protected View: If the file opened from the internet or an email, it may open in Protected View. Click Enable Editing to leave that mode.
  • Sheet protection vs. workbook protection: The button is for workbook structure. If you only want to lock cells, you need Protect Sheet – a different button that is often confused.

How Protect Workbook Actually Works

Protecting a workbook locks its structure – meaning users cannot insert, delete, rename, move, hide, or unhide sheets. It does not lock cells or prevent editing of data. To protect cell contents, you must use Protect Sheet (Review > Protect Sheet) or lock specific cells via Format Cells > Protection.

When you click Protect Workbook (the one with a padlock icon), you get a dialog asking for a password (optional). If you set a password, users need it to unprotect. If you leave it blank, anyone can unprotect without a password – it’s just a deterrent, not real security. The command is actually a toggle: clicking it again unprotects.

Step-by-Step to Fix the Greyed-Out Button

Follow these steps in order, testing the button after each one:

  1. Check if the workbook is already protected: Go to Review > Protect Workbook. If it’s highlighted (not greyed), click it to unprotect. If it’s greyed, continue.
  2. Turn off Shared Workbook: Go to Review > Share Workbook (legacy). If the checkbox “Allow changes by more than one user” is ticked, untick it and click OK. Excel may ask to save – do so.
  3. Save as .xlsx: Click File > Save As and choose “Excel Workbook (*.xlsx)” instead of .xls.
  4. Exit Protected View: Look at the yellow bar at the top – click Enable Editing.
  5. Check for add-ins or macros: Rarely, a COM add-in can disable the button. Try starting Excel in Safe Mode (hold Ctrl while launching) to test.

After these steps, the button should be active. If it’s still greyed, the file might be corrupt – try copying the data to a new workbook.

Protect Workbook vs Protect Sheet – What’s the Difference?

This is the most common confusion. Protect Sheet locks cells, formatting, and other sheet elements – it’s what you use to prevent someone from editing data. Protect Workbook locks the sheet structure – it stops someone from adding or deleting sheets. They are independent. You can protect both, but you must use the correct button for your goal.

For example, if you want to prevent a user from changing a formula in cell B2, you need to protect the sheet. If you want to prevent them from hiding a tab, you protect the workbook. Many users click “Protect Workbook” thinking it locks everything, then get frustrated when cells are still editable.

Common Problems and Their Quick Fixes

  • “Protect Workbook” is greyed out but I never shared it: Check if the file is in compatibility mode – save as .xlsx.
  • I can’t unprotect because I forgot the password: There is no built-in way to recover a lost workbook password. You can try third-party tools, but they are not guaranteed. Always keep a backup.
  • Protect Workbook works, but I can still edit cells: That’s normal – you need Protect Sheet for that.
  • Button is greyed out on a Mac: On Excel for Mac, the button is under Review > Protect Workbook. The same causes apply, but the shared workbook feature is only available in the Windows version – if you opened a Windows shared workbook on Mac, you may need to unshare it on Windows first.
  • Excel for the web: The web version does not support Protect Workbook at all – the button is missing. You must use the desktop app.

How to Actually Protect a Workbook (When the Button Works)

Once the button is active, here’s the proper way to protect a workbook structure:

  1. Go to Review > Protect Workbook.
  2. In the dialog, check the box “Structure” (it’s the only option).
  3. Enter a password (optional). If you do, you’ll be asked to confirm it. Write it down – there’s no recovery.
  4. Click OK. Now the sheet tabs are locked – right-clicking a tab shows “Insert”, “Delete”, “Rename”, etc. are greyed out.

To unprotect, click the same button, enter the password, and it’s done. Note that this is not encryption – it’s a simple lock that can be bypassed by copying the file or using VBA. For real security, use File > Info > Protect Workbook > Encrypt with Password – that encrypts the whole file.

Frequently Asked Questions

Why is Protect Workbook greyed out in Excel 365?
The most common reason is that the workbook is already shared (legacy Share Workbook). Turn that off from Review > Share Workbook. Also check if the file is in compatibility mode – save as .xlsx.

Can I protect a workbook without a password?
Yes. Just leave the password field blank when you click Protect Workbook. It will still lock the structure, but anyone can unprotect it by clicking the button again. It’s not security, just a deterrent.

Does Protect Workbook stop people from editing cells?
No. It only locks the sheet structure (moving, deleting, renaming sheets). To stop cell editing, use Protect Sheet.

How do I unprotect a workbook if I forgot the password?
There is no official way to recover it. You can try copy-pasting all sheets to a new workbook – but that only works if the sheets aren’t protected individually. For real protection, always keep a backup of the password.

Why is Protect Workbook missing in Excel for the web?
The web version doesn’t support workbook structure protection. You need the desktop app (Excel for Windows or Mac) to use this feature.

Alternatives to Protect Workbook

If your goal is to prevent changes, consider these stronger options:

  • Encrypt the file: File > Info > Protect Workbook > Encrypt with Password. This requires a password to open the file – the strongest protection.
  • Mark as Final: File > Info > Protect Workbook > Mark as Final. This makes the file read-only and disables editing, but it’s easy to turn off.
  • Restrict editing (Windows only): File > Info > Protect Workbook > Restrict Access (if your organization uses Information Rights Management).
  • Save as PDF: If you only need to share a static view, export to PDF – no one can edit it.

Remember, Protect Workbook is a convenience feature, not a security barrier. For sensitive data, always use encryption.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.