Тёмный

How to Break Password Protection from a Protected Excel Sheet 

Technology for Teachers and Students
Подписаться 1,6 млн
Просмотров 400 тыс.
50% 1

What do you do if your Excel spreadsheet is protected with a password, but you don't know the password? This video shows you how to remove the password from off of a protected Excel spreadsheet, even if you don't know the existing password. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's the practice file for this video: bit.ly/excelbreak #excel #exceltutorials #microsoft365

Опубликовано:

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии    
@darinhayes6204
@darinhayes6204 2 года назад
Excellent tutorial. Out of all the videos I have watched, you are the only person that showed how to change the file extension back to an xlsx file after it had been renamed. Thank you!
@jerome5009
@jerome5009 Год назад
I've tried it today. I managed to unprotect the excel sheet and manage to see all the formulas in each cell. Really helpful. Great work.
@graythebruceii
@graythebruceii 2 года назад
Great video. I tried this same hack by following steps in an article and it corrupted the file. (Yeah, I had a backup.) Then I watched your video and there's a subtle but important difference in your approach. Yours worked just fine. No difficulties at all. (For those interested in specifics: The article had me unzipping the file, making changes, and then re-zipping, rather than surgically implanting doctored copies into the still-zipped file. One gets the impression they saw a video or read about it but never did it themselves, so they just assumed you had to do that unzip/rezip thing and that it wouldn't cause problems. In any case, if anyone's looking at an article that says to unzip the folder and also looking at this video, and you're wondering which one to follow, follow the video.)
@godwinuche4669
@godwinuche4669 3 года назад
Honestly there’s something special about your way of teaching. I have watched this unlocking passworded sheet from other channel and learned it but the person never talked about the file extension name because when we save our sheets it doesn’t reflect the xlsx name so I had to find out myself but you just put out this video for the first time and made sure you explained the xlsx part which is why I believe learning from your channel is more easier than any other channel. Even tho I already learned this I knew you would explained it in a baby steps that’s why I never skip any video you put out
@techteachersandstudents
@techteachersandstudents 3 года назад
Godwin, thanks so much for your kind comment. Thanks for watching my videos!
@heren18channel77
@heren18channel77 2 года назад
yeah its true very clear explanation,. easy to understand thats why i dont have a doubt to subscribe in this channel..more power to this channel
@lucyv.391
@lucyv.391 Год назад
This is absolutely amazing! I watched few videos before that and they did not have details like you had, so I could not go passed "change extension to zip file". you saved me at least 10 hours of work. Thank you again!
@michaelayoola4198
@michaelayoola4198 4 месяца назад
I have found this video really helpful in making my work easier. The video demonstrates how to use a workbook with one visible sheet, but I'm not sure how to apply the same techniques to a workbook with an additional two hidden sheets connected to the visible sheet. The visible sheet serves as a summary page for the information on the hidden sheets.
@timgiles6866
@timgiles6866 6 месяцев назад
This is soooooo helpful - you've solved a problem that I've suffered with for years - thank you
@modglosshouz
@modglosshouz 6 месяцев назад
Excellent! By far the best tutorial there is about unlocking excel file.
@mercicotunav2034
@mercicotunav2034 9 дней назад
Best video and best explanation!!! Solved my problem like a charm!!
@TeacherABC
@TeacherABC 2 месяца назад
I just tried it today. Thank you so much it really works! Just to make sure gonna remove until the word scenario> which was not mentioned in the video. Life saver!
@yvg3228
@yvg3228 Год назад
Amazing. Watched and read others but this is bar-none the best in teaching, tone, tempo...for a tech novice user! Thank you, thank you!
@k311ydcart3r
@k311ydcart3r 8 месяцев назад
Wow. You just saved me a ton of work. Your solution worked like a charm, and your explanation was perfect.
@sezaiturkmen9561
@sezaiturkmen9561 10 месяцев назад
Simple, articulate, to the point explanation! Thanks
@garycline7397
@garycline7397 Год назад
I had done this before but lost the tutorial. Thanks for sharing it has saved me a lot of grief. The file I was working on had 6 protected sheets that are now all unlocked. Thanks again
@BeckyBartram-z3n
@BeckyBartram-z3n Месяц назад
Thank you! That was so clear and I have my worksheet back unprotected.
@carolgregorovic516
@carolgregorovic516 5 месяцев назад
THIS WAS A GREAT INSTRUCTIONAL VIDEO AND SAVED ME HOURS AND HOURS OF WORK!!!!! THANK YOU
@yo0aiya0ng
@yo0aiya0ng 9 месяцев назад
Useful video, especially to show the file types part
@Anorak030
@Anorak030 Год назад
You're the goat of tutorials, thank you so much
@aminrezaie6372
@aminrezaie6372 2 года назад
Excellent job. I was struggling on some xls file and just I saved it as xlsx and then did your thing. Thank you very much
@naginagrandison2354
@naginagrandison2354 2 года назад
Awesome video, our computer person that we hire at our company told me that it could not be done. I followed through and it worked perfectly. Thank you
@SabaTef
@SabaTef 2 года назад
Wow I find this months after I gave up trying to remember a password I set on a worksheet. I just opened it using your teaching. Thank you!
@asheshagupta1289
@asheshagupta1289 Год назад
excellent explanation, thanks for sharing with so much detail and clarity.
@brettstevenson947
@brettstevenson947 Год назад
Great video. Is there are way to make protection on excel bulletproof so that it cannot be broken other than with one's password?
@anubhutiagrawal6238
@anubhutiagrawal6238 Год назад
You saved my job. Thanks a lot for this video. Very helpful.
@DemetriPanici
@DemetriPanici 3 года назад
This is extremely helpful! Thank you so much!
@snakebite396
@snakebite396 2 года назад
Thanks a lot. But in my case what if the VBA is also password protected. When I tried the . zip method the xl folder is not available. Is there any other way to remove the password. Thanks in advance
@highcotton63664
@highcotton63664 2 года назад
OMG it worked! Sooo happy. My computer gave me the option to put the edited file back into the zip drive and delete the other, so I chose that and it did it for me. I then changed it back to an excel doc and boom, all good. Thanks much!
@luciosila
@luciosila 4 месяца назад
Excelent. Thx for your work, saved my day.
@YoussefTsun
@YoussefTsun Год назад
For those who found their files shown as corrupted or extension error. Please follow the steps carefully, try not to delete something outside the protection parenthesis. And mostly important, try to return your file extension to its original form. If your file was .xlsm because it had macro in it. Then return it to .xlsm not .xlsx. Good luck. And all thanks to the video publisher
@wandagreer9144
@wandagreer9144 2 года назад
You are AWESOME! Thanks for all you do! Can you do a video about finding lost files? I have an Excel file that displays a banner notice that a more recent version is available - and I know there is - yet when I click on "restore" I get an error that it does not exist, even tho the file name is in the list of available files. What could have happened and how to access this data and how to fix it? I'd appreciate any help from anyone.
@groupproject7421
@groupproject7421 5 месяцев назад
Great explanation and video. I highly recommend.
@skm5974
@skm5974 Год назад
Excellent stuff. Worked exactly like it should. Much appreciated
@GarangSamuelChan
@GarangSamuelChan 5 дней назад
Very great tutorial. I like it
@morarubogdan972
@morarubogdan972 5 месяцев назад
this is a correct explication. great job. Thank you!
@anissouzerrout8505
@anissouzerrout8505 Год назад
Works like a charm! Thank you!
@cadelinaxian
@cadelinaxian 4 месяца назад
Very helpful ❤ Thank you so much and God Bless
@joshuanettleton6210
@joshuanettleton6210 3 года назад
Nice. I love that this trick goes into the source code.
@AliAhmad-zl3if
@AliAhmad-zl3if 5 месяцев назад
Worked wonders, took 10 min, thx!
@loressathompson9812
@loressathompson9812 Год назад
This was very helpful. Thanks so much
@sefayolaydin574
@sefayolaydin574 20 дней назад
I appreciate you saved the day!🥳
@poormanat-work5401
@poormanat-work5401 Год назад
Thank you very much I just follow your direction and it worked. I’ve been trying to find out how to get my excel sheet up and now I did you just save me a crap load of work.
@karolinapakostova4264
@karolinapakostova4264 2 года назад
It worked! Thank you! Just finished the task for my interview!:)))
@Chachabinks
@Chachabinks 2 года назад
I've converted my .xlsx file to .zip. However, whenever I attempt to Open the new .zip folder I get an error message stating: "Windows cannot open the folder. The Compressed (zipped) Folder is invalid." Any suggestions?
@nhacmottiengkhongquangcao7439
@nhacmottiengkhongquangcao7439 2 года назад
Same issuse
@Ameer-e-Pakistan
@Ameer-e-Pakistan 5 месяцев назад
It's strange to give your heart to those who are able to reciprocate but ignore those who cannot.
@jerrystanley3802
@jerrystanley3802 Месяц назад
Same Issue
@spartianonwsu
@spartianonwsu 10 месяцев назад
you saved hours of work thank you
@techteachersandstudents
@techteachersandstudents 10 месяцев назад
You're welcome! And thank you so much for your kind gift. I really appreciate it!
@JeffLafrenz
@JeffLafrenz Год назад
Excellent tutorial! I was even able to use this method on a Mac using WinZip to look at end extract the sheet.xml data, fixing it and reinsering the corrected xml. Fantastic.
@nadimfaiz
@nadimfaiz 7 месяцев назад
dear concern,. thank you for this informative video.
@AhmadHaidar-o8b
@AhmadHaidar-o8b Год назад
That's amazing, I am very interested, thank you so much.
@williamblake9096
@williamblake9096 4 месяца назад
Working properly, thanks 👍
@SARTHAKTHEMAN
@SARTHAKTHEMAN 2 года назад
This is soo better.I can finally unlock my hard working execel
@qwerty-tz4pe
@qwerty-tz4pe 3 года назад
Please make more Excel content, especially much more of macro's, powerquery and dashboards.
@naimurhussain5129
@naimurhussain5129 3 месяца назад
IT REALLY WORKS!! THANKS A LOT
@kanadroy7640
@kanadroy7640 9 месяцев назад
Thank u Sir.... just excellent 👍🏻
@Cahangir
@Cahangir Год назад
Thanks for the useful upload, keep up the good work!
@rollonairacoleeneibanez5238
Thank you very much it helped me a lot!!!!!!!!!!!
@elmiraalipour6378
@elmiraalipour6378 2 года назад
Please accept my deepest thanks. It 'was so helpful ..
@NikhilKumar_241
@NikhilKumar_241 Год назад
Thanks man ,great 😃👍 million thanks to you 😁
@harckinwunmyorladohsu
@harckinwunmyorladohsu 6 месяцев назад
Thank you. It really work for me
@2Bad2Real
@2Bad2Real 3 месяца назад
Worked! Thank you!
@MadalitsoMalinga-r9o
@MadalitsoMalinga-r9o Месяц назад
Excellent sire🎉🎉
@renmaki6159
@renmaki6159 2 года назад
thanks so much! I've been wondering why I couldn't change extensions anymore
@awesomefootlights1249
@awesomefootlights1249 Год назад
Thank you so much it really helped me out
@ATP576
@ATP576 Год назад
Very nice man, thanks a lot!
@mattcapasso3974
@mattcapasso3974 Год назад
Thanks!
@techteachersandstudents
@techteachersandstudents Год назад
Thanks so much for your kind gift. Sorry it took me so long to say thanks, but I really do appreciate it.
@bartclerx9872
@bartclerx9872 7 месяцев назад
very useful, thanks!
@pasneldoxa
@pasneldoxa Год назад
Thank you!!! You saved my day
@Noelito40
@Noelito40 2 года назад
I have just three things to say to you for this video!...thank you, thank you, thank you!!! 👋👋😃😃
@mdarif7263
@mdarif7263 Год назад
WOW! Unbelievable! Many thanks Sir.
@FarkhodRadzhapov
@FarkhodRadzhapov Год назад
LEGEND!!!
@nicholdas
@nicholdas 2 года назад
Thank you bro!! Saved us a huge amount of time and money with this video!
@nonoobott8602
@nonoobott8602 2 года назад
This is so useful. I've learned so much on your channel. Thanks for sharing
@henrikozan9568
@henrikozan9568 3 месяца назад
Thank you it works 100%
@infernousbot6854
@infernousbot6854 2 месяца назад
Great video
@francisdelgadovargas5399
@francisdelgadovargas5399 Год назад
doesn't work, it says the document is damaged after changing the extension
@mjb244
@mjb244 10 месяцев назад
Worked for me. Thanks! I now feel like I'm a profesional hacker 😅
@bakhtovarsharipov946
@bakhtovarsharipov946 22 дня назад
Thank you
@Zagor1913
@Zagor1913 3 года назад
Will you be doing some videos about Excel VBA and is it worth learning it??
@taniahermawan
@taniahermawan Год назад
Hello, when I changed to ZIP and try to open it, it becomes invalid. How to go about it?
@teoxengineer
@teoxengineer 3 года назад
Thank you so much for this great trick. I'm wondering if we could make protection for an excel sheet by using VBA, is your technique valid or not?
@gunnerwilliamson4046
@gunnerwilliamson4046 Год назад
Excellent thank you
@petervoosukiong-3933
@petervoosukiong-3933 Год назад
Thank you very much appericiate it
@kimberlyshipley1037
@kimberlyshipley1037 5 месяцев назад
AMAZING! THANK YOUUUUUU
@louamato6332
@louamato6332 2 года назад
Worked like a charm after a bit of work to follow your instructions. I found the first step difficult because Windows 11 hides their "File" command for some crazy, unknow reason. Well done, once again and a hearty "thank you"
@ReannasVision
@ReannasVision Год назад
THANK YOU SO MUCH!
@5ftofFury
@5ftofFury Год назад
Oh my Excel - THANK YOU!! I had to do this twice but it worked the second time. Cheers very much for this tutorial :)
@ArmadilloGodzilla
@ArmadilloGodzilla 2 года назад
When I try this, I can't open the zip file. It says it's an invalid zip file.
@arunsikerwar
@arunsikerwar 2 года назад
same problem , it's not working.
@rockeye
@rockeye 2 года назад
Also chiming in with same problem. “Invalid zip file”
@gavingarmston867
@gavingarmston867 2 года назад
It's possible your excel file was a .xls, not a .xlsx. It only works with .xlsx, but changing from one to the other is as simple as a save as.
@wandertrailstruenorth
@wandertrailstruenorth 2 года назад
Didn’t work for me Either and it’s an .xlsx file
@beest_
@beest_ Год назад
Open the file in 7zip or another zip program. All the XLSX or docx are open doc formats which are just XML and style sheets.
@thebolehone7210
@thebolehone7210 Год назад
super easy thanks
@stephaniceloso3568
@stephaniceloso3568 10 месяцев назад
it works! Thank you!
@regans.2785
@regans.2785 2 года назад
My man!! Great Video. Thank you!
@SiggyMX
@SiggyMX 2 года назад
Holy crap not only you saved me but WOW that was so very well explained. THANKS
@arakashmirganio
@arakashmirganio 2 года назад
Very helpful, thank you!
@kymhausmann8357
@kymhausmann8357 2 года назад
Brilliant thank you so much. Success
@lawrencekazibwe9751
@lawrencekazibwe9751 3 года назад
Thanks alot boss, it's has been very informative
@astrophilegir23
@astrophilegir23 5 месяцев назад
It works, thank u 🙌🙌
@zqtan4092
@zqtan4092 2 года назад
Thank you so much for this tip!! However, I have an issue where there is a Sheet 2.xml, but the sheet is hidden when I open the excel file. Is there anyway to unhide it? I tried the VBA method, but its show visible.
@paulle1553
@paulle1553 2 года назад
Very cool tip! Thank you.
@WillievanGraan84
@WillievanGraan84 Год назад
You are a legend, Ive been through other videos but they did not show me how to unhide the file name so I can change it to ".zip. and then back to .xlxs. your video is by far the best explanation of the whole process. I appreciate you. Im subcribing to your channel. Keep up the great work
@dan23haslin25
@dan23haslin25 Год назад
Quick question.. how can you choose which page to unlock if the work book contains multiple tabs [ for eg: 15 tabs] ? thx
@YoussefTsun
@YoussefTsun Год назад
If your sheets has costumized named, then count the no. of your target sheet and find it due to that
@patguitarcovers5215
@patguitarcovers5215 2 года назад
Didn't work for me. It says, "This archive is either in unknown format or damaged." I reverted the file extension to xlsx and I could still open it in Excel.
@jokar70
@jokar70 Год назад
Hi did you find a solution about your message? I have the same issue.
@patguitarcovers5215
@patguitarcovers5215 Год назад
@@jokar70 Sadly, no. I gave up on it and just redid the whole thing.
@harckinwunmyorladohsu
@harckinwunmyorladohsu 6 месяцев назад
Sorry about that though
@Divyanshithakur6536
@Divyanshithakur6536 2 года назад
Thank you so much, it's great help
@iwillbethere2841
@iwillbethere2841 3 года назад
Nice share. Is it working on word file or power point also? Thx
Далее
Convert Excel Data into a Google Map
8:46
Просмотров 182 тыс.
Using Excel's XLOOKUP Function
11:16
Просмотров 101 тыс.
Cracking Encrypted Microsoft Office Files
7:58
Просмотров 13 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
How to Remove Different Excel Passwords (Quick & Easy)
10:00