Тёмный

Forgotten your Excel Password? How to Unprotect Excel Without a Password! 

MyOnlineTrainingHub
Подписаться 631 тыс.
Просмотров 287 тыс.
50% 1

Forgotten your Excel passwords? No problem. With these techniques you can easily remove Excel password protection for sheets, workbooks and Read Only files.
🔻 WRITTEN INSTRUCTIONS HERE: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 How to remove Excel Passwords
0:27 Worksheet Protection
1:02 Removing Worksheet Passwords
4:16 Workbook Protection
4:44 Removing Workbook Passwords
6:21 Read Only File Protection
7:18 Removing Read Only Protection
8:21 File Open Protection

Наука

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

 

6 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 494   
@pw4721
@pw4721 11 месяцев назад
After looking at numerous 'How to' videos this is the first one that really work to remove sheet/workbook protection. Very clear and straightforward video.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 месяцев назад
Glad it helped!
@christopherpanford7584
@christopherpanford7584 Год назад
This was super helpful. My accountant left a couple of months ago and when I recruited a new one, we realised that our entire books were protected. We have been struggling to get it unprotected for weeks, and within 10mins your video has done the magic. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Wonderful to hear!
@EliotPowell
@EliotPowell 2 года назад
incredibly helpful. I have seen other videos explaining these techniques, but yours is the clearest and simplest to follow. well done!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Awesome, thank you, Eliot!
@caongoc1204
@caongoc1204 Год назад
@@MyOnlineTrainingHub Can you help me remove excel password? I forgot pass
@shiffamohammed5818
@shiffamohammed5818 2 года назад
Many thanks Mynda, for sharing a video that clearly explains password unprotecting under various situations in excel.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
My pleasure, Shiffa!
@marcelolaguna2012
@marcelolaguna2012 Год назад
Thank you very much! I always forget my passwords. I love your channel, your didactics and affection in passing on knowledge are incredible.😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
So nice of you to say, Marcelo!
@waynegill2613
@waynegill2613 8 месяцев назад
Such a simple video to follow but it saved me so much work! Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 месяцев назад
Awesome to hear 😊
@ekkiwurm7874
@ekkiwurm7874 Год назад
Super helpful video. Thanks a million for sharing, Mynda.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You are so welcome, Ekki!
@darrylmorgan
@darrylmorgan 2 года назад
Hi Mynda!Super Helpful And Clear Explanations...Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Great to hear, Darryl!
@chrism9037
@chrism9037 2 года назад
Super helpful, thanks Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Cheers, Chris!
@tokinabo
@tokinabo Год назад
As always, great tips! Thanks a lot, Mynda 🙂
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad you like them! 🙏
@notesfromleisa-land
@notesfromleisa-land Год назад
I recently had to use the zip file technique to fix a workbook that would not save as I was getting corrupted and repairs so extensive msgs that make you weep as tons of time in the workbook creation. Removing a bin file using the zip technique saved the day. Here is yet another way to slice and dice. As always great vid content perfectly presented
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thanks so much 🙏
@MlguelM
@MlguelM 2 года назад
Wow Mynda! Nice usefull tips! Thanks a lot!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
You're so welcome!
@terrycathie115
@terrycathie115 4 месяца назад
The zip file worked for me and I can’t thank you enough. A great deal of work had gone into the spreadsheet and I was pretty upset with myself. Thanks again 👍😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 месяца назад
So pleased to hear that!
@arjungovindan178
@arjungovindan178 Год назад
Superb Mynda, explained very clearly.... Thanks a lot ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad you liked it
@bobmoorehead8553
@bobmoorehead8553 2 года назад
Excellent as always! Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Thanks so much, Bob!
@noahmayorestor8459
@noahmayorestor8459 Год назад
Wow, its really great to find this video that makes me back to my work. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@adammaamoun1
@adammaamoun1 8 месяцев назад
Thank you, it helped a lot. It is important to save a copy of the xml file we are editing because I messed up multiple times since I was not using Notepad ++ and didn't know when the workbookprotection and sheetprotection statements ended. Yes, your instructions were used for legal process to unprotect an excel file I forgot its password.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 месяцев назад
Great to hear!
@Vandalfoe
@Vandalfoe Год назад
Good stuff as usual. I agree this isn't super-spy level protection, but in my opinion it does the job of preventing users (who don't Excel) from typing numbers over your formulas because they're not using the spreadsheet properly. 👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Yes, exactly that 😊
@mannycorrea5896
@mannycorrea5896 Год назад
Incredible video. Thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad you liked it!
@will5470
@will5470 Год назад
thank you for this resource! saved me a few hours of recreating a sales document.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad I could help!
@jawadahmadehssan6251
@jawadahmadehssan6251 2 года назад
Thanks Mynda for the information.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
You are so welcome!
@powerb_i
@powerb_i 2 года назад
Great video and well explained. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad you enjoyed it!
@MsChampohsan
@MsChampohsan 9 месяцев назад
Wonderful tips! Its kinda suffering when I forgot the password that I have set. Thank you! Incredible video ever!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 месяцев назад
Glad you liked it 🙏
@HimeshDharmameher
@HimeshDharmameher Год назад
Excellent stuff Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thank you!
@Liz-u7o
@Liz-u7o Год назад
AMAZING! You saved me a great deal! Thank you, subscribing!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
So pleased I could help!
@garygarland9366
@garygarland9366 7 месяцев назад
Worked a treat - THANK YOU!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 месяцев назад
Awesome to hear 👍
@rhonalkhairul3969
@rhonalkhairul3969 Год назад
Very nice info, thank you for sharing.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@sudds50
@sudds50 2 года назад
This is brilliant!! Thank you!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad you liked it!
@traciedwards7449
@traciedwards7449 Месяц назад
LIFE SAVER!!!!! Yes I'm using my new skills for the greater good 😀 Thank you so much for the tutorial for this!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Awesome to hear!
@vijaykumar140292
@vijaykumar140292 Месяц назад
Thank you, it was very helpful and saved me a lot of time.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Great to hear!
@user-qr8oe2fs5h
@user-qr8oe2fs5h Год назад
God bless you Madam. A life saver
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@odel_leal
@odel_leal 2 года назад
Thank you for your video. It’s interesting.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
My pleasure 👍
@Johnmel1993
@Johnmel1993 Год назад
Very helpful. Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Great to hear!
@yuvarajarajasekaran7997
@yuvarajarajasekaran7997 11 месяцев назад
Thank you very much your guidance. keep it up.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 месяцев назад
Thank you, I will 😊
@eslammaher8696
@eslammaher8696 Год назад
Thank you very much,really amazing 😍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
I'm glad you liked it 🙏
@omerabdu9093
@omerabdu9093 2 года назад
Great Helpful tutorial
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad you think so!
@ST-di6nl
@ST-di6nl 21 день назад
It was a life saver. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 день назад
Glad I could help!
@basitalisyed9445
@basitalisyed9445 2 года назад
Very helpful tutorial... Good.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad you think so!
@nunocorreia5570
@nunocorreia5570 2 года назад
Very useful, thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Glad to hear that!
@matingholizade647
@matingholizade647 Год назад
incredibly helpful
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Great to hear 🙏
@yashkatariya7922
@yashkatariya7922 Год назад
thank you so much for the help.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're welcome!
@aurelieneveu9595
@aurelieneveu9595 Год назад
Big thank you !
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're welcome!
@jhoanramiso1168
@jhoanramiso1168 29 дней назад
Thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 29 дней назад
You're welcome!
@sadeemalolayan1568
@sadeemalolayan1568 Месяц назад
Thank you for your helping
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
My pleasure!
@RT-up6ml
@RT-up6ml Год назад
Thank you I managed to use it for one of my old file I forgot password. User friendly
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it helped!
@aamir6666
@aamir6666 Год назад
Amazing. thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@williamlongbottom5494
@williamlongbottom5494 7 месяцев назад
Saved me hours. Thankyou
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 месяцев назад
Glad I could help!
@EduardKorkia
@EduardKorkia 2 года назад
Thank you! 🤙
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
My pleasure, Eduard!
@daniellazylen5350
@daniellazylen5350 Год назад
that's awesome! thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad it was helpful!
@rajeshchawda9449
@rajeshchawda9449 2 года назад
Superb! This is very Helpful. Thanks for sharing. Can we remove the password of an Excel Macro (Dot xlsm) file in the same manner?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Yes, pretty much.
@Joanne4Res
@Joanne4Res 5 дней назад
thanks, this is a very clear video. So glad you suggested doing it on a copy to work on because didn't fully work for me and wiped the sheet I needed the password removed from? do you know why this would be please?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 дня назад
Glad it helped! Not sure why it would wipe a sheet 🤔
@emile8147
@emile8147 Год назад
thanks for the tricks ! for the sheet protection level (if you can select all the cells), you can just select all the cells, copy, create a new sheet, paste on A1. the new sheet is not protected there's too some VBA code to unprotect the sheet, probably too to unprotect workbook
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Yes, it they've allowed cell selection, then copying and pasting is an option. It all depends how complex the file is as to how successful that would be. The VBA unprotection code was required for .xls file types, but with .xlsx we can simply unzip the file and locate the settings.
@user-mu7te7uz8n
@user-mu7te7uz8n 10 месяцев назад
You're genius. It works!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 месяцев назад
Glad it helped 😊
@AhmedElsayed-ur8hv
@AhmedElsayed-ur8hv Год назад
Very nice it was help me thank you very muchs
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Most welcome 😊
@mariamafshar9210
@mariamafshar9210 Год назад
It is working, bunch of thanks :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Welcome 👍
@navychhun4645
@navychhun4645 Год назад
thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're welcome!
@syedshas7105
@syedshas7105 Год назад
Thank you so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're most welcome 😊
@FishFinderHeroes
@FishFinderHeroes 11 месяцев назад
very helptull video, thanks a lot mam, take ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 месяцев назад
Most welcome 😊
@nadermounir8228
@nadermounir8228 Год назад
Thank u for this video 📹. How did u open the XML in one note ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
I'm using Notepad ++, not OneNote.
@emmapilex
@emmapilex 2 месяца назад
Excellent
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 месяца назад
Glad it was helpful 😊
@heinzthedutch
@heinzthedutch Месяц назад
"luckily" it is that easy... just succesfully removed one - thanks Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Glad it helped!
@teoxengineer
@teoxengineer Год назад
Great tips Mynda, thank you! How can we break the VBA password to enter VBA code window? Do you know it? Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Hi Emre, it's similar and is explained here: www.devhut.net/excel-unlocking-an-excel-vba-project/
@meicromini
@meicromini 6 месяцев назад
You absolute legend.❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 месяцев назад
Glad I could help 😊
@soc5830
@soc5830 Год назад
Hello Ma'am, thank you for taking the time making this video. I'm getting a prompt when trying to open the zip. "copy.zip is invalid".
@soc5830
@soc5830 11 месяцев назад
@ansicin6883 no. This has been resolved. Luckily the user found the pw.
@evo.gaming255
@evo.gaming255 5 месяцев назад
superb video
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 месяцев назад
Thank you so much 😀
@ProsenjitBappi
@ProsenjitBappi Год назад
Wow... You are awesome 🙂
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thank you so much 😀
@vinicsurveying
@vinicsurveying 2 года назад
Great explanation as usual! Do you know if there is a similar way to remove the password for opening Visual Basic?
@byronstutorialspage2134
@byronstutorialspage2134 2 года назад
there is... using VBA Code... its much easier.
@vinicsurveying
@vinicsurveying 2 года назад
@@byronstutorialspage2134 thanks for confirming that. I assume that the VBA code must be run from another spreadsheet in that case? I was hoping that you could make it so that the VBA code is not accessible.
@alejos1
@alejos1 Год назад
wow - Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're welcome!
@filippoxodo3354
@filippoxodo3354 Год назад
thank you very very much
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
My pleasure!
@_S.H_
@_S.H_ Месяц назад
I was hoping for any tips on removing or replacing the password of the older xls format.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Hmm, not that I can point you to, sorry.
@eyalbaruch7874
@eyalbaruch7874 Год назад
amazing how simple it is :-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Glad you think so!
@huyne_info
@huyne_info Год назад
Thank you so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
You're welcome!
@Daithai96
@Daithai96 2 года назад
I've always written macros that apply that protection as soon as the workbooks open. So, you could use these techniques, but unless you could also hack the VBA code, it wouldn't work on the useable file. But, still a very interesting video
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Nice trick, Dave! You can remove VBA protection with a similar technique to editing the zip file.
@Daithai96
@Daithai96 2 года назад
@@MyOnlineTrainingHub Yeah, you can indeed. I wouldn't try to write a security app using VBA, but the number of people that are able to hack the VBA code is relatively small in my experience.
@baboomka
@baboomka Год назад
thanks
@yahyaalramadan4665
@yahyaalramadan4665 2 года назад
Thank you for the interesting video. Are Excel VBA protected projects as easy to unprotect?
@matroosoft4589
@matroosoft4589 2 года назад
Was wondering this, too!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Looks like it is: www.devhut.net/excel-unlocking-an-excel-vba-project/
@elsalorenzana6795
@elsalorenzana6795 Год назад
You are the best! I follow you since a year ago and I find your tutorials very helpful. Thanks :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Awesome to hear, thank you!
@joseriosperic8676
@joseriosperic8676 2 месяца назад
Gracias !!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 месяца назад
Pleasure 🙂
@boyapatirakesh6913
@boyapatirakesh6913 5 месяцев назад
it's super , thx u
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 месяцев назад
Welcome 😊
@gonzuic
@gonzuic 2 года назад
That’s awesome ❗️Mynda, what do you recomend to learn, Visual Basic o Java Script❓Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Ooh, good question. I'd probably go with JavaScript as this will have more application going forward.
@gonzuic
@gonzuic 2 года назад
@@MyOnlineTrainingHub Do you have some course about this❓Thanks
@chaitanyapatwari
@chaitanyapatwari Год назад
Thanks, Mynda. Is it also possible to view the password using this method so that we can unlock the sheet instead of removing protection?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Not that I'm aware of.
@cooljoker2027
@cooljoker2027 Год назад
thank you and i looove you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
My pleasure 😊
@Dany-ns6hg
@Dany-ns6hg 2 года назад
Good one and very helpful, I remember this trick long back someone shared with me but it helped me to recollect. Do you have any trick to unlock VBA editor password because I lock most of my files for VBA editor so that user should not change code?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Thanks, Dany! I haven't got a VBA example, but I'll add it to my To-Do list!
@byronstutorialspage2134
@byronstutorialspage2134 2 года назад
@@MyOnlineTrainingHub I have VBA Code for breaking the VBA Editor Protection.
@IvanCortinas_ES
@IvanCortinas_ES 2 года назад
Without having to eliminate the entire sheetProtection clause, it is also possible to change the sheet, objects and scenarios sections (within sheetProtection) from 1 to 0 within said clause and continue with the process.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Nice tip, cheers, Ivan!
@paullindod
@paullindod 2 месяца назад
Thanks for the great video. Is it possible to check the password in the XML tag?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 месяца назад
No, you can't find the password, the best you can do is remove it.
@paullindod
@paullindod 2 месяца назад
@@MyOnlineTrainingHub Thanks for the reply.
@KarenGonzalez-cf4jk
@KarenGonzalez-cf4jk Год назад
Hi! I'm also having problems by trying this method. Whenever I'm looking for the word "protected" or some variant (the whole workbook is protected) it isn't on the code anymore. Is it possible they've updated the security? I would really appreciate your thoughts on this! I love your videos!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
If the file is protected at the File Open step, then you're dealing with the last example covered in the video, in which case you can't use the zip file technique.
@MrPaulHausser
@MrPaulHausser Год назад
Thx 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
My pleasure!
@goodone05004
@goodone05004 Год назад
So if you put a password to open the file and a different password for the sheets, then people can't remove either of those passwords by the methods you showed right? Your videos are way better than the other excel channels btw. Thank you for the amazing work
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thank you 🙏 yes, if you password protect the file to open it then that password can’t be removed using these techniques, therefore the password for the sheets is also protected.
@Vandalfoe
@Vandalfoe Год назад
In fact, the passwords needn't even be different; they'll never get into the zip file anyway. 👍
@ericc.3524
@ericc.3524 Год назад
Hello Mynda and thank you for the great video. After I copy and rename the file extension to .zip, it won't extract all and I get a window prompt indicating the compressed file is empty. The file size in properties appears the same as the original worksheet, however. Kindly advise. Many thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Sounds like you have a file that falls into the last scenario I covered. i.e. the password is at the file level.
@ericc.3524
@ericc.3524 Год назад
@@MyOnlineTrainingHub Thank you!
@rassaville
@rassaville 6 месяцев назад
Thank you for the video. It seems that I have some sort of problem because when I try to rename the file as .zip it does not change the file type to compressed file but keeps it as Excel. I tried the same thing with a blank Excel file and have the same problem. Is this something to do with the version of Office or what?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 месяцев назад
It shouldn't matter what version of Office you have. Perhaps you don't have file extensions displaying in File Explorer, so renaming actually changes the file name, but not the extension.
@szymongrabarczyk3561
@szymongrabarczyk3561 Год назад
You actually can unzip protected file, open worksheets and some info is visible but most is encrypted.
@ashu17981
@ashu17981 6 месяцев назад
Thank you so much for the wonderful information. I am able to crack the password. Protected to Un-Protected
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 месяцев назад
Glad I could help 😊
@jesus.moreno
@jesus.moreno Год назад
wouuuuuuuuuu you are the best .... you got a susbriber to your channel ... muchas gracias!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thanks so much!
@travis8422
@travis8422 Год назад
I am having difficulty with finding an example of the issue I am running into when trying to do this. First off, I saved the file through the excel options (not the F12 scenario at the end). When I change the copy to a zip and open up the zip file, I am not seeing the same folders/files that I am seeing in all of these YT video examples of the XML file. Instead, I see a folder titled [6]DataSpaces and two "files" (they have no extension) named EncryptedPackage and EncryptedInfo none of which seem to be of use.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
I'm not aware of how you'd save the file via Excel Options. The other way to save a file is via the File tab > Save as. Try using F12 to open the Save As dialog box as shown in the video to see if this solves the problem you're having.
@pattiyawn3242
@pattiyawn3242 Год назад
having the same issue
@Somayeh27
@Somayeh27 Год назад
Thanks a lot, Mynda! I try to rename the excel xlsx format to zip, but when I want to unzip the file it shows window cannot open the folder and the zip is "invalid". What should I do? Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Sounds like you have the last scenario I covered.
@christoslefkimiotis9889
@christoslefkimiotis9889 2 года назад
Great video and I have used the trick (sheet level) a couple of times. Is there any way to retrieve the actual password?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
I don't think so, Christos.
@christoslefkimiotis9889
@christoslefkimiotis9889 2 года назад
@@MyOnlineTrainingHub Thank you very much for the reply. There was an addin that could unprotect sheets and you could see the lenght of the password but not the actual password. So more or less there is no safe way tor your data and files.Thanks
@enzym2004
@enzym2004 Год назад
Saved my day =)
@enzym2004
@enzym2004 Год назад
But the file has to be unencrypted to to these tricks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Yes, if the password is at the file level, then you're out of luck, as explained in the last example.
@hsmmadmunir
@hsmmadmunir 2 года назад
Thanks.. I have created a template where I have locked some fields so that my colleagues don't play with them.. but I want add/delete rows but the formulas and format should also be applied to the new row.. is that possible?
@goldenghostinc
@goldenghostinc 2 года назад
Not entirely sure about the formulas, but the rest is possible. If you lock a sheet you get a list of options where you can place checkmarks. Those should enable you to add / delete etc with the password protection on.
@hsmmadmunir
@hsmmadmunir 2 года назад
@@goldenghostinc thanks a lot
@richardhui9176
@richardhui9176 Год назад
Thanks a lot, Mynda! I try to rename excel xlsx format to zip, but it shows window cannot open the folder and copy zip is "invalid". Could you advise what I do? Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Hi Richard, please post your question on our forum where you can share a screenshot showing your file name and we can help you further: www.myonlinetraininghub.com/excel-forum
@Somayeh27
@Somayeh27 Год назад
I had same problem
@tiongah7690
@tiongah7690 2 года назад
is the file open protection the same thing as go to File->Info->Protect Workbook->Encrypt with password?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 года назад
Yes, as far as I can tell.
@chrisjordan1679
@chrisjordan1679 3 месяца назад
I get as far as renaming the file to a zip instead of xlsx. Once I double click on the new file it says it's invalid. Help!
Далее
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Просмотров 2,5 млн
What is going on? 😂 (via haechii_br/IG) #shorts
00:15
Пиратские котики
00:50
Просмотров 109 тыс.
Protect Excel Files - Keep Your Reports Safe
5:34
Просмотров 38 тыс.
The Mistake Almost EVERY Excel User Makes (Free File)
10:16
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32