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.
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.
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 👍😊
Fascinating video, thank you. And for the tip on the safest way to protect a workbook. (One observation: a couple of times you refer to opening the xlsx in a "browser", which confused me a little until I realised you were referring to File Explorer)
To whoever is struggling because the zip file seems broken and can't open it: you're probably working on a xls file. The file needs to be XLSX. Open the file, save as XLSX file. Now you can rename the new xlsx file, changing its extension to ZIP, and open it. Idk why it works, it just worked for me. Cheers
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. 👍
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.
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
I have a file that is locked because of a forgotten password, it has the "File Open Protection" which you discuss at 8:23. I know you mention 3rd party app to assist with this, still no way to unlock without 3rd party apps? If not, what apps you reccomend?
use Passfab, Passper or Passwipe, those are clones. If you do not have access to a server, prepare for a long time process involving either a dictionnary (search the internet for "weakpass") or brute force attack
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.
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.
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?
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
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
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?
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
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.
Thanks Lady. But I face some technical error. WinRAR Diagnostic message The archive is either is unknow format or damaged.... Do you have any solution? waiting for swift response.
Have you tried using Microsoft explorer to unzip it, rather than a 3rd party app like WinRAR? Or it may simply be that you have the password at the file level, as per the last example.
@@tutorials--1234 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.
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.
I suspect the password is at the File > Open stage of the workbook, in which case it's the last scenario for which it's unlikely you'll be able to remove it.
I suspect the password is at the File > Open stage of the workbook, in which case it's the last scenario I cover in the video for which it is unlikely you'll be able to remove it.
❓Ever lost access to your Excel file? Share your story.
Learn Excel with my courses: bit.ly/password22courses
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.
Wonderful to hear!
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.
Glad it helped!
incredibly helpful. I have seen other videos explaining these techniques, but yours is the clearest and simplest to follow. well done!
Awesome, thank you, Eliot!
@@MyOnlineTrainingHub Can you help me remove excel password? I forgot pass
Such a simple video to follow but it saved me so much work! Thank you!
Awesome to hear 😊
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 👍😊
So pleased to hear that!
Wonderful tips! Its kinda suffering when I forgot the password that I have set. Thank you! Incredible video ever!
Glad you liked it 🙏
Fascinating video, thank you. And for the tip on the safest way to protect a workbook. (One observation: a couple of times you refer to opening the xlsx in a "browser", which confused me a little until I realised you were referring to File Explorer)
👍
Hi Mynda!Super Helpful And Clear Explanations...Thank You :)
Great to hear, Darryl!
Excellent stuff Mynda
Thank you!
Many thanks Mynda, for sharing a video that clearly explains password unprotecting under various situations in excel.
My pleasure, Shiffa!
Worked a treat - THANK YOU!
Awesome to hear 👍
LIFE SAVER!!!!! Yes I'm using my new skills for the greater good 😀 Thank you so much for the tutorial for this!!!
Awesome to hear!
Saved my day. Thank you very much.
You're welcome! Glad I could help.
Wow Mynda! Nice usefull tips! Thanks a lot!
You're so welcome!
thank you for this resource! saved me a few hours of recreating a sales document.
Glad I could help!
God bless you Madam. A life saver
Glad it was helpful!
very helptull video, thanks a lot mam, take ❤
Most welcome 😊
Super helpful video. Thanks a million for sharing, Mynda.
You are so welcome, Ekki!
To whoever is struggling because the zip file seems broken and can't open it: you're probably working on a xls file. The file needs to be XLSX. Open the file, save as XLSX file. Now you can rename the new xlsx file, changing its extension to ZIP, and open it.
Idk why it works, it just worked for me.
Cheers
Wow! You still use .xls files. They went out with Excel 2003 😉 Thanks for sharing your tip.
@@MyOnlineTrainingHub hahahahah not by choice I swear. I work on what I've been given. Thanks for the video and have a good day!
How would you open it if its password protected ?
@@abhishekmor we're talking about excel files that have single sheets protected by passwords
@@SandroLimaj OK is there a way to open protected excels workbooks ?
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.
👍
Yes, exactly that 😊
Thanks Mynda for the information.
You are so welcome!
Thank you for the tutorial
You’re welcome 😊
Wow, its really great to find this video that makes me back to my work. Thank you.
Glad it was helpful!
Thank you very much your guidance. keep it up.
Thank you, I will 😊
Thank you, it was very helpful and saved me a lot of time.
Great to hear!
Super helpful, thanks Mynda!
Cheers, Chris!
As always, great tips! Thanks a lot, Mynda 🙂
Glad you like them! 🙏
Wonderful technique
Thank you!
Amazing tips!
Glad you think so!
It was a life saver. Thank you!
Glad I could help!
Saved me hours. Thankyou
Glad I could help!
incredibly helpful
Great to hear 🙏
You're genius. It works!
Glad it helped 😊
thank you so much for the help.
You're welcome!
Very helpful tutorial... Good.
Glad you think so!
Very helpful. Thank you
Great to hear!
Thank you very much!
I always forget my passwords.
I love your channel, your didactics and affection in passing on knowledge are incredible.😀
So nice of you to say, Marcelo!
Superb Mynda, explained very clearly.... Thanks a lot ❤
Glad you liked it
Very nice info, thank you for sharing.
Glad it was helpful!
AMAZING! You saved me a great deal! Thank you, subscribing!
So pleased I could help!
Amazing. thank you.
Glad it was helpful!
Thank you for your helping
My pleasure!
Thank you so much, it worked!!!
Glad it helped!
This is brilliant!! Thank you!!
Glad you liked it!
Thank u for this video 📹. How did u open the XML in one note ?
I'm using Notepad ++, not OneNote.
Great video and well explained. Thank you.
Glad you enjoyed it!
Excellent as always! Thank you!
Thanks so much, Bob!
Thank you for your video. It’s interesting.
My pleasure 👍
Big thank you !
You're welcome!
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.
Great to hear!
Thank you so much
You're most welcome 😊
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".
@ansicin6883 no. This has been resolved. Luckily the user found the pw.
Great Helpful tutorial
Glad you think so!
superb video
Thank you so much 😀
that's awesome! thanks!
Glad it was helpful!
You absolute legend.❤
Glad I could help 😊
What a great tip!
Glad you think so!
Thank you very much,really amazing 😍
I'm glad you liked it 🙏
Very nice it was help me thank you very muchs
Most welcome 😊
thank you so much!
You're welcome!
Very useful, thanks
Glad to hear that!
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
Thanks so much 🙏
It is working, bunch of thanks :)
Welcome 👍
Thank you! 🤙
My pleasure, Eduard!
Wow... You are awesome 🙂
Thank you so much 😀
Thank you for the interesting video. Are Excel VBA protected projects as easy to unprotect?
Was wondering this, too!
Looks like it is: www.devhut.net/excel-unlocking-an-excel-vba-project/
V. first trick worked. Thank you for making life easier.
Great to hear!
wow - Thank you
You're welcome!
thank you very very much
My pleasure!
Thx 😊
My pleasure!
Thank you so much
You're welcome!
I have a file that is locked because of a forgotten password, it has the "File Open Protection" which you discuss at 8:23. I know you mention 3rd party app to assist with this, still no way to unlock without 3rd party apps? If not, what apps you reccomend?
No, you need an app, and unfortunately I haven't used any that I can recommend.
use Passfab, Passper or Passwipe, those are clones. If you do not have access to a server, prepare for a long time process involving either a dictionnary (search the internet for "weakpass") or brute force attack
when i hit the delete key it doesnt do anything. it is not deleting the slelected area
Sounds like you haven't opened it in a text editor like Notepad.
thank you and i looove you
My pleasure 😊
"luckily" it is that easy... just succesfully removed one - thanks Mynda
Glad it helped!
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.
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.
having the same issue
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?
Thanks, Dany! I haven't got a VBA example, but I'll add it to my To-Do list!
@@MyOnlineTrainingHub I have VBA Code for breaking the VBA Editor Protection.
Excellent
Glad it was helpful 😊
Great tips Mynda, thank you!
How can we break the VBA password to enter VBA code window?
Do you know it?
Thank you
Hi Emre, it's similar and is explained here: www.devhut.net/excel-unlocking-an-excel-vba-project/
I was hoping for any tips on removing or replacing the password of the older xls format.
Hmm, not that I can point you to, sorry.
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
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
I had same problem
it's super , thx u
Welcome 😊
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?
Glad it helped! Not sure why it would wipe a sheet 🤔
Saved my day =)
But the file has to be unencrypted to to these tricks.
Yes, if the password is at the file level, then you're out of luck, as explained in the last example.
amazing how simple it is :-)
Glad you think so!
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
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.
Thanks for the great video. Is it possible to check the password in the XML tag?
No, you can't find the password, the best you can do is remove it.
@@MyOnlineTrainingHub Thanks for the reply.
That’s awesome ❗️Mynda, what do you recomend to learn, Visual Basic o Java Script❓Thanks
Ooh, good question. I'd probably go with JavaScript as this will have more application going forward.
@@MyOnlineTrainingHub Do you have some course about this❓Thanks
Gracias !!
Pleasure 🙂
Is there a similar process for Word documents?
Not that I know of, sorry.
Superb! This is very Helpful. Thanks for sharing. Can we remove the password of an Excel Macro (Dot xlsm) file in the same manner?
Yes, pretty much.
Thank you I managed to use it for one of my old file I forgot password. User friendly
Glad it helped!
Thanks Lady. But I face some technical error. WinRAR Diagnostic message The archive is either is unknow format or damaged.... Do you have any solution? waiting for swift response.
Have you tried using Microsoft explorer to unzip it, rather than a 3rd party app like WinRAR? Or it may simply be that you have the password at the file level, as per the last example.
Thanks, Mynda. Is it also possible to view the password using this method so that we can unlock the sheet instead of removing protection?
Not that I'm aware of.
wouuuuuuuuuu you are the best .... you got a susbriber to your channel ... muchas gracias!!!
Thanks so much!
thanks
Great explanation as usual! Do you know if there is a similar way to remove the password for opening Visual Basic?
there is... using VBA Code... its much easier.
@@tutorials--1234 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.
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.
Sounds like you have a file that falls into the last scenario I covered. i.e. the password is at the file level.
@@MyOnlineTrainingHub Thank you!
I can't open the zip file, file unvalid error. Any suggestion?
I suspect the password is at the File > Open stage of the workbook, in which case it's the last scenario for which it's unlikely you'll be able to remove it.
I suspect the password is at the File > Open stage of the workbook, in which case it's the last scenario I cover in the video for which it is unlikely you'll be able to remove it.