With Instructables you can share what you make with the world, and tap into an ever-growing community of creative experts.
Tell us about yourself!
Building secret 'drinking' nest box
Unprotect Excel sheet without password using 7-ZIPThis way only works for Excel file in .xlsx format. Hence, if your Excel workbook is in .xls format, just open it and then save it as .xlsx format.Step 1: Change the Excel file name extension from .xlsx to .zip. Just click on Yes to make sure when prompted.Step 2: Open the ZIP archive as 7-ZIP. Open the folder xl->worksheets and you can see threesheet.xml files. Select the sheet1.xml file. Right click on it and select Edit. Choose to open it withNotepad.Step 3: Delete the tag beginning with sheetProtection. Then save and close the sheet1.xml file.Step 4: Update the modified sheet1.xml file in the ZIP archive when prompted. Then close the ZIP archive.Step 5: Change the ZIP fie name extension back to .xlsx. At this point, the Excel sheet has been unprotected. Open it and you can edit the sheet without password.
Join 2 million + to receive instant DIY inspiration in your inbox.
Download our apps!
© 2016 Autodesk, Inc.