Crack Excel2007 file worksheet password protection

Sometimes when we use Excel files, we will encounter password protection. The file passwords we used a long time ago may not be remembered. So what do we do when we encounter this situation? And since Office2007, all the encryption methods seem to have changed. Excel2007 password cracking and Word password cracking are not as simple as before. It can be said that excel or word password can be cracked in seconds, but the password is no longer cracked from 2007. So easy. The following system home Xiaobian talk about how to crack Excel2007 file worksheet password protection. Since excel2007, excel introduced new file types, namely xlsx, xlsm, xltx, and so on, called Open XML. Because this new file type is essentially a package containing XML files. If you change the extension of an xlsx file to zip, you can see all the xml documents that make up the Excel file. The new Open XML file type brings many benefits. One of its main benefits is that you can easily modify the contents and properties of an Excel 2007 file by manipulating the XML document that makes up the file. Yes, when dealing with Open XML files, it was found that you can simply remove the worksheet protection by simply editing the xml file in the Excel file. Suppose there is a workbook whose sheet Sheet1 is protected. Now, I want to cancel the protection of the worksheet, but I don't know the password. How to do it? Fortunately this is Excel 2007, we can use XML to remove worksheet protection. Step 1 First back up your workbook, just in case. Step 2 Modify the workbook file to have the extension zip. Step 3 Extract the compressed file. Step 4 Locate the XML file representing the target worksheet (in the xl\\worksheets folder). Step 5 Use any XML editor to open the xml document representing the target worksheet. Step 6 Locate the “sheetProtection” tag and remove the line where the tag is located. Step 7 Save the edited XML document and replace it with the corresponding XML document in the original Zip file. Step 8 Modify the file extension back to xlsx. At this point, the worksheet protection has been lifted. Note: Any passwords you see in the XML file are not true passwords. This method does not remove the protection of the entire workbook. This article comes from [System Home] www.xp85.com