avambro
/ Alternative_Excel_Unlock
Created
June 5, 2019 17:50
— forked from vaderj/Alternative_Excel_Unlock
Two methods of unlocking a locked excel sheet:
VBA macro for Excel that should unprotect a password protected sheet,
Opening the spreadsheet as XML and removing the specific piece
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Step 1. Make a copy of the spreadsheet in an empty directory. Rename the extension to .zip | |
| Step 2. Extract the zip file. | |
| Step 3. In the extracted contents, goto the folder \xl\worksheets\ | |
| Step 4. There should be one xml file per sheet? I editing "sheet1.xml" with NotePad++. From nearly the very end of the file, remove the tag that starts with: | |
| <sheetProtection | |
| My entire tag was as follows: | |
| <sheetProtection algorithmName="SHA-512" hashValue="ALciNBSIqRcjDiFbCuyWoGk4iOcC/ZRKnEjwEVi1skb6G5JbHhp+QVZ9+rlPVbGILOS7lYiCvJmR4Q7IuSphXA==" saltValue="8OVKXrG0VacLOLVztUpEYw==" spinCount="100000" sheet="1" objects="1" scenarios="1" selectLockedCells="1"/> | |
| Step 5. Save the file. Open the ZIP file in 7zip, find the same file, drag and drop, save, exit, rename the file back to (xlsx) and open |