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.
@Up4Excel
3 жыл бұрын
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 👍
@zmilan6623
2 жыл бұрын
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!
@Up4Excel
2 жыл бұрын
Wow, thank you very much. You've made my day even better 👍
@ShirtlessRabbit4
4 жыл бұрын
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
@Up4Excel
4 жыл бұрын
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.
@terrastructeng
4 жыл бұрын
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!
@Up4Excel
4 жыл бұрын
Good stuff, that's exactly what I want to do....save people time 👍
@LlamaOates
3 жыл бұрын
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.
@Up4Excel
3 жыл бұрын
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 👍
@manishsane4564
4 жыл бұрын
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
@Up4Excel
4 жыл бұрын
Nice work! Method 3 is definitely the fail safe method. It might be a bit fiddly but always gets the job done 👍
@Duckiducki816
3 жыл бұрын
i have 30 sheets, it will take ages...
@Up4Excel
3 жыл бұрын
@@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 👍
@akshaygmukhekar3463
4 жыл бұрын
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.
@Up4Excel
4 жыл бұрын
Thanks for the feedback, glad it helped you 👍
@direguineapig1755
4 жыл бұрын
Method 2 worked! Though I'm now running into the issue where coworkers think I'm good at excel
@Up4Excel
4 жыл бұрын
Quality problem that. Watch a few more Up4Excel videos and live up to your new reputation 👍
@MR1048
3 жыл бұрын
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?!?
@tafadzwatinoona7779
4 жыл бұрын
Wow, method 3 worked for me and saved me tones of work.
@Up4Excel
4 жыл бұрын
Great to hear! My personal favourite too 👍
@carolgarrison4163
3 жыл бұрын
Tried hacking the code multiple times without success, so just finding the "password" in the code so much easier! Thanks!
@Up4Excel
3 жыл бұрын
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: kzitem.info/news/bejne/1ImMvm2ujqGoamk
@jaqueline3905
3 жыл бұрын
I tried different modes, but only this worked. Excellent!!!
@Up4Excel
3 жыл бұрын
Glad it helped
@aditya.latchireddi524
3 жыл бұрын
Method - 3 highly recommended... Thanks a lot sir... 👍👏✌️🤗
@Up4Excel
3 жыл бұрын
You're most welcome 😊 plus I agree with your recommendation, method 3 is what I default to as it always works!
@husseinahmad3406
2 жыл бұрын
I did the first method and it was done successfully... Thank you so much for sharing ❤️
@Up4Excel
2 жыл бұрын
Great to hear. It's a bit pot luck but when you find a password like this it's great 👍
@raymondhearn2586
3 жыл бұрын
An absolute life saver! Thanks so much. Method 3 did it for me.
@Up4Excel
3 жыл бұрын
Great to hear Raymond 👍
@lyamhtv5221
2 жыл бұрын
Got it! Method 3 is very much effective sir, thank you thank you so much...🙏🙏🙏 God bless you always...
@Up4Excel
2 жыл бұрын
Glad to hear it Maria, thanks for your comment 👍
@ajmarch
3 жыл бұрын
Number 3 was the rescue for me. I was testing out the security of workbook by trying random words, lo and behold i accidentally changed it to a random bunch of letters with no rhyme or reason lol. I tested it on one sheet and it worked. Just another 157 sheets to go!!! Thanks for the help dude.
@Up4Excel
3 жыл бұрын
157 sheets! If you want to save yourself a whole load of time you might want to consider the software I review in this video: kzitem.info/news/bejne/1ImMvm2ujqGoamk - INSTANTLY removes all sheet passwords from files with drag and drop 👍
@louisverheem4253
4 жыл бұрын
I did the 3rd method and worked perfectly, thank you so much for sharing!
@Up4Excel
4 жыл бұрын
You're welcome! Glad it helped you 👍
@ahmadizzat7934
3 жыл бұрын
Hi. I got a problem here. When I tried method 2, the Microsoft VBA required me to insert password for the excel file, so I can't insert the VBA Code. Can you give me suggestions on this, Sir?
@Up4Excel
3 жыл бұрын
I suggest using method 3. If not then you can remove the VBA password with software. See this other video of mine for how kzitem.info/news/bejne/1ImMvm2ujqGoamk
@nouher5613
4 жыл бұрын
Option 3 works best for me. Easy and simple to follow.
@Up4Excel
4 жыл бұрын
Great to hear! 👍
@MtnXGirl
4 жыл бұрын
Thank you so much for this...had to resort to Method 3, but it worked a treat.
@Up4Excel
4 жыл бұрын
Glad it helped. I often just go straight for method 3 if method 1 doesn't work. 👍
@qu_entin
2 жыл бұрын
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
@Up4Excel
2 жыл бұрын
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 👍
@zipperdeedooha
4 жыл бұрын
Thank you so much. This is by far the clearest explanation and worked to a T and on a Mac. Really really helpful.
@Up4Excel
4 жыл бұрын
Great to hear you liked the video so much. Thanks for your support 👍
@joedelnonan5809
4 жыл бұрын
Amazing! This is what I looking for. Method 3 works for me. Thank you very much.
@Up4Excel
4 жыл бұрын
You're welcome! Glad it helped 👍
@ArnoldWillems
3 жыл бұрын
Can you unlock the complete workbook by applying the formula in VBA to the workbook, or must you apply it sheet by sheet?
@Up4Excel
3 жыл бұрын
Hi Arnold, this is a great question as you can actually modify the code fairly easily to do the whole workbook. You do this by placing the whole code (after On Error Resume Next) inside a loop that goes to every sheet. Add the code 'For each oSheet in Activeworkbook.Sheets' before For i = 65 To 66, replace the word Activesheet with oSheet wherever it appears and add Next oSheet at the end of the code before End Sub. That should loop through the whole workbook......but be warned, it might take a long time or even crash your PC if there are too many passwords and sheets.
@TheSprCch
7 ай бұрын
Thank you! Method 2 was exactly what I needed! :)
@Up4Excel
7 ай бұрын
Great to hear! 👍 John
@rivelnzeukou7767
3 жыл бұрын
Your assistance is much appreciated! Method 3 worked for me.
@Up4Excel
3 жыл бұрын
Great to hear, glad it's working for you Rivel!
@jorgegranados1112
3 жыл бұрын
Option 3 works great for us. You save our lives. Thanks
@Up4Excel
3 жыл бұрын
Great to hear!
@prasannavenkateshparshuram9820
3 жыл бұрын
I chose the 3rd method to unprotect the sheet and it worked well. Thank you 🙏🏽@Up4Excel
@Up4Excel
3 жыл бұрын
Glad it helped 👍
@rolim92
2 жыл бұрын
Thank you so much! The vba code worked like a charm. Awesome video
@Up4Excel
2 жыл бұрын
Great to hear Pedro. Thanks for commenting 👍
@libertypingul9773
3 жыл бұрын
Man you're amazing! No. 2 worked for me. A million thanks to you!
@Up4Excel
3 жыл бұрын
Great stuff 👍 Thanks for your support
@rajeshsriharirao4265
4 жыл бұрын
cool. I used the option 2. Option 3 is long but works. Many thanks.
@Up4Excel
4 жыл бұрын
You're welcome! Option 3 is great if you need to restore the password too 👍
@xiangli3553
2 жыл бұрын
Third method worked like a charm. Thanks very much!
@Up4Excel
2 жыл бұрын
Great stuff 👍
@mjseppo
4 жыл бұрын
method 2 worked in less than a minute. Thankyou.
@Up4Excel
4 жыл бұрын
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!
@olugbengasam-okunade9988
3 жыл бұрын
@@Up4Excel could you pls send me the code for option 2?
@Up4Excel
3 жыл бұрын
@@olugbengasam-okunade9988 The full code is in the description. You can just copy and paste it 👍
@mehrannasir536
2 жыл бұрын
3rd method actually worked and it was very easy one.
@Up4Excel
2 жыл бұрын
My personal favourite too. Glad to hear it helped you Mehran 👍
@TheLbejarano49
3 жыл бұрын
Method 2 worked like a charm.. thank you very much....
@Up4Excel
3 жыл бұрын
Great to hear Luis!
@ClownXmachina
4 жыл бұрын
I just loved the 3rd part ! Worked like a charm.
@Up4Excel
4 жыл бұрын
Great to hear. Love that method too 👍
@WillardsChips
4 жыл бұрын
Thank you very much, great video!!! Method 2 did the job in a few seconds!!! Great code!!!
@Up4Excel
4 жыл бұрын
Great to hear! It's not always that quick so sounds like you got quite lucky 👍
@Laura-Ransan
3 жыл бұрын
Method 3 for the win! Thank you so much for this!
@Up4Excel
3 жыл бұрын
Glad it helped!
@brortobias8908
4 жыл бұрын
Last method was soooo easy, thanks dude! Never heard of the vba thing, that's why I went for number three
@Up4Excel
4 жыл бұрын
Great to hear! Method 3 is the way I always use myself (once I've check for a password in method 1 of course!) 👍
@Up4Excel
4 жыл бұрын
💥 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 👍
@Martand4
4 жыл бұрын
file is being damaged after converting to zip format. Its an .xlsx file
@Up4Excel
4 жыл бұрын
@@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 👍
@robinpoulose8017
4 жыл бұрын
@@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.
@robinpoulose8017
4 жыл бұрын
@@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.
@MustangHully
4 жыл бұрын
what if Alt+F11 doesnt work. how do I access the code
@josehe1978
4 жыл бұрын
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.
@Up4Excel
4 жыл бұрын
Thanks Jose, that's a great tip about free compressing programs I'll bear in mind 👍
@greensal86
3 жыл бұрын
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?
@aliciabunting8117
2 жыл бұрын
@@greensal86 Did you find a work around? I am getting the same error.
@rawconcept
2 жыл бұрын
Wow!!! Thanks boss, method 2 worked for me like magic....
@Up4Excel
2 жыл бұрын
Great stuff. Glad to hear that. Thanks for the comment too 👍
@scuzzlebutt3048
3 жыл бұрын
3rd tutorial worked you sir are a Excel guru
@Up4Excel
3 жыл бұрын
Glad to help Steve 👍
@callcanterlifemishmash5132
4 жыл бұрын
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!
@Up4Excel
4 жыл бұрын
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 🤔
@hero7593
3 жыл бұрын
@@Up4Excel i have one xl can u please unlock this. I tried all methods but not working. please help
@Up4Excel
3 жыл бұрын
@@hero7593 Have a look at this video: kzitem.info/news/bejne/1ImMvm2ujqGoamk - It might be a workbook structure password or file open password
@Up4Excel
3 жыл бұрын
👉 If this solution didn’t help, use the one from my other video at kzitem.info/news/bejne/pWeLy6Zjil9yfI4
@Woojo01
Жыл бұрын
Great! Thanks for this info. The Second method worked fine for me!😀
@Up4Excel
Жыл бұрын
Great stuff John. Happy to help 👍
@ADfamily81
3 жыл бұрын
Thank you this is an incredible hack, please keep your informative videos coming, I just subscribed :)
@Up4Excel
3 жыл бұрын
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 kzitem.info/news/bejne/222kwHVmnGppipg
@husnimoechtar
3 жыл бұрын
Method 3 worked for me. Big Thanks .
@Up4Excel
3 жыл бұрын
Glad to hear that 👍
@ceramix
4 жыл бұрын
When I do method 3 in Excel on my mac, the file is corrupt "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." I don't get why it seems to work for some people and not others, since this and similar methods have never worked on my mac. I'm testing method 2, to see if it works. Right now it's running for a few minutes on my test sheet with a simple password to see if I can try it on a more complex worksheet. Thanks for the video.
@Up4Excel
4 жыл бұрын
I don't have a Mac to test this on, but my guess is that the file system might be different for the Mac version of Excel. Method 3 relies on the fact that xlsx and xlsm files are really zip files disguised. If changing to a zip extension leaves you with a corrupt file this suggests that some container other than zip might be used for Excel Mac.
@nhaiamaravati6448
4 жыл бұрын
method 3 worked in a minute. Thank you.
@Up4Excel
4 жыл бұрын
Excellent! Good to hear 👍
@LEARjsy
3 жыл бұрын
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
@Up4Excel
3 жыл бұрын
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.
@felipesanchez4846
3 жыл бұрын
You're my hero, I had tried everything, but the last method worked. Thanks!
@Up4Excel
3 жыл бұрын
Glad I could help Felipe. Enjoy your new spreadsheet freedom 👍
@syarifahmardhiah5103
4 жыл бұрын
Method 2 is my savior. You worth a lot more subscribers!
@Up4Excel
4 жыл бұрын
Glad I could help! Thanks for your support. If I keep helping people the subscribers will come no doubt 👍
@troyds
Жыл бұрын
Great video! Method 3 works for me. Thank you so much!
@Up4Excel
Жыл бұрын
Good to hear Troy. Glad to help 👍
@DonovanBrown
2 жыл бұрын
The script worked perfectly. Thank you!
@Up4Excel
2 жыл бұрын
Great stuff, glad to hear that Donovan 👍
@samlobsang
3 жыл бұрын
Congratulations !!! Method 3 , worked !!!!
@Up4Excel
3 жыл бұрын
Glad I could help Samuel 👍
@samcoronel657
4 жыл бұрын
Method 3 worked for me! Thank you!
@Up4Excel
4 жыл бұрын
Glad it helped! I love method 3, you can put the password back and nobody even knows you cracked it 👍
@wayneedmondson1065
4 жыл бұрын
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!
@Up4Excel
4 жыл бұрын
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.
@wayneedmondson1065
4 жыл бұрын
@@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
@Up4Excel
4 жыл бұрын
@@wayneedmondson1065 Hi Wayne, I just found your comment above in some part of KZitem I didn't realise existed - apparently KZitem blocked it and I needed to over-ride that. I hope others now find it useful. Thanks for sharing.
@wayneedmondson1065
4 жыл бұрын
@@Up4Excel Thanks.. maybe it was blocked because I have a web address in my comment? Anyway.. thanks again.. Thumbs up!
@Up4Excel
4 жыл бұрын
@@wayneedmondson1065 That's exactly why apparently. I know where to look should it happen in future now though!
@TonyFordV
3 жыл бұрын
Method 3 worked perfectly. Thanks.
@Up4Excel
3 жыл бұрын
Always good to hear 👍
@Up4Excel
2 жыл бұрын
✅Reduce your working hours with my personal coaching. 👉Details at ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
@sixihili1956
Жыл бұрын
thanks sir. is there any method to know what is the password instead of just removing it and put it back?
@Up4Excel
Жыл бұрын
Method 1 in the video is the only way I know of to do that, but it's a bit of a long shot.
@yusupsupian2707
3 жыл бұрын
Hi sir. Thaks to tutorial. What if case, exel data they have free version to use... Example 2 day to acces... Can they remove?
@Up4Excel
3 жыл бұрын
I'm not sure what you mean. You can remove all the sheet passwords with the techniques in this video but for other passwords have a look at this kzitem.info/news/bejne/1ImMvm2ujqGoamk
@ParvisMASLAM
4 жыл бұрын
Thank you so much. Option 2 worked for me
@Up4Excel
4 жыл бұрын
You're welcome! Always good to know I've helped 👍
@BR-gk2jk
4 жыл бұрын
Excellent piece of work. Loved your solution. Thank you.
@Up4Excel
4 жыл бұрын
Many thanks for your feedback. Hope it helped 👍
@vibrations498
5 ай бұрын
I have a password on the entire "Workbook" which was added using File>Info>Protect Workbook>Encrypt with Password The solution which you have shared only works for the "Worksheet" Passwords Is there a way to retrieve the password for the "Workbook" When I renamed the .xlsx file to .zip and opened, it shows me 1 folder named: "[6] DataSpaces" and 2 files named: EncryptedPackage and EncryptionInfo. Can you please advise ?
@Up4Excel
5 ай бұрын
Have a look at this video kzitem.info/news/bejne/1ImMvm2ujqGoamk It explains all about removing file open passwords. John
@peterrichards883
4 жыл бұрын
awesome! - took barely a minute using method 2!!!
@Up4Excel
4 жыл бұрын
Great to hear! You either have a very fast computer or a simple password....or both 👍
@Up4Excel
3 жыл бұрын
👀 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!
@arturastutkus
3 жыл бұрын
Thank you - 3rd option helped us!
@Up4Excel
3 жыл бұрын
Great! Glad to hear that 👍
@tambolisadik
3 жыл бұрын
while extracting error no archive found help me on this
@Up4Excel
3 жыл бұрын
Make sure you check the following: You're using PC not Mac, the file is not .xls or .xlsb - if it is save as .xlsx or .xlsm. If you need a password to open the file you need this video: kzitem.info/news/bejne/1ImMvm2ujqGoamk
@dereklipka7025
4 жыл бұрын
Hi - I have an .xlsx file. It has 5 sheets, but I can only see two. The second of these two pages has the symbol of a padlock. I can edit some fields in the first page (once I enable editing), which returns a result and I can save the edited document. I have tried all three of your methods and none works - in method 3, none of the sheets have the word 'protect' in them and there is nothing (that I can see) that relates to protection / a password - do you have any suggestions?
@Up4Excel
4 жыл бұрын
This isn't what I'd expect from a xlsx file. I assume you've tried clicking Format on the Home ribbon and selecting unprotect sheet - it might simply not have a password. Failing that, some other viewer have commented that you can open the file in google sheets online and save back as xlsx to remove passwords. Unfortunately it also removes Excel only content and destroys some formatting, but it does work to remove passwords. Perhaps give that a go if all else fails.
@dereklipka7025
4 жыл бұрын
@@Up4Excel Hi - Thank you for that - It certainly has a password (trying to unprotect sheet brings up a password request). I ran another VB routine that is quite commonly quoted online and that produced a possible password of AAAAAAAAA - which did not work - this sort of approach has worked in the past (for different spreadhseets). I was able to get what I need from Google Sheets (thank you for pointing me towards that), but I am still interested in trying to get an Excel based solution - Happy to send you the file if you want to have a crack.
@Up4Excel
4 жыл бұрын
@@dereklipka7025 I'd be interested to see the file and try to work out why the methods don't work. It would be good to know what version of Excel it was created on too if possible. Email it to up4excel@gmail.com if you want. I can't promise I'll find anything but I'm just interested. Glad the Google sheets method worked for you though.
@Up4Excel
4 жыл бұрын
@Derek Lipka Good news - I've found the issue and just sent you an e-mail solution. The workbook structure was protected but method 3 has solved it 👍
@BangTons
3 жыл бұрын
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.
@Up4Excel
3 жыл бұрын
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
@billietorreno9082
4 жыл бұрын
Thank you very much. No. 3 works perfectly for me.
@Up4Excel
4 жыл бұрын
Great stuff. Number 3 is the most robust for sure 👍
@markdbohn
3 жыл бұрын
I know this is random but...where do you buy your shirts. Great looking shirt. The one you are wearing in this video.
@Up4Excel
3 жыл бұрын
It's good to have the occasional random question 😉 Most of my shirts are from TK Maxx. If you don't know it, they basically take all the end of line designer clothes and sell them off. They only have one or two of each item so it's pot luck if you see something great.
@SuperHiddenaccount
4 жыл бұрын
method 3 worked perfectly for me, thanks
@Up4Excel
4 жыл бұрын
That's what I like to hear 👍
@remitimmins350
3 жыл бұрын
options 1 and 2 do not work so trying option 3 however when I get to the "right click edit xml" it opens in word and does not show the same screen as yours. Its show a ton of centent from the page. Options?
@Up4Excel
3 жыл бұрын
Use the Windows file explorer and 'open with' rather than edit xml. That way you can use notepad as shown in the video 👍
@anegik9720
3 жыл бұрын
That was brilliant. Worked like a charm!
@Up4Excel
3 жыл бұрын
Excellent!👍
@Loxa_24
3 жыл бұрын
outstanding! I really like the 3rd method, Well played :)
@Up4Excel
3 жыл бұрын
Glad to hear that! 👍
@keyur145
3 жыл бұрын
I felt like learning Italian Job ;) Awesome
@Up4Excel
3 жыл бұрын
Great to hear that Keyur! Sounds like you had fun 👍
@rezkallahmehdi4779
5 ай бұрын
many thanks, it was very useful
@Up4Excel
5 ай бұрын
Glad to hear that! 👍 John
@sunilchetiwal
3 жыл бұрын
Great help. thanks very useful and simple to implement
@Up4Excel
3 жыл бұрын
Glad it was helpful Sunil, thanks for your feedback 👍
@kristapsrumpis6911
2 жыл бұрын
Very usefull tips! Save my day.
@Up4Excel
2 жыл бұрын
Good to hear I saved your day 👍
@dariuskotze7552
2 жыл бұрын
Liking and subscribing. You're a legend. Thanks mate.
@Up4Excel
2 жыл бұрын
Thanks for the sub Darius. Glad to help 👍
@py2396
9 ай бұрын
Thank you so much! Your methods worked wonders!
@Up4Excel
9 ай бұрын
Great to hear that 👍 John
@kaantuncyildiz2937
3 жыл бұрын
Thank you Mr. it really worked very well.
@Up4Excel
3 жыл бұрын
Great to hear!
@BomboclatYT
4 жыл бұрын
No need for all these, just open the file using google sheets and all the vb code will be bi-passed then re save back to excel - done!
@Up4Excel
4 жыл бұрын
I've just tested this and it does indeed remove the password from the sheets! 😀 However, it also messes up a lot of the formats and removes other things, like hyperlinks, so best to stick to using it for simple spreadsheets. Thanks for the great hacking tip 👍
@kanye8409
4 жыл бұрын
thank you so much you saved my time
@SiddiquiAnas
4 жыл бұрын
It does not work brother. It still asks for password for view/edit. Any help?
@Martand4
4 жыл бұрын
What should I do if my file itself is protected?
@vebe7109
3 жыл бұрын
Thank you!!!!
@lancevladimirm.franco4793
3 жыл бұрын
hello, how about how to recover password of the excel file. thanks
@Up4Excel
3 жыл бұрын
I'm currently testing some software that will do this cutt.ly/AccentEXCEL . I'll do a full review in due course but it definitely does the job.... quickly for simple passwords but be prepared to leave your computer on a while if you have a complex password. They have a few other products for password recovery too.
@muhammednizam7759
4 жыл бұрын
Can i see the functions after we unlock the protected sheet as u said
@Up4Excel
4 жыл бұрын
✅ Yes, should be able to provided there is no extra password on the VBA Project 👍
@LamaNorbou
3 жыл бұрын
Thanks, I think I won't use passwords anymore, obviously there's no point :-) I chose the VBA method, it took about a second.
@Up4Excel
3 жыл бұрын
I agree they're easy to break, but I'm not sure there's no point. They still act as a bit of a barrier as most people don't have this knowledge on how to break them or just can't be bothered 👍
@manuelafehlies3950
4 жыл бұрын
This is bloody brilliant!! Thank you so much!!
@Up4Excel
4 жыл бұрын
You're very welcome indeed 👍
@ash_fahim
4 жыл бұрын
Thank you sir. It worked .
@Up4Excel
4 жыл бұрын
Glad to hear it helped you 👍
@GeorgeAJululian
3 жыл бұрын
Thanks very helpful
@Up4Excel
3 жыл бұрын
Glad to hear that George!
@MaRiPi
4 жыл бұрын
This worked, thank you so much!
@Up4Excel
4 жыл бұрын
Glad you found it helpful 👍
@AryaBuePratamaSibuea
Жыл бұрын
its really helping. thanks
@Up4Excel
Жыл бұрын
Great to hear that. Thanks for commenting 👍
@Murgablodazor69
2 жыл бұрын
Hey, just wondering, is there something I need to change in order to open the zip file in the 3rd method with file explorer, because I cant do it. Thanks
@Up4Excel
2 жыл бұрын
Should be just as per the video if you're using a windows PC with an xlsx or xlsm file. If either of those things are different then you might need another method in the video.
@Albertussigit97
4 жыл бұрын
Yeaaaaaaaaaaaayyyyyyyyyyyyyyyyyyyyy The step 3 worked perfectly! Thank you.
@Up4Excel
4 жыл бұрын
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 👍
@danahveitenthal8200
2 жыл бұрын
If someone sent me an excel sheet that is protected - and I saved as (my file) if I try to unprotect it will it also unprotect the original spreadsheet? I'm trying to copy a calendar format for my work for my personal use, they won't send me an unprotected version for some reason
@Up4Excel
2 жыл бұрын
It won't unprotect the original as that is a separate file. Only your copy will be unprotected.
@danahveitenthal8200
2 жыл бұрын
@@Up4Excel thank you
@razakshareef3763
3 жыл бұрын
Thanks Champ Worked well on Thrid Trick Thank You
@Up4Excel
3 жыл бұрын
Great to hear 👍
@iamhiscore
3 жыл бұрын
Amazing Hacks, buddy. You are great. Thanks for share.
@Up4Excel
3 жыл бұрын
Glad you like them 👍
@rudraswamy.c.tswamy822
2 жыл бұрын
hai, anyhow still the works book sheet is not opening after doing all the inputs given by you. please suggest
@Up4Excel
2 жыл бұрын
If you can't open the workbook then look at my passwords software video: kzitem.info/news/bejne/1ImMvm2ujqGoamk
@nousherahmed463
3 жыл бұрын
I was trying to follow the zip extension method.. When I open the folder named "worksheets", all my worksheets are listed with bin extensions instead of xml extensions. Apart from this problem, three more files and one extra folder are found. sheet1, sheet2 and sheet3 are with bin extensions. BinaryIndex1, BinaryIndex2 and BinaryIndex3 - three more files also appear along with an folder named _rels. If I could attach a screenshot, it would be easier. How can I solve the bin extensions issue?
@Up4Excel
3 жыл бұрын
your file is saved as an xlsb file (Excel Binary File). Re-save it as an xlsx file and you should be good to go with the zip method 👍
Пікірлер: 616