How to remove a password from an Excel workbook

Question

I need to get instructions for How to remove a password from an Excel workbook.

Answer 1

Dear Bragança, Audry,

Welcome to the Microsoft Q&A Forum.

I appreciate the detailed information you provided regarding the issue you are experiencing. Based on your description, it appears that you are having difficulty removing the protection from an Excel workbook, specifically the password that was applied through the Protect Workbook feature.

To help you resolve this, please follow the steps below to remove the existing workbook protection password:

• Open the protected workbook and enter the password when prompted, so that the file can be accessed.
• Navigate to the Review tab on the ribbon.
• Click Protect Workbook again.
• When prompted, re‑enter the same password to remove the protection.

Once these steps are completed, the workbook should no longer be protected, and you will be able to modify its structure without restriction.

For your reference, you may also review these Microsoft Support articles, which provide additional details on managing workbook passwords and protection settings:

• Require a password to open or modify a workbook
• Change or remove workbook passwords

If you have any further questions, need more clarification, or encounter any additional issues, please do not hesitate to let me know with details and screenshot so we could support you easier (please make sure all personal information is hidden before sending). I will be more than happy to assist you further. I look forward to hearing from you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.