2 Ways to Open Forgotten Excel Password Without Software

A lot of work is hampered because the Exel file that will be used is blocked.password and we don’t know or forget Password the Excel.

Usually people who protect their excel files think that the file is very important and not just anyone can open it, therefore the file is used password to secure it.

But not a few people forget the password, so he’s confused about what to remember password of the file.

Because many have forgotten password excel, and it’s hard to solve, therefore we will provide tips and tricks to be able to open the excel file very easily.

And for the methods and steps, you can see the explanation below, please read carefully.

Opening Files By Converting To ZIP

Below we will explain the first way, namely by converting the file into a ZIP, for the steps you can see the explanation below.

• The first thing you do is make sure first that the file is really locked, for example, a notification appears like the image below

• After that you go to”file explorerand look for the locked file earlier
• When you find the file, then right click on the file

• After you right click it will appear several options, then you click “rename“.

• After that you change the end of the file name from xlsx to ZIP, then press “enter” and click “yes“

• Then the file will automatically change to ZIP format instead of excel.
• If it is a ZIP file, then right click and click “Extract to Locked Files“, it will automatically extract and a new folder will appear.

• After that double click the file will display a display like this.

• After that you double click files named “xl”

• Next you guys double click another file named “worksheets“

• After that a display named “sheet1.xml” will appear, then right-click the file and select “Open“then select”Notepad“

• After that you delete the code as shown below

• After you delete then you save by pressing on keyboard “Ctrl+S“
• After you save it, return the name as at the beginning to “xlsx“
• After that you open it again and automatically the data is not locked.

Also read: How to Overcome Forgot Windows 10 Password

Without Using Additional Apps

This second method can be done easily, because it is done through the Microsoft Excel application directly, and you can see the method below.

• First you open the excel file which is still locked
• Then you make sure again that the file is really locked, how to do it double tap the text in excel until a warning appears as shown below.

• After that you press the key combination on keyboard you are “Alt+F11“

• After that you will be taken to the “Microsoft Visual Basic“, then it will look like this.

• Then after that you click “Insert“then select”Module“

• After that the display will appear “general module“

• Then you enter the code to delete the password file, you can get the code by clicking on the following link, https://drive.google.com/drive/u/0/my-drive or you can see the image below

• After you enter the code, you click the locked sheet then you click “Run the Macro or click the F5 . key“then click”run“

• Then wait for the loading process to finish, then your file can be edited or without a password again

And those are the two ways to get rid of the forgotten excel password both in excel 2003, 2007, 2010, 2022, and the latest version both without software and with software.

Hopefully it can be useful for all of you and good luck, you can see other articles on pondband.net.

Also Read: Forgot PKB SIM Password