An Excel workbook password remover is usually Excel itself: if you know the password, open the workbook, remove the relevant protection in Excel, and save a copy. If you have forgotten a password that encrypts the file for opening, there is no dependable Microsoft-supported remover that can simply reveal or erase it; first look for a backup or ask the file owner.
What “workbook password” can mean
People use “workbook password” to describe several different protections, and the right solution depends on which one you are seeing. The most important distinction is between a password required to open a file and a password that restricts changes after it is open.
- Password to open: Excel asks for the password before showing the workbook. This protects the file’s contents through encryption. Without the correct password, Excel cannot decrypt and display the workbook.
- Worksheet protection: You can see a sheet, but some cells or actions are locked. The sheet’s protection settings may prevent editing, while leaving the workbook readable.
- Workbook-structure protection: You can view the file but cannot add, delete, move, hide, or rename sheets, depending on the restrictions applied.
- Password to modify: A file may open read-only unless you provide a password to make changes. This is different from a password that encrypts the file against opening.
These protections are not interchangeable. Removing sheet protection does not recover a password-to-open, and removing a workbook’s structure restriction does not decrypt an encrypted file. Identify what Excel is asking for before choosing a tool or following instructions.
Remove a password you know in Excel for Windows
For Microsoft Excel for Microsoft 365 on Windows, remove a password-to-open only after opening the workbook with the existing password. Save a separate copy first if the file is important, so you can keep an unchanged original.
- Open the workbook and enter its current password.
- Select File > Info > Protect Workbook > Encrypt with Password.
- In the password box, delete the characters so the box is empty, then select OK.
- Save the workbook. Close it and reopen the saved copy to confirm Excel no longer asks for a password.
If the Encrypt with Password command is unavailable or the file is not encrypted, the restriction may instead be a password to modify, worksheet protection, or workbook-structure protection. For a password to modify, open the workbook and use File > Save As > Browse. In the Save As dialog, select Tools > General Options, clear the password field or fields, and save a new copy. The dialog can vary with the selected file format and Excel build.
To remove protection from a sheet when you know its password, select that sheet and choose Review > Unprotect Sheet, then enter the password if prompted. For workbook structure, use Review > Protect Workbook to turn the protection off and provide its password. Save the file afterward. If the button’s label or state differs, check whether the active workbook has the relevant protection enabled.
Excel for Mac and Excel for the web
On Excel for Mac, open the file with its current password, then use File > Passwords to clear the password for opening or modifying, as applicable, and save the workbook. Menu wording can differ between Mac versions. Sheet and workbook protection controls are on the Review tab; choose the relevant unprotect command and enter the existing password.
Excel for the web is not a substitute for the desktop app when changing file-level password settings. An encrypted workbook may not be editable in the browser, and the web app does not provide the same controls for removing an open password. If a file opens in the browser but a protection option is missing, download or open a copy in the Excel desktop app and use the appropriate steps there. Avoid making an unprotected copy on a shared or public computer.
What happens when a password is forgotten?
A password-to-open is not a label Excel can just switch off: the password is used to unlock the encrypted contents. If you do not have it, Excel cannot display the workbook so that you can remove the setting through its menus. Microsoft does not provide a universal master password or a supported service that decrypts a forgotten workbook password.
Recovery software may try candidate passwords, often using words or patterns you supply. It cannot promise success. A short or predictable password may be easier to guess than a long, unusual one, but the result depends on the password and file. A tool that claims guaranteed, instant recovery for every modern Excel file should be treated with skepticism. Do not confuse password guessing with a legitimate reset feature.
Before considering any recovery service, try practical, authorized routes:
- Ask the person or organization that created the workbook, or check the team’s password manager and documented handover notes.
- Search for an earlier unencrypted copy, an email attachment, a version in a shared drive, or a backup. Check the correct account and location before assuming a file is gone.
- If the workbook is stored in OneDrive or SharePoint, review its available version history. An older version may be useful, although it may not contain the latest edits.
- Look for the source data and rebuild the workbook if that is more practical than attempting recovery. Keep the protected original unchanged.
For a forgotten sheet-protection or structure password, there may be differences in how older and newer Excel formats enforce protection. That does not make every “remover” safe or suitable. If you are not the owner or do not have permission to alter the file, do not attempt to defeat its restrictions; ask the owner or administrator instead.
How to choose a password recovery tool
If you own the file or have clear permission to recover it, evaluate a tool cautiously. A recovery program may need to inspect the workbook locally, while an online service may require you to upload the entire file. A workbook can contain payroll, customer details, formulas, business plans, or confidential data, so uploading it can create a privacy and compliance risk.
- Check what protection it supports. Confirm whether the product addresses a password to open, a password to modify, or sheet and workbook protection. A tool that handles one type may not handle another.
- Read the limits and pricing. Some products let you test a scan but charge to reveal a result. Check refund conditions, supported Excel formats, and whether a successful recovery is guaranteed or only attempted.
- Assess the source. Download only from the vendor’s official site, verify the publisher where possible, and scan downloads with reputable security software. Avoid cracked installers and unsolicited attachments.
- Protect the original. Work from a duplicate and keep the protected file unchanged. Do not let a tool overwrite your only copy.
- Consider organizational rules. If the workbook belongs to an employer or client, ask the data owner or IT team before installing software or sending the file outside the organization.
No recovery product should be given more access than necessary. If you choose a local program, review its permissions and privacy terms. For especially sensitive files, a vendor’s claim that processing is local should be verified rather than assumed.
Costs, risks, and realistic expectations
Removing a password you already know through Excel’s built-in menus does not require a paid remover. Recovery products vary: some offer a free trial or limited scan, while others charge for a license or successful result. Prices, features, and refund policies change, so check the vendor’s current terms rather than relying on an old review. Paying does not guarantee that a forgotten password can be recovered.
There are also risks beyond the fee. A damaged or altered file, malware, loss of confidential information, or an unauthorized change can cost more than the software. Make a backup before experimenting, and do not use a recovery utility on a file you are not authorized to access. If an organization manages the workbook, its administrator may have a safer recovery or backup process.
Common misconceptions and problems
“Unprotect Sheet” will remove any Excel password. It only addresses worksheet protection, and Excel may require the current password. It cannot remove encryption from a workbook that will not open.
Changing the file extension unlocks it. Renaming an .xlsx file to another extension does not decrypt it. It can instead make the file harder to open or damage a workflow that depends on the correct format.
A password prompt means the file is corrupted. A prompt for a password is usually a protection setting, not evidence of corruption. If the correct password is rejected, check for typing errors, keyboard layout, capitalization, and whether you have the right password for that particular file. Passwords may be case-sensitive.
Removing protection always makes a workbook safe to share. An unprotected file may still contain hidden sheets, comments, personal information, external links, or confidential data. Review the contents and sharing permissions before sending it.
Alternatives for future access
Once you regain authorized access, make the file easier to manage without weakening security unnecessarily. Store the password in an approved password manager and document who owns the workbook and how access is handed over. Keep a separate, access-controlled backup, and test that backups can be opened. If different people need different permissions, use the organization’s file-sharing controls rather than passing around one shared password.
For a workbook that should be editable but not casually changed, worksheet protection can prevent accidental edits, but it should not be treated as strong confidentiality protection. For sensitive contents, use appropriate file encryption and restrict access to the storage location. Before removing a password for convenience, consider who can access the resulting file and where it will be stored.
Frequently Asked Questions
Can I remove an Excel workbook password without knowing it?
Not through Excel’s supported password-removal menus. A password-to-open is needed to decrypt the workbook. Check with the owner, search for backups or earlier versions, or consider a reputable recovery tool only if you are authorized and understand that it may fail.
Is a password to open the same as Protect Sheet?
No. A password to open protects access to the workbook’s contents. Protect Sheet restricts changes to a particular worksheet after the workbook is open. Use the matching Excel command for the protection type.
Can Microsoft recover my forgotten Excel password?
Microsoft does not offer a universal master password or a standard service that can decrypt any forgotten password-to-open. If the workbook is managed by an organization, ask its IT team about backups, file history, and approved recovery procedures.
Will removing the password delete formulas or data?
Clearing a known password through Excel and saving should remove that password setting, not intentionally delete workbook contents. Still, save a separate copy first and reopen it to check the result. Recovery tools can behave differently, so preserve the original.
Can I remove an Excel password online for free?
Online services may advertise this, but you would need to consider both their actual capabilities and the privacy risk of uploading the file. A service cannot guarantee recovery of an unknown encryption password. For sensitive workbooks, avoid uploading them unless your organization has approved the service.
Related
- Power Query Union Tables: How to Append Queries
- Data Validation: Definition, Rules, and Examples
- Excel Data Validation Date Picker: Setup and Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Delete Blank Rows in Excel: Keyboard Shortcut GuideTo delete blank rows quickly in Excel for Microsoft 365 on Windows, select a column that should contain…
- Group Rows in Excel: Keyboard Shortcut and StepsTo group rows in Excel for Microsoft 365 on Windows, select the row headers you want to group…
- Excel Row Size: Row Limits, Height, and AutoFit ExplainedIn Excel for Microsoft 365, a worksheet can contain up to 1,048,576 rows, and an individual row can…
- Print Excel Sheets With Gridlines: Settings and FixesYes. In Excel for Microsoft 365 on Windows, select the worksheet, then choose Page Layout > Sheet Options…
- Excel Consolidate Multiple Sheets: Steps and OptionsTo consolidate multiple sheets in Excel for Microsoft 365 on Windows, go to Data > Consolidate, choose a…
- Switch Excel Sheet View: Normal, Page Layout, and MoreTo switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.