Articles Office 2 Ways to Unprotect Workbook in Excel 2016/2019 without Password

2 Ways to Unprotect Workbook in Excel 2016/2019 without Password

Updated: By Yvonne Keller

If you still remember your Excel Workbook structure password, you can unprotect workbook easily and directly with the old password. Just open the Excel file, open Review, click on Protect Workbook, type in protection password, and then click on OK to unprotect Excel Wordbook.

unprotect workbook

However, if forgot Excel Workbook structure protection password, how to remove the protection password and unprotect it? Here will show you 2 ways to unprotect Workbook in Excel 2016/2019 without password.

2 ways to unprotect workbook in Excel 2016/2019:
Way 1: Unprotect Workbook in Excel 2016/2019 without password quickly
Way 2: Unprotect Workbook in Excel 2016/2019 without password or software

Way 1: Unprotect Workbook in Excel 2016/2019 without password quickly

1. Get Workbook Unprotect Tuner. You can download the free trial version from its official site to have a try.

2. Click on "Open" button to import the Excel file into program, if the software has been installed and launched on your PC device.

import file

3. Click on "Remove Password" button to unprotect Workbook.

remove-password

4. You will get the message box in a few seconds. If the message saying: "Workbook protection password: Removed", that means the Excel workbook structure is unprotected.

password removed

5. Go to the location where the Excel file is saved, you will see a new Excel file marked as unprotected.

unprotected file

The trial version of Workbook Unprotect Tuner only helps to test the password, won't help to remove password from your workbook. If need, please order the full version.

Workbook Unprotect Tuner also works on unprotecting Excel spreadsheet and removing read only password from Excel to make it editable, but don't works on Excel opening password, if you forgot Excel file opening password, refer to this article: How to Open a Password Protected Excel File if Forgot Password.

Way 2: Unprotect Workbook in Excel 2016/2019 without password or software

Video guide to unprotect Excel Workbook without knowing password:

1. Right-click on the Excel file, and then click on "Rename".

rename

2. Change the file name extension from (.xlsx) to (.zip).

change file name extension

3. Right-click on the zip file, point to 7-zip, and then click on "Open archive".

open archive

4. Click on the file named as xl.

xl file

5. Right-click on this file named as (workbook.xml), and then click on "Edit".

select edit

6. Find those codes as picture below and remove them.

remove code

7. Save this file and exit it.

save file

8. Right-click on the zip file, select "Rename". And then change the file name extension from (.zip) to (.xlsx).

9. Go and open this excel file, and you will find the workbook structure is unprotected.

Just have a try, good luck with you.

Related Articles