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.
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
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)
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.
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. 👍
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?
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?
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
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
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.
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.
Just a little bit of precision on the sheet numbers. The XML name may be the same as the one seen in VBA, but not necessarily. From my understanding, it will always be Sheet1, Sheet2... in the XML structure with the number being the tab position (index) on the interface. If you were to move Sheet2 after Sheet3, the VBA would stay the same but "Sheet2" would be "Sheet3" in the XML. So if you have a lot of worksheet, you may need to count the position. I seem to recall that you need to count hidden sheet as well because they have their position once unhidden.
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
@@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.
Any tip on a MS Word password? I'm having a hard time remembering my credentials document password and I don't want to spend an arm and a leg to buy third party softwares to crack it.. any tip?
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
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 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
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.
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!
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.
I thought I remembered using the method you show to actually obtain the password used, but I cant seem to figure out how to do that any longer. Do you happen to know?
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.
Should this be done on the same PC where the file was created ? I tried to do it on mine after having the file emailed to myself, using excel 2016, but it didn't work. What is my lost step here please?
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?
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.
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 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.
Mynda -- After unzipping my password protected Excel sheet, the worksheet folder instead of having all sheet***.xlm files, as in your video above, has only .bin files listed. Also: The unzipped "workbook" file, has a .bin extension. (As opposed to .xml) in your example above. Any thoughts?
Pro Tip for Mac users as well (because I couldn't do this) but I found another way! change the file extension to .csv, it will open with Numbers and remove all passwords!
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
For removing password from sheet protection, unable to copy the xml file back to the zip folder after editing and saving as a copy elsewhere. Windows just keeps giving me: "Compressed (zipped) Folders Error. Windows cannot open the folder. The Compressed (zipped) folder 'D:\File.zip' is invalid", where File.zip is the actual name of my zipped file (renamed .xlsx file). Any idea why?
I think its easy because you just need to protect user from making a change on data on file. If we want, we still can copy paste the data to another excel file and do the job. Its different with open file, because its really prefent random person to read the data
You can only copy and paste the data if the worksheets aren't hidden and workbook protected. i.e. with worksheet protection and assuming they have allowed you to select locked cells.
Seems that this doesn't work anymore? The zip folder only contains the excel file and no longer contains the xl folder when you try to 'extract all' from a zipped version, wonder if others also face similar issues? would be nice to see if there's any other workaround?
❓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
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!
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!
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)
👍
Such a simple video to follow but it saved me so much work! Thank you!
Awesome to hear 😊
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.
Wonderful tips! Its kinda suffering when I forgot the password that I have set. Thank you! Incredible video ever!
Glad you liked it 🙏
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!
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 u for this video 📹. How did u open the XML in one note ?
I'm using Notepad ++, not OneNote.
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 😊
thank you for this resource! saved me a few hours of recreating a sales document.
Glad I could help!
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 🤔
Hi Mynda!Super Helpful And Clear Explanations...Thank You :)
Great to hear, Darryl!
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.
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 🙏
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/
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/
"luckily" it is that easy... just succesfully removed one - thanks Mynda
Glad it helped!
Thank you for the tutorial
You’re welcome 😊
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
V. first trick worked. Thank you for making life easier.
Great to hear!
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
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.
In fact, the passwords needn't even be different; they'll never get into the zip file anyway. 👍
Many thanks Mynda, for sharing a video that clearly explains password unprotecting under various situations in excel.
My pleasure, Shiffa!
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.
You're genius. It works!
Glad it helped 😊
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 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!
I've tried various solutions on StackOverflow but this was the only one that worked!
So pleased I could help 😊
Wow, its really great to find this video that makes me back to my work. Thank you.
Glad it was helpful!
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.
God bless you Madam. A life saver
Glad it was helpful!
Amazing tips!
Glad you think so!
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.
Worked a treat - THANK YOU!
Awesome to hear 👍
Just a little bit of precision on the sheet numbers. The XML name may be the same as the one seen in VBA, but not necessarily. From my understanding, it will always be Sheet1, Sheet2... in the XML structure with the number being the tab position (index) on the interface.
If you were to move Sheet2 after Sheet3, the VBA would stay the same but "Sheet2" would be "Sheet3" in the XML. So if you have a lot of worksheet, you may need to count the position. I seem to recall that you need to count hidden sheet as well because they have their position once unhidden.
Ah, good to know. Thanks for sharing.
Excellent stuff Mynda
Thank you!
AMAZING! You saved me a great deal! Thank you, subscribing!
So pleased I could help!
Thank you, it was very helpful and saved me a lot of time.
Great to hear!
As always, great tips! Thanks a lot, Mynda 🙂
Glad you like them! 🙏
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.
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
Superb Mynda, explained very clearly.... Thanks a lot ❤
Glad you liked it
It was a life saver. Thank you!
Glad I could help!
What a great tip!
Glad you think so!
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.
Wow Mynda! Nice usefull tips! Thanks a lot!
You're so welcome!
Super helpful video. Thanks a million for sharing, Mynda.
You are so welcome, Ekki!
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!
Saved me hours. Thankyou
Glad I could help!
Wonderful technique
Thank you!
You absolute legend.❤
Glad I could help 😊
Any tip on a MS Word password? I'm having a hard time remembering my credentials document password and I don't want to spend an arm and a leg to buy third party softwares to crack it.. any tip?
Ooh, no sorry. If the password is strong, it's unlikely a third party app will be able to crack it anyway.
Thanks Mynda for the information.
You are so 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
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!
Thank you so much, it worked!!!
Glad it helped!
Great video and I have used the trick (sheet level) a couple of times. Is there any way to retrieve the actual password?
I don't think so, Christos.
@@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
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
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!
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.
Thank you I managed to use it for one of my old file I forgot password. User friendly
Glad it helped!
incredibly helpful
Great to hear 🙏
It is working, bunch of thanks :)
Welcome 👍
very helptull video, thanks a lot mam, take ❤
Most welcome 😊
I thought I remembered using the method you show to actually obtain the password used, but I cant seem to figure out how to do that any longer. Do you happen to know?
There's no way to obtain the password AFAIK.
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.
I am doing anything i can do recover my password. Does this work for Mac? Thanks in advance!
Not sure about a Mac, sorry.
Should this be done on the same PC where the file was created ?
I tried to do it on mine after having the file emailed to myself, using excel 2016, but it didn't work.
What is my lost step here please?
It doesn't matter which PC you use. Remember, the password to open the file requires a different process, as covered at the end of the video.
You actually can unzip protected file, open worksheets and some info is visible but most is encrypted.
Super helpful, thanks Mynda!
Cheers, Chris!
Incredible video. Thank you so much!
Glad you liked it!
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?
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.
Thank you for the video, able to unprotect the excel sheet. Better than Chatgpt at the moment😂
😁 glad I could help!
Thank you very much your guidance. keep it up.
Thank you, I will 😊
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
Nice trick, Dave! You can remove VBA protection with a similar technique to editing the zip file.
@@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.
Mynda -- After unzipping my password protected Excel sheet, the worksheet folder instead of having all sheet***.xlm files, as in your video above, has only .bin files listed.
Also: The unzipped "workbook" file, has a .bin extension. (As opposed to .xml) in your example above.
Any thoughts?
Hmm, not sure about the .bin files. 🤔
@@MyOnlineTrainingHub Appreciate your help, Mynda.
Big thank you !
You're welcome!
thank you so much for the help.
You're welcome!
Very helpful. Thank you
Great to hear!
Amazing. thank you.
Glad it was helpful!
Thank you so much!
You're welcome!
Thank you very much,really amazing 😍
I'm glad you liked it 🙏
Thank you for your helping
My pleasure!
Pro Tip for Mac users as well (because I couldn't do this) but I found another way!
change the file extension to .csv, it will open with Numbers and remove all passwords!
Thanks for sharing, Brandon!
is the file open protection the same thing as go to File->Info->Protect Workbook->Encrypt with password?
Yes, as far as I can tell.
Thank you so much
You're most welcome 😊
Thank you for you really nice page and useful videos
I tried this procedure at excel 365 but it did work... Could you check that for me please?
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Excellent as always! Thank you!
Thanks so much, Bob!
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
Sounds like you have the last scenario I covered.
For removing password from sheet protection, unable to copy the xml file back to the zip folder after editing and saving as a copy elsewhere. Windows just keeps giving me:
"Compressed (zipped) Folders Error.
Windows cannot open the folder.
The Compressed (zipped) folder 'D:\File.zip' is invalid",
where File.zip is the actual name of my zipped file (renamed .xlsx file).
Any idea why?
Thank you! 🤙
My pleasure, Eduard!
that's awesome! thanks!
Glad it was helpful!
Thank you for your video. It’s interesting.
My pleasure 👍
Great video and well explained. Thank you.
Glad you enjoyed it!
amazing how simple it is :-)
Glad you think so!
I think its easy because you just need to protect user from making a change on data on file. If we want, we still can copy paste the data to another excel file and do the job. Its different with open file, because its really prefent random person to read the data
You can only copy and paste the data if the worksheets aren't hidden and workbook protected. i.e. with worksheet protection and assuming they have allowed you to select locked cells.
Seems that this doesn't work anymore? The zip folder only contains the excel file and no longer contains the xl folder when you try to 'extract all' from a zipped version, wonder if others also face similar issues? would be nice to see if there's any other workaround?
It still works, which suggests that you maybe have the password at the file level, which is covered in the last examle.