ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- 👀 CAN'T OPEN YOUR FILE ?? Try This: »» cutt.ly/ExcelPassFind
🎯 Remove Excel sheet protection and add it back again.....all without even knowing the password. In this video I'll show you 3 ways to crack password protection on Excel sheets and re-protect them afterwards.
✅ Download Practice Workbook: »» cutt.ly/up4v1917MFD
🔓 Remove Excel File Open Passwords: »» cutt.ly/AccentEXCEL
🔑 Remove Excel File Open Passwords FASTER: »» cutt.ly/AccentOFFICE
🌐 Remove Excel 97-2003 File Open Passwords: »» accessback.com
1 File Credit: cutt.ly/AccessBack1
5 File Credit: cutt.ly/AccessBack5
======================================================================================
🕑 Video Timings and Methods Used:
00:00 Overview of Methods
00:50 Method 1: Get Lucky - find it within existing VBA code
02:50 Method 2: Remove with a VBA macro - can't restore the password after
06:44 Method 3: Hack the File Code - Fastest and most likely to work, but most advanced
======================================================================================
You will learn how to unprotect an Excel sheet without knowing the password in 3 different ways with this video. You can remove an Excel password without software as long as the file is not encrypted. Learning how to unprotect an Excel sheet can be as straight forward as using the toolbar command to unlock protected Excel sheets without passwords. If there is a password, you will want an Excel password remover- without any application - in order to crack Excel sheets. I will show you 3 ways how to unprotect Excel sheets without the password and thereby remove Excel password protection. When you see how to unlock protected Excel sheets without the password you can regain control of spreadsheets with forgotten Excel passwords. You do not need an Excel password cracker to unprotect Excel cells without the password, because when you remove Excel protection without software you will unlock the Excel spreadsheet, unprotect the sheet in Excel and unlock cells all at once.
I show you how to unprotect excel sheets in 3 ways. It's the same as having an excel password remover- without any application. Yes, remove excel password without software and unprotect sheet. When you know how to unprotect excel sheet without knowing password you can crack excel sheets, remove excel protection without software, and unlock protected excel sheets without password. This video shows how to unprotect excel sheet in windows 10 but works exactly the same in all versions of windows. Unlock your excel spreadsheet now with this video showing how to unprotect excel sheet without password.
======================================================================================
VBA Code to Unprotect in Method 2 (If you need to restore the password use Method 3)
Code contained in practice workbook module 1: cutt.ly/up4v1917MFD
Code not written by myself so use at your own risk. I have simply broken out onto separate lines to allow it to be run one loop at a time with stop breaks to avoid machine lockups.
Sub sbRemoveSheetPassword()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
For l = 65 To 66
For m = 65 To 66
For i1 = 65 To 66
For i2 = 65 To 66
For i3 = 65 To 66
For i4 = 65 To 66
For i5 = 65 To 66
For i6 = 65 To 66
For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "Complete"
Exit Sub
End If
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
End Sub
======================================================================================
#Up4Excel
#Up4ExcelAdvanced
#Up4ExcelTips
Here at Up4Excel we’re on a mission to help YOU:
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾
======================================================================================
✅ Download Practice Workbook: »» cutt.ly/up4v1917MFD
🎁 Your small gift will help me make better videos for you and others.
Thank You: www.paypal.me/Up4Excel?locale...
I had a couple very useful files that I wrote back in 2013 and could not remember some parameters. You saved me like a day of work. Thanks!
Good stuff, that's exactly what I want to do....save people time 👍
Thank you so much. This is by far the clearest explanation and worked to a T and on a Mac. Really really helpful.
Great to hear you liked the video so much. Thanks for your support 👍
Method 2 worked for me in less than a minute. Stupid financial course i am doing protected the the sheet to hide their formala's, but annoyingly I wanted to build on it and make some edits of my own. Good video, nice and clear and easy to understand.
Glad it helped! It can be really annoying when people password protect sheets unnecessarily - it's great to know how to get rid of it 👍
Amazing!
This is what I looking for.
Method 3 works for me.
Thank you very much.
You're welcome! Glad it helped 👍
Great tips! Another note for others to keep in mind: these methods will not work on an xlsb file where the internal files are encoded in binary as opposed to XML. This is also a good way for others to produce a spreadsheet that is protected from these methods
Thanks for sharing that tip 👍. It is certainly true they don't work on xlsb files. The work around for this though, is to save the file as xlsx, perform the hack, and then re-save as xlsb. Probably the only way to completely prevent any of these methods working is to add a file open password so that the file is encrypted.
I did the 3rd method and worked perfectly, thank you so much for sharing!
You're welcome! Glad it helped you 👍
An absolute life saver! Thanks so much. Method 3 did it for me.
Great to hear Raymond 👍
I just loved the 3rd part ! Worked like a charm.
Great to hear. Love that method too 👍
I chose the 3rd method to unprotect the sheet and it worked well. Thank you 🙏🏽@Up4Excel
Glad it helped 👍
Thank you so much for this...had to resort to Method 3, but it worked a treat.
Glad it helped. I often just go straight for method 3 if method 1 doesn't work. 👍
method 2 worked in less than a minute. Thankyou.
Glad it helped that quickly. The time taken seems a bit random as took hours for one of my tests and about a minute or so for the other!
@@Up4Excel could you pls send me the code for option 2?
@@olugbengasam-okunade9988 The full code is in the description. You can just copy and paste it 👍
Man you're amazing! No. 2 worked for me. A million thanks to you!
Great stuff 👍 Thanks for your support
👀 CAN'T OPEN YOUR FILE ?? Try This: »» cutt.ly/ExcelPassFind
👉 NEW: Up4Excel Downloads Library: »» ml.up4excel.com/library ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
I wanted to disburse salary in bulk to our company employees. But my bank provided a protected sheet to upload the details, which was very very difficult to operate. Few cells were locked unnecessarily. Could not move or make any changes to a particular row. I already complained to the bank. But nothing happened. Your method 3 solution worked like a charm and saved me from repeat frustration I was going through for past couple of years. Now I am super excited. Why did I not look up your video earlier!!
Thank you so much.
Really pleased to hear this. This is exactly why I started my channel, to help people save time and avoid frustrations like you had. Happy to help 👍
Method - 3 highly recommended... Thanks a lot sir... 👍👏✌️🤗
You're most welcome 😊 plus I agree with your recommendation, method 3 is what I default to as it always works!
Option 3 works best for me. Easy and simple to follow.
Great to hear! 👍
I did the first method and it was done successfully... Thank you so much for sharing ❤️
Great to hear. It's a bit pot luck but when you find a password like this it's great 👍
💥 Remove Excel sheet protection and add it back again.....all without even knowing the password. I'll show you 3 ways to crack password protection on Excel sheets so you can save time and get your work done faster ✅ If I saved your precious time you can support this channel at www.paypal.com/paypalme/Up4Excel?locale.x=en_GB. Thank you 👍
file is being damaged after converting to zip format. Its an .xlsx file
@@Martand4 You might be dealing with an encrypted file - they need a password to open the file itself. If you know this password, open the file and save without a password using the 'save as' settings. If you don't know the file open password you will need to use third party software to crack the file. There are a few comments on here already about which software you can use so have a look through some of the other comments. Good luck 👍
@@Up4Excel
If I decompress an xlsx file into a folder and then I recompress it again, the xlsx becomes corrupt / not recognized. In my case, the cause is that my zip tool is using the folder name as the first level for the relative path of each file inside the zip.
I have solved the problem by creating an empty zip file INSIDE the folder with the xlsx contents and then adding all the files and folders to it.
Actually, if you try to zip the folder itself, the file is not a valid xlsx. You should rather go inside the folder, select all the contents and then right-click & zip.
@@Martand4
If I decompress an xlsx file into a folder and then I recompress it again, the xlsx becomes corrupt / not recognized. In my case, the cause is that my zip tool is using the folder name as the first level for the relative path of each file inside the zip.
I have solved the problem by creating an empty zip file INSIDE the folder with the xlsx contents and then adding all the files and folders to it.
Actually, if you try to zip the folder itself, the file is not a valid xlsx. You should rather go inside the folder, select all the contents and then right-click & zip.
what if Alt+F11 doesnt work. how do I access the code
You're awesome! Tried the steps using other videos for xlsm and yours is the only one that worked! Method 3 is nice by the way. Thank you!
Great stuff 👍. I always use method 3 on my own stuff and never failed me yet! Perhaps I should just remember my own passwords though 🤔
@@Up4Excel i have one xl can u please unlock this. I tried all methods but not working. please help
@@hero7593 Have a look at this video: th-cam.com/video/sSVX9xUow74/w-d-xo.html
- It might be a workbook structure password or file open password
Method 3 for the win! Thank you so much for this!
Glad it helped!
Thank you very much, great video!!! Method 2 did the job in a few seconds!!! Great code!!!
Great to hear! It's not always that quick so sounds like you got quite lucky 👍
I tried different modes, but only this worked.
Excellent!!!
Glad it helped
DAAAAAAAMMMMNNNNN you're a beast!!!! feels great!
Nothing better than a good hack !
Method 2 I tried for whole of night but didn't complete- so chose 3rd solution and wola great! Had 5 sheets with protection. So dis this 5 times and then merged those individual sheets back into a new file. Thanks a ton
Nice work! Method 3 is definitely the fail safe method. It might be a bit fiddly but always gets the job done 👍
i have 30 sheets, it will take ages...
@@Duckiducki816 Have a look at this software cutt.ly/AccentEXCEL
. I've just reviewed it and have a video coming out in a couple of weeks but it removes all sheet passwords instantly with drag and drop the file. Might be worth the investment based on time saved 👍
👉 If this solution didn’t help, use the one from my other video at th-cam.com/video/D1Uer-Q-AIY/w-d-xo.html
Wow, method 3 worked for me and saved me tones of work.
Great to hear! My personal favourite too 👍
Thank you SIR,
Your just amazing, I was searching to remove xls file protection from 2 days read several articles and go through vedios also but i will not succeed suddenly i found your video try first method doesn't work and used second method and its works.
Thanks for the feedback, glad it helped you 👍
This is bloody brilliant!! Thank you so much!!
You're very welcome indeed 👍
cool. I used the option 2. Option 3 is long but works. Many thanks.
You're welcome! Option 3 is great if you need to restore the password too 👍
Excellent piece of work. Loved your solution. Thank you.
Many thanks for your feedback. Hope it helped 👍
Last method was soooo easy, thanks dude! Never heard of the vba thing, that's why I went for number three
Great to hear! Method 3 is the way I always use myself (once I've check for a password in method 1 of course!) 👍
outstanding! I really like the 3rd method, Well played :)
Glad to hear that! 👍
Thank you very much. No. 3 works perfectly for me.
Great stuff. Number 3 is the most robust for sure 👍
Tried hacking the code multiple times without success, so just finding the "password" in the code so much easier! Thanks!
Great to hear! It's a massive bonus when that happens 👍 If you get stuck or can't find it in the macro then it's worth having a look at some software I reviewed in this video - removes all internal passwords instantly: th-cam.com/video/sSVX9xUow74/w-d-xo.html
Thank you this is an incredible hack, please keep your informative videos coming, I just subscribed :)
Thank you! I certainly will keep the videos coming 👍 I personally like the hack on my last video to prevent people opening a spreadsheet unless they enable macros th-cam.com/video/z7nZA0c88Wc/w-d-xo.html
That was brilliant. Worked like a charm!
Excellent!👍
This worked, thank you so much!
Glad you found it helpful 👍
Your assistance is much appreciated! Method 3 worked for me.
Great to hear, glad it's working for you Rivel!
Option 3 works great for us. You save our lives. Thanks
Great to hear!
I know this is a small reward for your work and effort in putting these videos together. I wanted to thank you and at least buy you a coffee.
Best!
Wow, thank you very much. You've made my day even better 👍
Method 3 worked for me! Thank you!
Glad it helped! I love method 3, you can put the password back and nobody even knows you cracked it 👍
Got it! Method 3 is very much effective sir, thank you thank you so much...🙏🙏🙏 God bless you always...
Glad to hear it Maria, thanks for your comment 👍
Method 2 is my savior. You worth a lot more subscribers!
Glad I could help! Thanks for your support. If I keep helping people the subscribers will come no doubt 👍
awesome! - took barely a minute using method 2!!!
Great to hear! You either have a very fast computer or a simple password....or both 👍
Yeaaaaaaaaaaaayyyyyyyyyyyyyyyyyyyyy The step 3 worked perfectly! Thank you.
Great stuff, method 3 is my personal favourite. I love the way you can put the password back too and nobody even knows you hacked it 👍
Third method worked like a charm. Thanks very much!
Great stuff 👍
Method 2 worked! Though I'm now running into the issue where coworkers think I'm good at excel
Quality problem that. Watch a few more Up4Excel videos and live up to your new reputation 👍
Is it supposed to take so long? It would seem to make more sense to go back and stop the run on the lines you’ve already run…then just go to lines you haven’t run and run them with others stopped. Or am I a very confused man?!?
Thank you so much. Option 2 worked for me
You're welcome! Always good to know I've helped 👍
This was very helpful thank you so much :D
No problem 👍
Awesome. Thank´s a lot for the 3rd tip. Just a advice, some free compressing programs do not write it correctly when compacting the file again, causing the file to be "corrupt". The best way it´s to use Windows native compressing tool.
Thanks Jose, that's a great tip about free compressing programs I'll bear in mind 👍
Hello,
I am actually getting the same issue. I am using WinZip to compress the file. One I remove the content protect line from the wordpad, change the document back to .xlsx type, and open the file, I get either the file is corrupted or the sheets themselves are empty. As if the content was cleared. Have you guys dealt with something like this before?
@@greensal86 Did you find a work around? I am getting the same error.
Great help. thanks very useful and simple to implement
Glad it was helpful Sunil, thanks for your feedback 👍
Thank you - 3rd option helped us!
Great! Glad to hear that 👍
method two is magic, thank you for the help!
Great stuff, glad it helped Ivan 👍
@@Up4Excel I'm late to this party... but I'm trying to figure out how the code actually works. I get that it is essentially trying a password, changing the letters, trying the next one etc.
The confusion I'm having is the password is fixed at 12 characters long, the first 11 of which are either an "A" or a "B". The 12th character cycles through uppercase, lowercase, numbers and symbols.
How then will it crack a password such as "password" - which is 8 characters long and clearly the first characters aren't capital A or B?
@@antonrast6358 All I know Anton is that it is using the password hash rather than the actual password. I didn't write the code, just adapted it, so you might need to do a bit of a search.
Thank you so much! The vba code worked like a charm. Awesome video
Great to hear Pedro. Thanks for commenting 👍
method 3 worked in a minute. Thank you.
Excellent! Good to hear 👍
you really deserve this like. Awesome!!!!
Thank you so much 😀Great to hear!!
Thank you! Method 2 was exactly what I needed! :)
Great to hear! 👍 John
Method 2 worked like a charm.. thank you very much....
Great to hear Luis!
Method 3 worked for me. Big Thanks .
Glad to hear that 👍
Wow!!! Thanks boss, method 2 worked for me like magic....
Great stuff. Glad to hear that. Thanks for the comment too 👍
The script worked perfectly. Thank you!
Great stuff, glad to hear that Donovan 👍
Great video! Method 3 works for me. Thank you so much!
Good to hear Troy. Glad to help 👍
Method 3 worked perfectly. Thanks.
Always good to hear 👍
well holy shit. thank you :) Liked the video. Appreciate it!
That's what I like to hear 👍
Hi.. love this.. especially method #1 which had not occurred to me previously and method #3 which I tried and it worked just as you demonstrated. Excellent! Is there anything similar that works at the workbook level? My guess is not.. but worth asking. Thanks for sharing these great tips. Thumbs up!
Hi Wayne, you can remove workbook structure protection using method 3 on the workbook.xml file within the zip package. File open passwords are encrypted so much more tricky.....not sure how to do it myself but my guess is it will require decryption software of some sort. Glad the video was useful.
@@Up4Excel Hi.. thanks.. I tried the procedure with both worksheet and workbook protection and it worked perfectly. For Workbook Open protected sheets, I did some Internet research and basically you need a brute force cracking program to do the job if the password is set on opening the workbook. I found this site: www.isunshare.com/excel-password-genius/ which looks pretty professional and reliable. $20 for the basic version seems pretty reasonable. I don't know that I will have very many instances of needing such a tool, but it is nice to know it is out there. So.. thought I would share it with you and your site. Thanks again for getting me interested in this topic. Always nice to have a solution when a client comes calling. Thumbs up!
PS - Here is a link I just found to 15 possible EXCEL open workbook PW cracking tools: www.passfab.com/excel/excel-password-recovery.html
@@wayneedmondson1065 Hi Wayne, I just found your comment above in some part of TH-cam I didn't realise existed - apparently TH-cam blocked it and I needed to over-ride that. I hope others now find it useful. Thanks for sharing.
@@Up4Excel Thanks.. maybe it was blocked because I have a web address in my comment? Anyway.. thanks again.. Thumbs up!
@@wayneedmondson1065 That's exactly why apparently. I know where to look should it happen in future now though!
It worked very well! Many Thanks! :)
Glad to hear that!
method 3 worked perfectly for me, thanks
That's what I like to hear 👍
Thank you Mr. it really worked very well.
Great to hear!
Great! Thanks for this info. The Second method worked fine for me!😀
Great stuff John. Happy to help 👍
Thank you, method 3 was what I was looking for. Tried with Wordpad before but failed (read-only and no idea how to get rid of it) .. Notepad worked somehow
Notepad is the toll for this kind of stuff for sure....doesn't try and mess with formatting or anything like Wordpad or other text editors might. Glad you got there, Thanks for the comment 👍
This is awesome !
Good stuff, thanks for the feedback 👍
✅Reduce your working hours with my personal coaching. 👉Details at ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
Liking and subscribing. You're a legend. Thanks mate.
Thanks for the sub Darius. Glad to help 👍
Thanks Champ Worked well on Thrid Trick Thank You
Great to hear 👍
That was very helpful thank you 🙏
You’re welcome Junaid 👍
Nice guidance.. love it.
Glad it was helpful! I've got a video on cracking file open passwords coming out on 28th October so look out for that too 👍
Worked perfectly, thanks
You're welcome Rodrigo 👍
Thank you so so so so so so much!!
You're so welcome!👍
Amazing Hacks, buddy. You are great. Thanks for share.
Glad you like them 👍
Thank you so much!
Glad it helped!
Very usefull tips! Save my day.
Good to hear I saved your day 👍
Congratulations !!! Method 3 , worked !!!!
Glad I could help Samuel 👍
Thank you sir. It worked .
Glad to hear it helped you 👍
u r GENIUS sir...!
Genius taking it a bit far I reckon 😀 ...but I'll take it this once 👍
Thank you so much! Your methods worked wonders!
Great to hear that 👍 John
Sir, you're excellent!!
Well thank you 👍
3rd tutorial worked you sir are a Excel guru
Glad to help Steve 👍
I felt like learning Italian Job ;) Awesome
Great to hear that Keyur! Sounds like you had fun 👍
i like and subscribe because it work. Thanks
Good stuff, thanks for the sub and glad it works
Thank you sir!
You are welcome Roberta! Hope the video helped you 👍
Superb !
Thank you! Cheers Jason 👍
YOU'RE DA MPV!!!! THE THIRD WORKS FOR ME
Great stuff, glad to help 👍
Hey there! It was a grt and very helpful, but can you also make a video to crack a password of encrypted workbook??
Hi Javed, method 3 can be used to remove workbook structure protection, but as far as I am aware, you need to use external software to crack an encrypted workbook (i.e. file level password protection). I don't know how to do this at present, but if I learn I will make a video 👍
Ya please do make a video if you get the solution, Many Thanks
@@javedali4674 I certainly will.
See comment from Wayne Edmondson
who suggests looking at this site to crack an encrypted workbook www.isunshare.com/excel-password-genius/
Thanks for method 2 it works you are great!
Good to hear 👍
@@Up4Excel Can you remove encrypt password excel. no sheet? Thanks!
@@daly6368 You will most likely need extra software to do this. Have a look at some of the other comments on this video as a few mention software that can do this job.
@@Up4Excel can not encrypt password excel can help me?
@@daly6368 Another viewer suggested www.isunshare.com/excel-password-genius/
what software do you use (time 07:12 ) to bring up keyboard shortcuts in your videos? Please answer and I want to use it on windows 7 64bit.
I use camtasia to record the screen and in it there is an option to show keystrokes - and numerous options of how to show them too
many thanks, it was very useful
Glad to hear that! 👍 John
3rd method actually worked and it was very easy one.
My personal favourite too. Glad to hear it helped you Mehran 👍
THanks mate!
You're welcome! 👍
3rd method works for me. great
Great stuff!
Hi, trying to use your method 3, but notepad is not finding 'protect' in the .xml file? Any suggestions? (Incidentally, I noticed my zip folder contained an additional 'customXml' folder that yours didn't seem to in the video... Thanks in advance
Try searching the workbook.xml file. It might be workbook structure protection that's been used. As for additional folders, my example was a very simple spreadsheet so in the real world there will usually be more folders anyway.