🔓 Unprotect Excel Sheets in Seconds (When You Don't have the Password)

Рет қаралды 64,169

27 күн бұрын

In this video, I will show you a simple way to unprotect worksheets in any Excel file without the need for any software or website.
It's pretty easy and takes less than a minute.
Download the example file - www.dropbox.com/scl/fi/1zvawx...
Read the article here - trumpexcel.com/unprotect-exce...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 128

@IvanCortinas_ES 25 күн бұрын

Thanks for the tutorial. You can also keep the code, without having to delete it, and change the numbers 1 to 0 (turning off the password) in the section: sheet = "1" by sheet = "0" objects="1" by objects="0" scenarios ="1" by scenarios ="0" Thanks Sumit!

@trumpexcel 25 күн бұрын

Thanks for the tip Iván 👍

@c.o.d.y.langton 25 күн бұрын

It's been ages since I learned something novel about Excel. Thank you.

@claudegiguere8731 Күн бұрын

Very glad to know this! Thanks Sumit 👍👍👍

@Turbonuts78 25 күн бұрын

Fantastic as always. Thanks a bunch!!

@skipbechtold3735 15 күн бұрын

You’re a genius. This came at the perfect time. Thank you.

@raotouqeerahmad7594 24 күн бұрын

Awesome. Thank you.

@MisiuPO 13 күн бұрын

Its good to hear this still exists as I have been using it for 8 years and wondered if they ever going to plug it :) it actually helped me gain a lot of respect in the company.

@michelbaudoinca 25 күн бұрын

Great trick ! Thx Sumit !!!

@bhaskaryenagandula8712 25 күн бұрын

Amazing one Sumit. Thanks for sharing.

@serdip 25 күн бұрын

Absolutely BRILLIANT! Thanks for sharing!

@trumpexcel 25 күн бұрын

Glad you found the video helpful 🙂

@WekomVideos 25 күн бұрын

Genius, thank you Sumit!

@subhraghosh4050 24 күн бұрын

Many thanks for sharing

@evfusion4094 19 күн бұрын

Clever yet quite simple (when you know how). Thank you.

@jpblauvelt 15 күн бұрын

Excellent information. I’m now a subscriber ❤

@ashroff17 25 күн бұрын

Thank you very much!

@behramcooper3691 19 күн бұрын

Very interesting. Thank you.

@lorenakademar5267 17 күн бұрын

Thank you a lot! great tip!!

@19peris87 24 күн бұрын

Great Work! Thanks Summit!!!!!

@BytebroUK 17 күн бұрын

Very useful, thanks!

@ranjan4495 25 күн бұрын

I don't need to listen to the content to give a like, I have been following trump excel for years now, the content quality is such great that giving a like at the end is like playing devil's advocate. Thankyou for all your qualitative content.

@trumpexcel 25 күн бұрын

🤗

@cornelbejenaru3523 20 күн бұрын

Wow! Amazing! Thanks a lot!

@Froschkoenig751 15 күн бұрын

Nice, easily convinced to subscribe after watching one video by you!

@piyushrvyas 24 күн бұрын

Thanks a lot. That was a great tool

@GoodlyChandeep 25 күн бұрын

Excellent Production Summit!

@trumpexcel 24 күн бұрын

Thanks Chandeep.. Good to see you in the comments section 🙂

@Navneetsingh-ud2ru 25 күн бұрын

Simply WOW 😲

@sanjayshrestha3013 22 күн бұрын

Thank u it’s finally done

@ym10up 9 күн бұрын

Cool. I use to unlock sheets by running a macro but I've since lost that code. Good to have a backup method. Thank you

@sumardjo 15 күн бұрын

Wuiiii Genius trik thanks for sample file I can follow your video thanks very much!!!

@sanjayshrestha3013 25 күн бұрын

Great tips I will try mine too and let you know the result

@JAG.65 9 күн бұрын

thank you!

@nononsense129 22 күн бұрын

HI Sumit, is there any way to open a password protected Excel file?

@jhankhanajani9314 17 күн бұрын

Thank you Sumit for showing this trick !!!, Bit surprise, with this trick, suddenly felt like, no data is secure. However your explanation is pretty clear. Thank you.

@dominiquecolin4716 16 күн бұрын

Great video. Thanks a lot

@trumpexcel 15 күн бұрын

Glad you found the video helpful 🙂

@StevenBrener 16 күн бұрын

good stuff!

@ANILKUMAR-cj4mi 24 күн бұрын

excellent

@ajitbarik4071 11 күн бұрын

Wow Really 👌

@chrispascual1188 13 күн бұрын

Brilliant tutorial!!! But, does this also work on word, ppt etc.?

@pabeader1941 21 күн бұрын

Nice one. Can you also do it for protected VBA code?

@gaurav4uk 12 күн бұрын

Good

@CalinSabau 14 күн бұрын

That's cool 😎

@raffibarsoumian1075 25 күн бұрын

Sneaky but it works:)

@amirkeren8386 12 күн бұрын

Any similar method for Word documents?

