Unlock/remove protected sheets in excel

[marllouie]

View attachment 347249
View attachment 347250

You dont know or you Forgot the password of a protected sheet in Excel?? Worry no more, just follow this steps


EASY STEP BY STEP ON HOW TO UNLOCK/REMOVE PROTECTION:

1. make sure the "hide extension" in file folder options is uncheck.
2. change the file extension of the excel file you want to unlock to .zip
3. extract the "zip file" to a specific folder
4. go to xl>worksheet
5. open each XML Document files named as "sheet#" via notepad
6. delete code <protection> till </autofilter>
7. save (Ctrl+S)
8. select all files, right click, select send to>compressed zipped folder
9. change the file name back to ".xlsx"
10. Open unlocked file and ENJOY!


Credits to *Dnomr

 

[He11mo]

interesting to ts hehehe salamat sa pag share

 

[marllouie]

interesting to ts hehehe salamat sa pag share

welcome bro!

 

[percivalmipa]

View attachment 1263723
View attachment 1263725

You dont know or you Forgot the password of a protected sheet in Excel?? Worry no more, just follow this steps


EASY STEP BY STEP ON HOW TO UNLOCK/REMOVE PROTECTION:

1. make sure the "hide extension" in file folder options is uncheck.
2. change the file extension of the excel file you want to unlock to .zip
3. extract the "zip file" to a specific folder
4. go to xl>worksheet
5. open each XML Document files named as "sheet#" via notepad
6. delete code <protection> till </autofilter>
7. save (Ctrl+S)
8. select all files, right click, select send to>compressed zipped folder
9. change the file name back to ".xlsx"
10. Open unlocked file and ENJOY!


Credits to *Dnomr

thanks ts dito.

 

[marllouie]

thanks ts dito.

welcome!

 

[Natzjaps]

doesn't work with me. corrupted zip file daw po.

thanks anyways.

 

[jezzyfox]

thanks for sharing ts..

 

[marllouie]

doesn't work with me. corrupted zip file daw po.

thanks anyways.

try to check excel file extention, ".xlsx" or ".xls"

 

[Naejefafeg]

Alternative 1:
Open the file thru winrar so you don't need to check/uncheck folder options.
Right-click the file and click rename. Change the file extension to .zip.
Access the renamed file (still in winrar) and go to xl \ worksheets.
Double-click the sheet you want to remove the password with, ex., sheet1.xml. It will auto-open to notepad (in my exp).
(The sheets are numbered according to the original file, from left to right.)
Press CTRL+F and type "protection". Delete <sheetProtection algorithmName= ... selectLockedCells="1"/>. (This is .xlsx format.)
Save and click YES to update.
Click the .. at the top until you're back to where you renamed the file. Change the .zip back to its original file extension.
DONE. No need to extract/compress.

ALternative 2: This only works for new version, not compatibility mode.
Open the file thru winrar.
Just double click on the Excel file. NO need to alter names.
Navigate to xl -> worksheets -> sheet#name
Double-click the sheet you want to remove the password with, ex., sheet1.xml. It will auto-open to notepad (in my exp).
(The sheets are numbered according to the original file, from left to right.)
Press CTRL+F and type "protection". Delete <sheetProtection algorithmName= ... selectLockedCells="1"/>. (This is .xlsx format.)
Save and click YES to update.
Close winrar.
DONE. No need to extract/compress/rename.

credits to the lazy me years ago

BUT if the Excel Workbook is encrypted, I think the password cannot be deleted by this trick.
You will get corrupted file. I do not know if it is possible to delete the password thru deadly hacking skills since I am not a hacker, haha

 

[marllouie]

Alternative:
Open the file thru winrar so you don't need to check/uncheck folder options.
Right-click the file and click rename. Change the file extension to .zip.
Access the renamed file (still in winrar) and go to xl \ worksheets.
Double-click the sheet you want to remove the password with, ex., sheet1.xml. It will auto-open to notepad (in my exp).
(The sheets are numbered according to the original file, from left to right.)
Press CTRL+F and type "protection". Delete <sheetProtection algorithmName= ... selectLockedCells="1"/>. (This is .xlsx format.)
Save and click YES to update.
Click the .. at the top until you're back to where you renamed the file. Change the .zip back to its original file extension.
DONE. No need to extract/compress.

credits to the lazy me years ago

Thanks for Sharing yours

 

[heynightmare]

working boss thank you very much

 

[Fr13nd5]

pa bookmark ts for sharing minsan may mga naeencounter ako password protected excel files hirap pag d alam password

 

[lonewolf07]

d pwede sa office 2016

 

[marllouie]

working boss thank you very much

Welcome sir! Glad to help!

 

[JhanuzOne]

Thanks dito TS

 

[buaya]

Mas madali ang sa akin.. ito dami pasikot2x

 

[guapotolits]

Salamat paps

 

[marllouie]

Salamat paps

welcome sir!

- - - Updated - - -

Thanks dito TS

welcome!!

 

[vinus11]

Anyone who can help me remove the protected sheets in excel. I forgot the password, i cant open my file, please

 

[rexelens]

aling method ang working dyan?