How to Unprotect an Excel Workbook with or Without a Password

Excel protection can prevent accidental edits, restrict worksheet changes, or lock an entire workbook behind encryption. When a workbook needs to be updated, shared, audited, or converted, the owner may need to remove that protection safely and legally. The right method depends on whether the file is protected with a known password, protected without a password prompt, or encrypted so that it cannot be opened at all.

TLDR: If the password is known, workbook or worksheet protection can usually be removed from Excel’s Review or File menu in under a minute. If the password is not known, the safest options are to contact the file owner, check backups, review password managers, or restore an earlier version. For example, in a finance team of 25 people, even a 4% rate of forgotten spreadsheet passwords can affect one critical report every month. Encrypted Excel files cannot be reliably or legitimately opened without the correct password or an authorized recovery process.

Understanding What “Protected” Means in Excel

Before any workbook is unprotected, the type of protection should be identified. Excel uses several protection layers, and each behaves differently.

• Worksheet protection: Prevents changes to cells, formulas, formatting, filters, or objects on a specific sheet.
• Workbook structure protection: Prevents adding, deleting, hiding, unhiding, moving, or renaming sheets.
• File encryption: Requires a password before the workbook can be opened.
• Read only recommendation: Suggests that users open the file as read only, but may not fully prevent editing.
• Information Rights Management or sensitivity labels: Restricts access based on organizational permissions.

Worksheet and workbook structure protection are mainly designed to prevent accidental changes. Encryption, however, is a stronger security feature. If an Excel file cannot be opened without a password, that means the file contents are encrypted and standard recovery is not possible without the correct credentials.

How to Unprotect an Excel Workbook with a Known Password

When the password is known and the user is authorized to make changes, removing protection is straightforward.

To unprotect a worksheet

1. The workbook should be opened in Microsoft Excel.
2. The protected sheet should be selected.
3. The Review tab should be opened.
4. Unprotect Sheet should be selected.
5. The password should be entered if Excel asks for it.
6. The workbook should be saved after protection is removed.

If no password was set, Excel may remove the protection immediately after Unprotect Sheet is selected.

To unprotect workbook structure

1. The workbook should be opened.
2. The Review tab should be selected.
3. Protect Workbook should be clicked.
4. If prompted, the password should be entered.
5. The file should be saved to keep the workbook structure unprotected.

Once workbook structure protection is removed, sheets can usually be renamed, moved, hidden, unhidden, inserted, or deleted again.

To remove password encryption from a file

1. The encrypted workbook should be opened with the correct password.
2. File should be selected.
3. Info should be opened.
4. Protect Workbook should be selected.
5. Encrypt with Password should be clicked.
6. The password field should be cleared.
7. OK should be selected, and the workbook should be saved.

This removes the opening password from the file. Anyone with access to the saved copy may then be able to open it, so the file should be stored in a secure location if it contains sensitive data.

How to Handle an Excel Workbook Without the Password

When the password is missing, the correct approach depends on whether the workbook opens. A workbook that opens but has locked sheets is different from a workbook that cannot be opened at all.

If the workbook opens but sheets are protected

If the workbook can be opened, the owner should first check whether protection was applied without a password. In that case, selecting Review and then Unprotect Sheet or Protect Workbook may remove the restriction without a prompt.

If Excel asks for a password, the next step is not to guess repeatedly or use untrusted tools. Instead, the responsible person should try legitimate recovery paths:

• Contact the creator or previous owner of the workbook.
• Check internal documentation, such as handover notes or process manuals.
• Search approved password managers used by the organization.
• Review shared drive comments or version notes that may mention the password.
• Ask an administrator if the file belongs to a managed business environment.

In many workplaces, spreadsheet passwords are shared during project handovers but not always recorded in a central place. A simple ownership audit can sometimes solve the issue faster than any technical method.

If the workbook cannot be opened

If Excel requests a password before opening the file, the workbook is likely encrypted. In that situation, there is no standard Excel button that removes the password without first opening the file. The correct password, an authorized backup, or an enterprise recovery process is required.

Possible options include:

• Restoring an earlier version from OneDrive, SharePoint, Google Drive, Dropbox, or Windows File History.
• Checking email attachments for an older unencrypted copy.
• Recovering from backups maintained by an IT team.
• Verifying whether a colleague has an accessible copy created before encryption was applied.
• Using organization approved data recovery procedures when the file is business critical.

Third party password removal or cracking tools should be treated with caution. They may expose confidential files, violate company policy, install malware, or fail against modern Excel encryption. If external recovery services are considered, the file owner should verify authorization, data privacy terms, and legal compliance before sharing any workbook.

Making a Safe Copy Before Removing Protection

Before any protection setting is changed, a backup copy should be created. This is especially important for files containing formulas, macros, financial models, customer data, or compliance records.

A reliable workflow includes:

1. Creating a duplicate of the workbook.
2. Renaming the copy with a date, such as Budget Forecast Backup 2026 07 28.
3. Removing protection only from the copy first.
4. Testing formulas, links, pivot tables, and macros after editing.
5. Saving the final version in the correct shared location.

This prevents accidental data loss and keeps a record of the protected original.

Common Reasons Excel Workbooks Are Protected

Protection is often used for practical reasons, not just security. A department may lock formulas so only input cells can be changed. A project manager may protect sheet names to preserve reporting structure. A payroll team may encrypt files that contain personal information.

Because protection may serve an important purpose, it should not be removed without understanding the impact. If formulas become editable, reports can be damaged. If hidden sheets become visible, confidential assumptions may be exposed. If encryption is removed, sensitive information may become easier to share accidentally.

Best Practices After Unprotecting a Workbook

After access is restored, the workbook should be managed more carefully to avoid the same problem later.

• Store passwords in an approved password manager rather than in personal notes.
• Document ownership for important spreadsheets.
• Use separate editing and viewing copies when distributing files widely.
• Protect only what needs protection instead of locking every part of the workbook.
• Use file permissions in SharePoint, OneDrive, or network drives for stronger access control.
• Review protection settings regularly when employees change roles or leave the organization.

For business critical spreadsheets, Excel protection should be part of a wider governance process. Passwords, permissions, backups, and version history all matter more than a single locked worksheet.

FAQ

Can an Excel workbook be unprotected without a password?

Sometimes, but only in limited situations. If no password was actually set, selecting Unprotect Sheet or Protect Workbook may remove the restriction. If a password is required, the safer route is to recover it through the file owner, backups, password managers, or authorized IT processes.

What is the difference between worksheet protection and workbook protection?

Worksheet protection controls edits within a sheet, such as changing cells or formulas. Workbook structure protection controls the workbook layout, such as adding, deleting, hiding, or renaming sheets.

Can an encrypted Excel file be opened without the password?

Modern encrypted Excel files cannot normally be opened without the correct password. A backup, an earlier version, or an approved organizational recovery process is usually required.

Is it safe to use online Excel password removal tools?

Online tools can be risky because the workbook may contain private or business sensitive data. They may also fail, misuse uploaded files, or violate internal security policies. Approved recovery methods are safer.

Should protection be added again after editing?

In many cases, yes. If protection was used to prevent formula changes, preserve structure, or protect sensitive information, appropriate protection should be reapplied after authorized edits are complete.