@MichaelToub 12 күн бұрын

Wow!

@markstewart7559 15 күн бұрын

This is a really useful video, thank you. I am curious why you need to make a copy of the .xml file and take it outside the main folder to edit it when you’ve already made a copy of the whole file?

@trumpexcel 14 күн бұрын

I made a copy and placed the XML file outside the ZIP folder, as within the ZIP folder, it doesn't allow me to open the file in Notepad or Wordpad.

@jowiepoet9972 14 күн бұрын

Does this work for encrypted VBA too? (Xlsm with a protected VBA script)

@qwertyui2827 14 күн бұрын

Very nice. Well done. Is it the same procedure when the file is password protected to open ?

@trumpexcel 14 күн бұрын

It works only when you have the worksheets that are protected. Won't work when the entire file is locked or the VBA project is locked

@andysingh905 25 күн бұрын

How to open a password protected file, if you forgot the password?

@pilotpawanc 19 күн бұрын

Yeah that will be far more interesting to know

@SSPanesar 17 күн бұрын

That would be a challenging task...

@piksodriver 15 күн бұрын

@@SSPanesarthere is macro that do it as brute force

@SSPanesar 15 күн бұрын

@@piksodriver gr8 to here that.

@Derekzparty 11 күн бұрын

Either use hashcat or johntheripper. I've mainly used johntheripper for cracking zip files, but they can do many more file types.

@yagneshbhatt8399 21 күн бұрын

Though you made it appear simple. I have some challenges. I have a file which is protected as xlsm. I was unable to convert this file into zip file. The second challenge was that though the file was xlsx and it did get converted into zip file. The xml file in the folder worksheet could not be converted into word pad. Please advise how to handle this.

@Bisdako2013 14 күн бұрын

This will work on Word protected file?

@SuperVikas45 18 күн бұрын

Can we do it for vba codes.

@mohammedismail2198 13 күн бұрын

How come MS make such option which is easily tampered with? What is the use of giving password to the worksheet if it can be tampered like this....Though good information......

@joseluismatam.1660 9 күн бұрын

Todo seguro, analógico o digital, tiene o llega a tener su cerrajero

@productionmate 11 күн бұрын

Does it work for Mac Excel?

@robertweigl7201 13 күн бұрын

a note sometimes error messages can occur, when reopening, the renamed file, but the content is still accessable

@apeel2008 24 күн бұрын

I’m wondering if looking at the code if there is a way to see what the original password is without deleting it. I assume it is inherent in the HashValue. Any way of translating the HashValue to the actual password?

@trumpexcel 24 күн бұрын

I tried researching on that a little bit but couldn't figure out how to get the original password back

@apeel2008 24 күн бұрын

@@trumpexcel OK. Thanks!

@peter.mccullagh 21 күн бұрын

A hash is a one-way transform. You cannot translate it back to the original password I'm afraid

@apeel2008 21 күн бұрын

@@peter.mccullagh Thanks. Makes sense for security purposes.

@jmwill2005 25 күн бұрын

Is there also a way to unprotect the entire workbook, when it got protected with "Protect Workbook" command in the "Review" section of the Ribbon?

@thewelder3538 17 күн бұрын

No, there's no way to do that without brute forcing the AES encryption.

@seifeddine1163 14 күн бұрын

cannot work in window 8.1 or previous version of windows, i tested with 7zip and WinRAR, the files doesn't appear

@tekmepikcha6830 25 күн бұрын

OMGGGGG 👏👏👏👏

@mariotabet3938 25 күн бұрын

Do you think this would work with VBA security too? I know, I’m too lazy to try after a long day!

@alanmonaghan9194 25 күн бұрын

I'm pretty sure it doesn't work with VBA security as they are binary files rather than XML files.

@mariotabet3938 25 күн бұрын

@@alanmonaghan9194 that was helpful. Thanks!

@kandinovich 16 күн бұрын

Numpang nitip gorengan.

@ksumar 23 күн бұрын

Brilliant 💯 Was was the password: "SHA-512"?

@trumpexcel 23 күн бұрын

No, this wasn't the password 🙂

@thelammas8283 12 күн бұрын

And whilst you watched this, I cleaned out your entire bank account 😂😂

@RhetoricalLanguage 24 күн бұрын

Hi Sumit, I can't seem to download the excel file shown in the video. It downloads the pdf of 51 tips.

@trumpexcel 24 күн бұрын

You can get the file from here - www.dropbox.com/scl/fi/1zvawx0zpvi4jn9dk3i4j/Call-Center-Dashboard.xlsx?rlkey=n2u8rp8h2vil4r3gboh4yzo42&dl=1

@RhetoricalLanguage 24 күн бұрын

@@trumpexcel Thank You very much

@erbalumkan369 15 күн бұрын

Will this work for a .xls file as well?

@trumpexcel 14 күн бұрын

Seems to be working only with xlsx file format. With XLS, it doesn't open the ZIP folder for me

@tideypaws 10 күн бұрын

isn't there something for a newer file, where the data is encrypted?

