Office hacks: how to forget the password of Excel files

For some of our more important forms, such as bookkeeping forms used to record household expenses and password forms for logging in to various websites, we usually protect them with our own private passwords, but what if one day, by coincidence, we even forget these passwords?

Excel密码001

Prompt the password screen, if you do not enter the correct password, this Excel sheet is not editable. Is it necessary to violently decrypt? In fact, it does not even need to be so troublesome, we can use a workaround to clear this Excel worksheet to protect the password.

Excel密码002

As shown in the figure, this Excel file is no suffix, we need to modify its suffix first, and then to achieve the purpose of clearing the password. Method is, click the tab to switch the folder to “View” item, and then check the “file extension”, so that Excel tables show the suffix name.

Excel密码003

Next, we right-click the Excel file and select “Rename” to modify the form suffix name.

Excel密码004

Circle the suffix “xlsx” and change it to a zip file suffix such as “zip” or “rar”, then it will prompt “If you change the file extension, it may cause the file is not available”, ignore it, click “Yes” to determine.

Excel密码005

Double-click the file which is modified into a zip file, open it and go to “worksheets” under the “XL” directory, find sheet1.xml and double-click it, then it will prompt how to open the file, we choose other options in “Notepad”.

Excel密码006

Excel密码007

In Notepad, press the shortcut Ctrl+F, search for the keyword “protect”, locate the content similar to the following, drag the left mouse button, select <sheetProtection> including the brackets and all the content in the brackets, delete it, and then save to exit.

Excel密码008

After completion, we just need to go back to the folder just now, the file with the .zip extension back to the Excel file extension .xlsx (or .xls). So far, double-click the file you will find that the protection password is gone, is not very simple?

If this method does not work, for example, the latest version of Office Excel does not support, then we have another way to crack – through the macro function can also achieve the same purpose. To use this method, or open the Excel file with the worksheet password protection, and then click on the “File” option.

Excel密码009

In Excel Options, switch to “Customize Ribbon”, find “Development Tools” on the right to check it, and then click OK.

Excel密码010

Go back to the Excel spreadsheet, click on “Development Tools” above and select “Record Macro”.

Excel密码011

Click OK in the pop-up window to start recording the macro, and then click “Stop Recording” in the development tool.

Excel密码012

At this point, we have a “blank macro”, click “Macro” in the development tools, a pop-up window click “Edit”.

Excel密码013

In the macro editor that pops up, we delete all the content (actually no content), then download the macro code (download address: https://pan.baidu.com/s/1BdMhmKKXfOIUXAOJVGZ30A, extraction code: tcp0), copy all the macro commands to the current macro editor window, and click Close.

Excel密码015

Click again to develop tools in the “macro” can see a new macro “Password_cracking”, select the macro click on the implementation, Excel worksheet to protect the password is cleared.

Leave a Comment