Forgot Excel Password 2016? 4 Ways to Unlock Excel 2016 without Password

author_icon Ronnie Barnes time_icon Last updated: Oct 15, 2019 03:08 pm tips_icon Excel

Microsoft Office allows users to easily set a password to protect the content on the document. Considering the different ways you can secure an Excel document, this feature is a great way to ensure the content remains secure and uncompromised. There are actually 3 main ways that you can secure your Excel 2016 document including the following:

  • You can use a password to encrypt the document making it difficult to open the document without this password. This is known as an opening password.

  • You can also protect the worksheet, workbook structure and content, preventing someone from making any changes such as inserting or deleting rows and columns, making formatting changes and even locking or unlocking cells. This is known as an Modifying password.

But as you may already know that if you forgot Excel password 2016, you would be essentially locked out of your own document. If you're reading this article, this is what has happened and you need an effective way to unlock Excel without password. The following solutions should help;

forgot excel 2016 password

Case 1. Forgot Excel Opening Password 2016

If you have forgotten the opening password on your document, you will be unable to open the document and therefore unable to read or make changes to it. Most people simply opt to discard the document and create a new one. But this can be time consuming, not to mention demoralizing. There is however another option that can allows you to easily unlock the Excel without password.

This solution is Passper for Excel, an Excel password remover tool that is instrumental in the removing of Excel opening passwords as well as Excel modifying passwords. In fact, it is a program that is specifically designed for this purpose. Some of the features that make it the ideal choice include the following:

  • It facilitates the removing of Excel passwords without affecting the data on the document in any way.

  • It has a very high success rate to remove opening passwords because it utilizes 4 different attack modes to aid in password removing.

  • It also has the success rate of 100% to remove modifying password from the Excel workbook or worksheet.

  • And it can do all these tasks without much input from you, making it one of the easiest password removing tools to use.

  • Famous media sites have recommended us and 30-day money back is guaranteed.

media sites

Free Download for Win 10/8.1/8/7/XP

Follow these simple tools to use Passper for Excel to unlock forgotten Excel opening password 2016:

Step 1: Install Passper for Excel on your computer and then launch the program. Select "Recover Passwords" in the main window and then click on "+" to browse for the protected Excel document and add it to the program.

choose recover password  

Step 2: When the document has been added, select the attack mode you would like to use. Keep in mind different attack modes will be effective under different circumstances. Select one based on how complex your password is and how much information you have about it.

choose an acctack type  

Step 3: The software will immediately begin recovering the password on the file. When it is recovered, the password will be displayed on the next window. You can use it to unlock the Excel 2016 document.

remove excel 2016password  

Also read the good reviews from our users:

user feedback

Case 2. Forgot Excel Modifying Password 2016

If on the other hand you have forgotten the Excel modifying password 2016 and therefore can't edit the document either on the workbook or worksheet level, the following 3 solutions should help:

Comparison of the 3 solutions:

Passper for Excel Save Excel 2016 as a New Document Change File Extension
Remove Modifying
Remove Opening Password
Compatibilitys Supports all Excel versions (Excel 97-2019) Supports Excel 2003-2016 Supports Excel 2007 version or earlier
Operation and Safety 100% easy and safe to use, no data loss. Easy and safe, no data loss. Not suitable for new users, very difficult to operate.

2.1 Passper for Excel

Passper for Excel allows you to easily lift all restrictions from an Excel document in a single click. Here's how:

Free Download for Win 10/8.1/8/7/XP

Step 1: Open Passper for Excel and then click on "Remove Restrictions". Click on "+" to browse for the restricted document and add it to the program.

select remove restrictions  

Step 2: Now simply click "Remove" and Passper will begin lifting all restrictions applied to the document. The whole process will take just a few seconds.

remove restrictions  

2.2 Save Excel 2016 as a New Document

You can also easily lift any editing restrictions on the document by saving it as a new file using the "Save As" feature. Follow these simple steps to do it:

Step 1: Open the restricted Excel document and when prompted to enter the password, leave the password field blank and instead click on "Read only". This will open the file in read-only mode.

open read only excel file

Step 2: When the document opens, click on "File > Save As and type in a suitable file name and select a suitable location for the new file.

save as excel file to remove read only

Now all restrictions will be lifted allowing you to easily edit the file.

2.3 Change File Extension

You may also be able to lift editing restrictions by changing the document's file extension to .zip and using archive software to bypass the password. Here's how to do it:

Step 1: Open File Explorer on your computer and locate the restricted Excel document.

Step 2: Right click on the document and change the file extension from .xlsx to .zip. Click "Yes" when a warning appears on the screen.

change file extension

Step 3: Now open the newly creates ZIP file using archive software and then open the "xl" folder. Click on "Worksheets" and open the file named "sheet1.xml" using a text editor like WordPad.

edit sheet file

Step 4: Find the "sheetProtection" tag and delete it. Save and close the WordPad document.

delete sheetprotection tag

Step 5: Click "OK" to update the ZIP archive when prompted.

Step 6: Now locate the ZIP file in File Explorer and change the file extension back to .xlsx.

This should effectively lift any restrictions on the document although due to the complexity of the process, most people have had to attempt the process more than once.

The above solutions will all be very helpful when you forgot Excel password 2016. Select the solution that best suits your current situation. We welcome any questions or comments about the above processes or anything else. Use the comments section below to reach out to us.


By Ronnie Barnes to Excel

Posted on Aug 13, 2019 ( Updated: Oct 15, 2019 )

Ronnie Barnes, a blogger with more than 5-year experience in writing tips about password recovery for Windows and office files.