@trumpexcel 10 күн бұрын

I did this with Excel M365 file. Works well for all the new versions

@tideypaws 10 күн бұрын

That's for the oldest possible version of excel?

@catito_meister 18 күн бұрын

After i changed the extension to zip, i cant open the zip file. It says is invalid. Anyone has the same issue?

@myticktack 13 күн бұрын

It need to be a .xlsx file (new Excel format) not a .xls file. if you have a .xls file you need to covert it first into a .xlsx file.

@yvancg 9 күн бұрын

Does it work with pdf files as well?

@trumpexcel 9 күн бұрын

No, this is only for protected Excel worksheets

@yvancg 9 күн бұрын

@@trumpexcel can you make a video for opening protected pdf?

@James-rh4nt 10 күн бұрын

Now, how do I get into a password protected spreadsheet?

@rajanvadakkepat 25 күн бұрын

How to open protected vba excel sheet

@trumpexcel 25 күн бұрын

If the VBA project is locked, there is a separate process for it. Will make a video on that too.

@dermotbalson 17 күн бұрын

You can also remove sheet passwords by brute force because they are hashed into 8 bits (as I recall). This means there are many other passwords which will open the sheet. Just write a program (in VBA or anything else) to test random passwords until you find one that unlocks the sheet. It usually takes only a minute or two. (This is completely different encryption to that used to protect whole workbooks, which is extremely difficult to crack).

@johnnycbad 4 күн бұрын

This used to work but Microsoft changed the hash algorithm a few years ago. Notice in the part where the sheet protection code is removed, there's a bit that mentions SHA-512. That's the new algorithm.

@niltmp7126 17 күн бұрын

Scary

@badhombre4942 13 күн бұрын

It's a feature not a bug.

@tedmoy 25 күн бұрын

Awesome video!!! Time for a coffee break Mr. Bansal

@trumpexcel 25 күн бұрын

Thanks Ted 😊☕

@sanjayshrestha3013 22 күн бұрын

I converted excel file into Zip but after zip folder created it’s again same excel file inside the folder

@stephenl5693 21 күн бұрын

By chance did you right click on the excel file and choose to send to zip? That would give the symptom of what happened to you. Instead ensure filename extensions are turned on so that you can see the .xlsx at the end of your filename then rename the file by replacing the .xlsx to .zip

@gadgetsfunnel2886 19 күн бұрын

Same problem

@gadgetsfunnel2886 19 күн бұрын

@@stephenl5693 did but still same issue

@JaxHO 13 күн бұрын

My worksheet doesn't show .xml instead, it stated .bin

@trumpexcel 13 күн бұрын

It's likely that in your file, the VBA code is locked. Is it an XLSX file?

@JaxHO 8 күн бұрын

@@trumpexcel It is in xlsm

@alanparkinson549 16 күн бұрын

"The Compressed (zipped) Folder ... is invalid" when I try opening the zip file.

@kenyarborough812 10 күн бұрын

protecting a worksheet is not the same as encryption. It you save a excel spreadsheet with a password, removing the xml tag would do nothing.

@trumpexcel 10 күн бұрын

Yes, this method is only when thr worksheet is protected. Doesn't work when the entire file or the VBA code is protected

@Packhorse-bh8qn 20 күн бұрын

Excel has 3 levels of protection. I have a macro that unlocks two of them in seconds. This is even simpler.

@charlesrodriguez2176 25 күн бұрын

Thank you for all that you do. This is a touchy subject - you're essentially showing how to hack a way around password-protected data. You used the reasoning of a "forgotten password" or "inheriting an Excel file from someone that is no longer accessible". It's like teaching how to bypass a home's security "just in case one loses their house keys". You understand that this information can/will be used to by a criminal element. Again, thank you for sharing your videos - I've learned a great deal in the past. This video is not one I can support/promote though. The real complaint is to Microsoft for this disappointing Excel flaw.

@trumpexcel 25 күн бұрын

The idea is to share a way in case people get stuck (which happens a lot). The security of Excel files is pretty week, and I always mention this whenever I talk about protecting Excel sheets and files using built-in measures. The security is more about making sure people don't accidentally end up changing the formulas or data. For someone who needs to really password protect a file, they should always go for more than the built in solution. But I respect your sentiment.

@binot-ol6pd 21 күн бұрын

@trumpexcel... In that case where genuine reason to protect the vba files are absolutely crucial, can you please share a video how to protect them beyond standard / built-in methods ? Your help without any doubt is very much appreciated

@LeonDieBoer 7 күн бұрын

Trust an Indian to figure this out... there's actually an easier way but I am not gonna say how.

@thewelder3538 17 күн бұрын

This is like the stupidest video I've ever come across. Firstly, when you change xlxs into zip, you're not converting ANYTHING. An xlxs file *IS* a zip archive, just because it has an extension that's associated with Excel doesn't mean anything. Secondly, removing some xml from a worksheet is something I'd have thought everyone knew. Now, let's see you do that with a Excel file that's password protected from opening. Good luck breaking/brute forcing the AES for that archive.