Use the extraction program to comprise the files in the second folder and change the extension of the file to. Delete the tag that starts with 'sheetProtection'. To unprotect Excel sheet2, right-click on 'sheet2.xml' and click on Edit then open with Notepad. Open the folder named 'xl->worksheets' where you will see the files, sheet1.xml, sheet2.xml, sheet3.xml. zip and click on 'Yes' when you get the prompt. Therefore, if your Excel worksheet is saved in.

How to Unprotect Excel Sheet without Password Using ZIP Then run the macro to unprotect the sheet before you then save it as a. If the Excel file has more than one sheet protected, run the VBA macro for each sheet repeatly.įor the latest versions of Excel 20, save the document as Excel 97-2003 workbook with 'xls' Extension. All you have to do is to click on 'Ok' and your excel worksheet will be unprotected.Ĭheck out some tips you should take note of: You do not need to copy or remember this password. Although this password is not the original password to the locked Excel worksheet, it works regardless. The macro will return with a new password. Check out some of its features.Īfter you have copied the code above, click on 'Run' or press F5 and wait for some minutes.

It guarantees that no Excel data will be deleted (including the external links) after using the unprotection tool. Passper for Excel is one of the most-used tools to unprotect excel sheet/workbook without password as well as recover the forgotten or lost opening password to unlock Excel. Unprotect Excel Sheet without Password Using Passper for Excel Very complex, not suitable for most users The Excel data may leak if the business Email is hackedĮasy to use, no need to install any software

Very safe, no data will be damaged or leaked Very slow unprotection process for big data

Protect cells without protecting sheet