OK Let's Start
STEP 1: First download & install WinRAR from http://www.rarlab.com/download.htm if you have already install skip this step.
STEP 2: Right click on your protected excel file click open with and click choose a default program... and select WinRAR from your installation path (where you install WinRAR default location is C:\Program Files\WinRAR) and Click OK button
STEP 3: Now you see given bellow file structure in your excel file when you open it on WinRAR, now open following path xl > worksheets (Note: you all excel file work sheet show on this directory with .xml format).
Extract sheet (which sheet password you want to remove) from worksheets folder to you desktop) write click on sheet1.xml and open with on notepad or other text editor software (your file look like given bellow screenshot).
press ctrl + f and fine protection and remove it from <sheeProtection to scenarios = "1"/>
<sheetProtection algorithmName="SHA-512" hashValue="2U+QqX2+posRAhaoQmIPP0GJsMwe7GTV1yUwFt+q9+EylaK2djB5RNt2pHfOZcDACOPON7rRa6jU1DscqU7Nhg==" saltValue="qeu00YqSpNK4cgkJyUXfIA==" spinCount="100000" sheet="1" objects="1" scenarios="1"/>
save file and put this file on xl > worksheets & replace file, again write click on your protected file and select excel and OK now you she excel logo on your file double click and open and you see your protected file is unprotected.
If you see any problem in this tutorial please watch my video tutorial in YouTube using give bellow link, if you like my video please don't forget subscribe or like my video.
https://youtu.be/FdQcRBGghZc
No comments:
Post a Comment