Thanks for the tutorial. You can also keep the code, without having to delete it, and change the numbers 1 to 0 (turning off the password) in the section: sheet = "1" by sheet = "0" objects="1" by objects="0" scenarios ="1" by scenarios ="0" Thanks Sumit!
Its good to hear this still exists as I have been using it for 8 years and wondered if they ever going to plug it :) it actually helped me gain a lot of respect in the company.
I don't need to listen to the content to give a like, I have been following trump excel for years now, the content quality is such great that giving a like at the end is like playing devil's advocate. Thankyou for all your qualitative content.
Thank you Sumit for showing this trick !!!, Bit surprise, with this trick, suddenly felt like, no data is secure. However your explanation is pretty clear. Thank you.
This is a really useful video, thank you. I am curious why you need to make a copy of the .xml file and take it outside the main folder to edit it when you’ve already made a copy of the whole file?
You can also remove sheet passwords by brute force because they are hashed into 8 bits (as I recall). This means there are many other passwords which will open the sheet. Just write a program (in VBA or anything else) to test random passwords until you find one that unlocks the sheet. It usually takes only a minute or two. (This is completely different encryption to that used to protect whole workbooks, which is extremely difficult to crack).
This used to work but Microsoft changed the hash algorithm a few years ago. Notice in the part where the sheet protection code is removed, there's a bit that mentions SHA-512. That's the new algorithm.
How come MS make such option which is easily tampered with? What is the use of giving password to the worksheet if it can be tampered like this....Though good information......
Though you made it appear simple. I have some challenges. I have a file which is protected as xlsm. I was unable to convert this file into zip file. The second challenge was that though the file was xlsx and it did get converted into zip file. The xml file in the folder worksheet could not be converted into word pad. Please advise how to handle this.
I’m wondering if looking at the code if there is a way to see what the original password is without deleting it. I assume it is inherent in the HashValue. Any way of translating the HashValue to the actual password?
Dear brother, I also forgot my excel password, I changed the excel extension to zip but the zip folder is not open, showing an error ( The archive is either in unknown format or damaged ) Please try to update so I can remove the password in my excel,
Thanks for the tutorial.
You can also keep the code, without having to delete it, and change the numbers 1 to 0 (turning off the password) in the section:
sheet = "1" by sheet = "0"
objects="1" by objects="0"
scenarios ="1" by scenarios ="0"
Thanks Sumit!
Thanks for the tip Iván 👍
Glory to God! Thank you Summit. It work at my end. God bless you more. More content to follow.
It's been ages since I learned something novel about Excel. Thank you.
Its good to hear this still exists as I have been using it for 8 years and wondered if they ever going to plug it :) it actually helped me gain a lot of respect in the company.
You’re a genius. This came at the perfect time. Thank you.
I don't need to listen to the content to give a like, I have been following trump excel for years now, the content quality is such great that giving a like at the end is like playing devil's advocate.
Thankyou for all your qualitative content.
🤗
Excellent Production Summit!
Thanks Chandeep.. Good to see you in the comments section 🙂
This saved a lot of trouble today. I'm subscribing...
Absolutely BRILLIANT! Thanks for sharing!
Glad you found the video helpful 🙂
Cool. I use to unlock sheets by running a macro but I've since lost that code. Good to have a backup method. Thank you
Thank you Sumit for showing this trick !!!, Bit surprise, with this trick, suddenly felt like, no data is secure. However your explanation is pretty clear. Thank you.
Excellent information. I’m now a subscriber ❤
Nice, easily convinced to subscribe after watching one video by you!
Thank you very much, it's so simple
Fantastic as always. Thanks a bunch!!
Very glad to know this! Thanks Sumit 👍👍👍
Genius, thank you Sumit!
Worked awesome!!! Nice job ..... thank you!!!
HI Sumit, is there any way to open a password protected Excel file?
Thanks Sumit
Clever yet quite simple (when you know how). Thank you.
Awesome. Thank you.
Amazing one Sumit. Thanks for sharing.
This is great! I forgot the password of a sheet the other day and had to recreate it 🤦♀ is there a way to unprotect a workbook like that too?
Brilliant tutorial!!! But, does this also work on word, ppt etc.?
Wuiiii Genius trik
thanks for sample file
I can follow your video
thanks very much!!!
This is a really useful video, thank you. I am curious why you need to make a copy of the .xml file and take it outside the main folder to edit it when you’ve already made a copy of the whole file?
I made a copy and placed the XML file outside the ZIP folder, as within the ZIP folder, it doesn't allow me to open the file in Notepad or Wordpad.
How to open a password protected file, if you forgot the password?
Yeah that will be far more interesting to know
That would be a challenging task...
@@SSPanesarthere is macro that do it as brute force
@@piksodriver gr8 to here that.
Either use hashcat or johntheripper.
I've mainly used johntheripper for cracking zip files, but they can do many more file types.
Simply WOW 😲
Great tips I will try mine too and let you know the result
Many thanks for sharing
Great trick ! Thx Sumit !!!
Great video. Thanks a lot
Glad you found the video helpful 🙂
Thanks for the video, I have a file type .xls every time I save it as a .zip, it fails to open.
Very nice. Well done. Is it the same procedure when the file is password protected to open ?
It works only when you have the worksheets that are protected. Won't work when the entire file is locked or the VBA project is locked
thanks a lot, dear sir
Very useful, thanks!
thank you!
superb 🙏thanks a lot.
Great Work! Thanks Summit!!!!!
Thank you a lot! great tip!!
Wow! Amazing! Thanks a lot!
You can also remove sheet passwords by brute force because they are hashed into 8 bits (as I recall). This means there are many other passwords which will open the sheet. Just write a program (in VBA or anything else) to test random passwords until you find one that unlocks the sheet. It usually takes only a minute or two. (This is completely different encryption to that used to protect whole workbooks, which is extremely difficult to crack).
This used to work but Microsoft changed the hash algorithm a few years ago. Notice in the part where the sheet protection code is removed, there's a bit that mentions SHA-512. That's the new algorithm.
Thank you very much!
Thanks a lot.
That was a great tool
Any similar method for Word documents?
is there any method to unprotect excel workbook ?
And whilst you watched this, I cleaned out your entire bank account 😂😂
Nice one. Can you also do it for protected VBA code?
How come MS make such option which is easily tampered with? What is the use of giving password to the worksheet if it can be tampered like this....Though good information......
Brilliant 💯
Was was the password: "SHA-512"?
No, this wasn't the password 🙂
Though you made it appear simple. I have some challenges. I have a file which is protected as xlsm. I was unable to convert this file into zip file. The second challenge was that though the file was xlsx and it did get converted into zip file. The xml file in the folder worksheet could not be converted into word pad.
Please advise how to handle this.
Unfortunately Windows cannot open the zipped file
Thank u it’s finally done
Todo seguro, analógico o digital, tiene o llega a tener su cerrajero
I’m wondering if looking at the code if there is a way to see what the original password is without deleting it. I assume it is inherent in the HashValue. Any way of translating the HashValue to the actual password?
I tried researching on that a little bit but couldn't figure out how to get the original password back
@@trumpexcel OK. Thanks!
A hash is a one-way transform. You cannot translate it back to the original password I'm afraid
@@peter.mccullagh Thanks. Makes sense for security purposes.
good stuff!
Is there also a way to unprotect the entire workbook, when it got protected with "Protect Workbook" command in the "Review" section of the Ribbon?
No, there's no way to do that without brute forcing the AES encryption.
cannot work in window 8.1 or previous version of windows, i tested with 7zip and WinRAR, the files doesn't appear
Pl also show how to unprotect a protected MS word doc
Does it work for Mac Excel?
a note sometimes error messages can occur, when reopening, the renamed file, but the content is still accessable
Wow Really 👌
Sneaky but it works:)
Does this work for encrypted VBA too? (Xlsm with a protected VBA script)
This will work on Word protected file?
its work for xlsx file
Do you think this would work with VBA security too? I know, I’m too lazy to try after a long day!
I'm pretty sure it doesn't work with VBA security as they are binary files rather than XML files.
@@alanmonaghan9194 that was helpful. Thanks!
Can we do it for vba codes.
excellent
isn't there something for a newer file, where the data is encrypted?
I did this with Excel M365 file. Works well for all the new versions
Good
hy man.i have been try to remove password from excel for a week now,can you please help because am trying to follow this tricks but still failing.
Didn’t work. I changed the extension but didn’t work
same, i havent too.
That's for the oldest possible version of excel?
Dear brother,
I also forgot my excel password, I changed the excel extension to zip but the zip folder is not open, showing an error ( The archive is either in unknown format or damaged )
Please try to update so I can remove the password in my excel,
I do it as shown in the video, but when I open it, the files that are there like sheet1, sheet2, sheet3 are not displayed
I have a problem because my Excel ends in XLS
good day i cant see the work sheets
Will this work for a .xls file as well?
Seems to be working only with xlsx file format. With XLS, it doesn't open the ZIP folder for me
but its not showing on my laptop .. i tired it but its not working
That's cool 😎
Hi Sumit, I can't seem to download the excel file shown in the video. It downloads the pdf of 51 tips.
You can get the file from here - www.dropbox.com/scl/fi/1zvawx0zpvi4jn9dk3i4j/Call-Center-Dashboard.xlsx?rlkey=n2u8rp8h2vil4r3gboh4yzo42&dl=1
@@trumpexcel Thank You very much
Wow!
Now, how do I get into a password protected spreadsheet?
I couldnot delete the paticular sheet (duration - 3:24). It shows some error. what can I do now?
Numpang nitip gorengan.
How to open a password protected file, if you forgot the password?
WHEN CREATE XLSX TO ZIP AND OPEN OR EXTRACT THIS FILE IT SHOWS CAN'T EXTRACT THIS FILE WRONG FORMAT ERROR.............
Zip file cant open. Comes as invalid file
After i changed the extension to zip, i cant open the zip file. It says is invalid. Anyone has the same issue?
It need to be a .xlsx file (new Excel format) not a .xls file. if you have a .xls file you need to covert it first into a .xlsx file.
@@myticktack I have the same issues and mine is .xlsx
@@myticktack I have it in this format but still doesn't work when I add to the .zip extension, any update ?
How to open protected vba excel sheet
If the VBA project is locked, there is a separate process for it. Will make a video on that too.
It's a feature not a bug.
Why is mine .dat instead of .xml?
zip file not opening
"The Compressed (zipped) Folder ... is invalid" when I try opening the zip file.
It seems to work for everyone but It dose not work for me. I don't know what I am doing wrong with it.
not working
Just saved my bacon
but my file is xlsb
Me too, my file is xlsb