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 👍😊
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. 👍
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)
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
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.
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, 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?
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 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
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.
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.
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!
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.
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.
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 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.
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.
@@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.
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.
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?
@@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
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.
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?
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
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?
Why I can drill down into the folders on the ZIP file once is converted? When I open it with 7-zip Windows app and show me different folders: MsoDataStore [6]Data Spaces EncryptedPackage [5]Document Summarylnformation [5]SummaryInformation No one of these folders have the xl folder with Worksheets folder, with the Sheet.xml file Thanks for your comments.
❓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!
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 ?
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!
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 😊
Wonderful tips! Its kinda suffering when I forgot the password that I have set. Thank you! Incredible video ever!
Glad you liked it 🙏
Such a simple video to follow but it saved me so much work! Thank you!
Awesome to hear 😊
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)
👍
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 🙏
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.
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 for this resource! saved me a few hours of recreating a sales document.
Glad I could help!
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!
"luckily" it is that easy... just succesfully removed one - thanks Mynda
Glad it helped!
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.
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!
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 🤔
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.
Thank u for this video 📹. How did u open the XML in one note ?
I'm using Notepad ++, not OneNote.
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.
Hi Mynda!Super Helpful And Clear Explanations...Thank You :)
Great to hear, Darryl!
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/
Wow, its really great to find this video that makes me back to my work. Thank you.
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/
Worked a treat - THANK YOU!
Awesome 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. 👍
Thank you I managed to use it for one of my old file I forgot password. User friendly
Glad it helped!
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
God bless you Madam. A life saver
Glad it was helpful!
Thank you, it was very helpful and saved me a lot of time.
Great to hear!
Saved my day. Thank you very much.
You're welcome! Glad I could help.
You're genius. It works!
Glad it helped 😊
As always, great tips! Thanks a lot, Mynda 🙂
Glad you like them! 🙏
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.
Nice tip, cheers, Ivan!
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.
Thank you for the video, able to unprotect the excel sheet. Better than Chatgpt at the moment😂
😁 glad I could help!
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.
It was a life saver. Thank you!
Glad I could help!
Superb Mynda, explained very clearly.... Thanks a lot ❤
Glad you liked it
very helptull video, thanks a lot mam, take ❤
Most welcome 😊
You actually can unzip protected file, open worksheets and some info is visible but most is encrypted.
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
Thanks Mynda for the information.
You are so welcome!
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.
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.
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!
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.
Wow Mynda! Nice usefull tips! Thanks a lot!
You're so welcome!
V. first trick worked. Thank you for making life easier.
Great to hear!
I've tried various solutions on StackOverflow but this was the only one that worked!
So pleased I could help 😊
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.
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 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
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.
AMAZING! You saved me a great deal! Thank you, subscribing!
So pleased I could help!
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.
You are the best! I follow you since a year ago and I find your tutorials very helpful. Thanks :)
Awesome to hear, thank you!
Super helpful video. Thanks a million for sharing, Mynda.
You are so welcome, Ekki!
Amazing tips!
Glad you think so!
Thank you for the tutorial
You’re welcome 😊
Saved me hours. Thankyou
Glad I could help!
Thank you so much, it worked!!!
Glad it helped!
incredibly helpful
Great to hear 🙏
Excellent stuff Mynda
Thank you!
It is working, bunch of thanks :)
Welcome 👍
Thank you so much for the wonderful information. I am able to crack the password. Protected to Un-Protected
Glad I could help 😊
Wonderful technique
Thank you!
Thank you very much your guidance. keep it up.
Thank you, I will 😊
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.
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.
This is brilliant!! Thank you!!
Glad you liked it!
Drilldown on what folders. Poof its not working for me after I changed to a zip file
Sounds like you have a password at the file level as covered in the last example.
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
You absolute legend.❤
Glad I could help 😊
Excellent as always! Thank you!
Thanks so much, Bob!
Is there a similar process for Word documents?
Not that I know of, sorry.
Super helpful, thanks Mynda!
Cheers, Chris!
Very helpful. Thank you
Great to hear!
What a great tip!
Glad you think so!
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.
Big thank you !
You're welcome!
thank you so much for the help.
You're welcome!
Thank you very much,really amazing 😍
I'm glad you liked it 🙏
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.
Thank you for your helping
My pleasure!
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.
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
I am doing anything i can do recover my password. Does this work for Mac? Thanks in advance!
Not sure about a Mac, sorry.
Great video and well explained. Thank you.
Glad you enjoyed it!
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.
Thank you for your video. It’s interesting.
My pleasure 👍
Very nice info, thank you for sharing.
Glad it was helpful!
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
Why I can drill down into the folders on the ZIP file once is converted?
When I open it with 7-zip Windows app and show me different folders:
MsoDataStore
[6]Data Spaces
EncryptedPackage
[5]Document Summarylnformation
[5]SummaryInformation
No one of these folders have the xl folder with Worksheets folder, with the Sheet.xml file
Thanks for your comments.
Not sure, Javier. Try just using the built in zip functionality in Windows as you saw me do.
This is because the entire workbook is password protected rather than just a sheet. I doubt you can crack that password.
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.
Amazing. thank you.
Glad it was helpful!
Very helpful tutorial... Good.
Glad you think so!