How to break Excel Workbook Password Protection without software | MS Excel Tutorial
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- In Excel, you can password protect Excel workbook to prevent users to changing the structure of the Excel workbook. Excel workbook protection prevent users from viewing hidden worksheets, adding, deleting, moving, hide/unhide worksheets.
Imaging one day you forgot your Excel Workbook Password and you have no way to remember. In this video I will show you how to break the Excel Workbook Password Protection without using 3rd party software or VBA.
PS: If you got a window prompt asking for password when you are opening an Excel file, then that's what we called Excel application password, which cannot be cracked. You will need to ask the owner for the password.
Buy Me a Coffee? Your support is much appreciated!
--------------------------------------------------------------
PayPal Me: www.paypal.me/...
Venmo: @Jie-Jenn
Join Robinhood with my link and we'll both get a free stock 🤝 join.robinhood...
Check out Kit →
www.kite.com/g...
Visit my website
LearnDataAnaly...
Considering support my channel through shopping on Amazon
amzn.to/2JkGeMD
Want to be more productive? Check out the the gear (Amazon affiliate links) I use when I am working.
Lenovo ThinkPad X1 Extreme 2nd Gen (4K): amzn.to/2QT1CNk
ASUS Designo Curve MX38VC 37.5" Monitor: amzn.to/39rFSOQ
Logitech MX Master 3 Advanced (My primary mouse): amzn.to/2WSumK2
Logitech MX Anywhere 2S (When traveling): amzn.to/2WTdKl5
Logitech Craft Advanced Wireless Keyboard: amzn.to/2QUjAz1
VAVA USB C Hub, 8-in-1 USB C Adapter : amzn.to/3dFim4g
Theralite Aura Bright Light Therapy Lamp: amzn.to/2UIp5lv
I followed your example but had to go down one more level to get to the worksheets, opened up the file in Notepad and searched for Protection and I removed a line of code between and then did the same for the second xml file. It all works fine...thanks
Beautiful, it worked like a charm. My scenario was a protected worksheet , not the workbook, and I followed JJ's steps, and bingo!!!! All the options when you right click on the sheet tab of the protected worksheet were all available. But worksheet is still password protected...
But I could copy it and paste it on a new sheet and dumped the protected sheet and worked fine. Thank you
Worked perfectly! He mentioned it at the end of his video but just as a reminder, make sure you pay attention to what the original extension was! You'll want it to be the same as the one you copied
Thank you so much. It also successfully work for me for Excel 2010; although, I removed the protection on the specific protectected worksheets in the worksheets folder and not on the workbook.xml
It worked perfectly and I am amazed how simple it is to remove the protection. My Excel is version 2016. Thank you Jie Jenn.
Glad my video helped!
You are the most awesome person who has ever lived. You've saved me a week of work!!!
Perfect worked a treat. good job there are people like you who will teach others.
Glad the video helped.
Hi Jie, thanks for posting the video explaining how to unlock the excel sheet when a password is forgotten. I am in a situation where my excel workbook is locked and couldn't unlock it with the steps shown in this video. When I convert the excel workbook to .zip and try opening with win rar, I get an error message "This archive is in either unknown format or damaged". I used 7zip to extract and was successful. But, I didn't see the directories that were shown in this video. I am curious to know if there is any other way to unlock the workbook.
I think it doesnt work on new excels without tools
I recieved a Password Protected Excel file without the password, followed these steps and it worked a dream
Jie Jenn thank you for sharing
Glad my video helped!
Wonderful, brilliant, an absolute life saver. Worked perfectly!! Possibly the most useful video I've ever watched
I tried this method unsuccessfully. After I have renamed the file extension to a .zip, instead of creating a RAR file, the file became a ZIP folder instead and it can't work from there on. Did you have this problem and overcame it?
Thank you, it worked perfectly.
AWESOME!!!!!! This saved me from having to create an ENTIRE BRIGADE’S MANNING REPORT....sheeeeeessshhhh!!!!!
Thank you . It worked !! Its been 3 days since i was trying to remem ber my workbook password. You rock guy
I tried this method unsuccessfully. After I have renamed the file extension to a .zip, instead of creating a RAR file, the file became a ZIP folder instead and it can't work from there on. Did you have this problem and overcame it?
Amazing video thanks so much. you saved a big headache of having to reproduce a big document.
Great work and this is worked for me. Simple and easy work. Thank you for upload this.
Just what I was looking for. Thanks.
it worked perfectly..thanks a lot...
Very nice, thank you
it worked perfectly. how can i also remove worksheet protection? Thank you so much.
worked for me Excel 2016. Thanks for this
Hi ,
I have a problem after changing the extension the zip file is not even opening nor extracting .
Pc Specs
Windows7
Office 2007
Everone is saying it is working but in my case it isn't working.
even I'm facing same issue
very helpful. I can remove mine. Excellent video. Thank you so much. Subscribed & definately liked
Why I couldn't find that structure lock in notepad?
cuz it's lockstructure
It worked for me. Thank you so much!
this legit changed my life. i wish i saw this a decade ago. instead of looking for "lockstructure" i deleted the entire filesharing line between the with the username and password
wow my friend, awesome, I need to buy you a coffee!!
Amazing!! Thank you very much!
Outstanding. Its very informative video. 😊 Big Thanks. 👏👏👏👏👏
You are the best bro. Thank you.
Yow mi gee you save my life with this HACK. Much appreciated
Thank you so much
This was really helpful. Thank you!
im using notepad and i cant seem to find lockStructure anywhere, i even tried opening it with Wordpad still no luck :/
edit: i figured out that the workbook is not locked. however the sheets are. i unlocked the sheets with the same zip, delete and unzip process.
me to
notepad and notepad++ are two different things
@@500spectre nope. If you can see the edit i figured out why. And if you are going to contest why the two are different then be my guest cause I am not going to explain you why both of them are .txt file reader and editer.
@@MrUnderEstimated Hey John how did you unlock the sheet. thank you
@@duanetegels2268 yes, its the same in the tutorial, you just need to unlock the sheet
You rock! Thanks!
Thanks a million, pal. It worked like a charm.
this is perfect 😍
works flawlessly !! Great Job
Perfect. Thank you so much. Very clear--and it worked!
Thankss for sharing!!! Great Help!!
thanks so much!!
Brilliant!
It's worked fantastically for me. Thanks👍
Didn't work for me, it shows Encrypted Info/Packages one I view the zipped folder structure
Same for me
Thx worked for me!
Thank you soooo much! 🙂 this actually worked for me.
Thank you SO much!
Excellent bro. You saved my Day
Worked like a charm. THANK YOU!
It worked. Thanks. New subscriber here.
Glad the video helped me.
i'm sorry but here say "your file is damaged" when I put in zip.
So what can I do ?
Hey. Which Excel version are you using?
@@jiejenn It happen the same with me: "The archive is either in unknown format or damaged" Excel Microsoft Office Professional Plus 2016
same thing happen to me
@@micheleproce4590 to fix it, you need to ensure you "save as" and save it as an xlsx file (aka a more recent version of excel). otherwise wont work
Thank you very, very much!!!!
This is life-saving! Thank you so much.
@Jei Jenn, nice trick. But when i am trying to do the same my zip file is not getting open, its saying unknown format or damaged.
What Excel version are you using?
@@jiejenn 2016
Same as mine
Same with 2010
Hi, I forgot my password of an excel file and tried to unlock by using your method. But when I open the zip file, it looks different from your video. My file shows 'EncryptedPackage'. I have no idea how to open this. Can you help? Thanks.
That's new to me. If you want you can send your file to youtube@LearnDataAnalysis.org and I can take a look.
Same
ure my hero!
Thank you !
Hey man great Video, I applied your suggestions but my workbook did not have any locked structure details after pasting it on notepad, please help
THANK you, very helpful!
Thank you so much, it has worked !!!
Thanks
OMG Thank you ! Thank you !!
@Jie Jenn While I tried to open the zip it shows the archive is either in unknown format or damaged
I think there are some file archive software don't work, this is the most common root cause.
@@jiejenn how can we solve it
Thank you. It works.
AMAZING !!
Thank you, you are a life saver
Thank you very much, it helped a lot.
Brilliant, works.
Thank you a lot brother! Everything worked.
Great job🙏🙏🙏🙏🙏 appreciate your work..
Can you do a video on how to get buy the Open password as well?
amazing just make sure when you delete it in the notepad that you do the entire thing sheet protection scenarios, objects, sheet, spincount, saltvalue, hashvalus and algorithmname
Do you know anything about outlook and being able to break the password to an old outlook file where I forgot the password? It's from around 10 years old.
thanks
Not familiar with Outlook password protection unfortunately.
Thanks man worked 100%
Great Video - But it doesn't work - When I make the file a zip file and look into the folder it only has the compressed xls file ??
I think for xls files, you will have to use macro. If you do a Google search you should be able to find the VBA code.
Hi, no need to make the file as a zip file. Just rename the filename.xls as filname.zip and open it. Then you can see the folders. Hope this will help.
@@NishanHarshaPerera Hi, I rename it; but it says: "The archive is either in unknown format or damaged" Excel Microsoft Office Professional Plus 2016
With WinRAR says: This archive/split-archive may be corrupted or has missing parts....
JIE JENN thank you so much.
Thanks alot bro....life saver
Thanks for saving me
Super Brother its really great work thanks so much how to remove excel locked sheets
wow you're incredible thank you
Holy hell this worked. THANK YOU!
I tried this method unsuccessfully. After I have renamed the file extension to a .zip, instead of creating a RAR file, the file became a ZIP folder instead and it can't work from there on. Did you have this problem and overcame it?
OMG thank you - life saver!!!!
Glad the video helped.
Thanks Jie Jenn.. but I failed on final stage during Converting File.. it says "Converting..." but then its said "Something went wrong"
Does it require for excel file to connect online using Microsoft Account?
veryyyyyyyyyyyyyyyyyy good lesson
I did it!!! :)
Hey JJ.. Therer is not lockstructure anywhere in the file. I checked it with notepad++ and the I copied the code and checked it in word as well. What to do now?
What version of Excel are you using? And are you sure your Excel file is locked?
@@jiejenn I am using 2016 professional plus. And out of the entire worksheet, first sheet is password protected.
I think you are trying to unlock your worksheet protection instead of workbook.
th-cam.com/video/DvBAGuJts7A/w-d-xo.html
Which version of winrar should i use??
Love you! Thanks brooooooooo
I have an Excel workbook with about 30 sheets, one of which I imported from online (an amortization table). That sheet came password protected, and it's the only sheet with protection. I don't know the password. Is this preventing me from removing the password for my entire workbook?
Amazing, thank you!! I got it to work for the workbook protection. How can i unlock worksheet protection?
Check out this video th-cam.com/video/DvBAGuJts7A/w-d-xo.html
THANK YOU A LOT
Hi When i open the zip file, it said the file is damaged or corrupt..are there any ways to open the excel file?
What zip software are you using? There are few zip software are incompitable.
@Jie Jenn What screen recorder have you used? Is it a paid software. please share the URL to download that particular software!!!
OBS
in 2021, When you zip Excell workbook which is password protected, and try to open it, it says _"The archive is either in unknown format or damaged"_ . So anyone gets this error? I see it works in old times, but I am not able to open the zipped excell file now.
were you able to find solution
@@surajbhalgotra5933 nope, I remembered the password:)
GREAT!
Similar to my excel version but there is no 'lockStructure' in file.
True, I tried the same steps and did not find anything related to a password in Notepad++, maybe they patched this?
Can u teach the method for XLS?
Hey Jie - Shouldn't it be like - How to Remove Forgotten Excel Sheet Password (NOT WORKBOOK) I have problem with Workbook Password, can you help ...?
Workbook and Worksheet use separate password protection mechanism.
Thanks its worked
So if i change it back to 1 will the file go back to its original password state?
Thank you so much!!!!!
Glad my video helped. And thank you for your donation, much appreciated!