Buy Me a Coffee?
Your donation will help me to continue to make more tutorial videos!
In Excel, you can password protect Excel workbook to prevent users to changing the structure of the Excel workbook. Excel workbook protection prevent users from viewing hidden worksheets, adding, deleting, moving, hide/unhide worksheets.
Imaging one day you forgot your Excel Workbook Password and you have no way to remember. In this video I will show you how to break the Excel Workbook Password Protection without using 3rd party software or VBA.
Visit my website
Considering support my channel through shopping on Amazon
Want to be more productive? Check out the the gear (Amazon affiliate links) I use when I am working.
Lenovo ThinkPad X1 Extreme 2nd Gen (4K):
ASUS Designo Curve MX38VC 37.5″ Monitor:
Logitech MX Master 3 Advanced (My primary mouse):
Logitech MX Anywhere 2S (When traveling):
Logitech Craft Advanced Wireless Keyboard:
VAVA USB C Hub, 8-in-1 USB C Adapter :
Theralite Aura Bright Light Therapy Lamp:
Xem thêm bài viết khác: https://danetidwell.com/giai-tri/
Xem thêm Bài Viết:
- Mì tôm TV nơi cập nhật những tin tức bóng đá nhanh chóng và chất lượng
- Review mẫu máy lọc rượu giá dưới 8 triệu đồng cho hộ kinh doanh nhỏ
- Sinh năm 1992 mệnh gì? Tuổi Nhâm Thân Hợp tuổi nào & Màu gì?
- Phần mềm quản lý bđs : Xu hướng mới trên thế giới
- Hướng dẫn cách chơi quay slot nổ hũ liên minh huyền thoại B52Club
You are the best bro. Thank you.
OMG Thank you ! Thank you !!
i can't open the file with winrar after i change the extantion to zip. "the archive is either in unknown format or damaged" any clue?
Thank you for the video but there is a problem that this thecnic does not work with "open password workbook" . Which means when i double click in order to open a workbook it want me to enter a password so the technic was fail. I am searching on the internet but i can not find any solution about this issue. Anybody know some solution please help me.Thank you
Thank you very much, it helped a lot.
Hi When i open the zip file, it said the file is damaged or corrupt..are there any ways to open the excel file?
Thanks man worked 100%
Perfect. Thank you so much. Very clear–and it worked!
im just not able to crack it … im inable to open the workbook 🙁 , kindly help
Thank you very much. It worked for me. I had to install winzip on my system.
im using notepad and i cant seem to find lockStructure anywhere, i even tried opening it with Wordpad still no luck :/
edit: i figured out that the workbook is not locked. however the sheets are. i unlocked the sheets with the same zip, delete and unzip process.
HOW DO I GIVE YOU MONEY
I recieved a Password Protected Excel file without the password, followed these steps and it worked a dream
Jie Jenn thank you for sharing
veryyyyyyyyyyyyyyyyyy good lesson
Thank you so much!!!!!
@Jei Jenn, nice trick. But when i am trying to do the same my zip file is not getting open, its saying unknown format or damaged.
Hi, the 7zip does not show the xml if it is protected. Is there a work around?
So if i change it back to 1 will the file go back to its original password state?
Super Brother its really great work thanks so much how to remove excel locked sheets
works flawlessly !! Great Job
Great tut! However when I zip and then extract I only get the excel file. I've tried this on a mac and windows 7.
Thanks Jie Jenn.. but I failed on final stage during Converting File.. it says "Converting…" but then its said "Something went wrong"
Does it require for excel file to connect online using Microsoft Account?
wow my friend, awesome, I need to buy you a coffee!!
When I open the .zip file, I get the following files:
I didn't get any xml files. I use Excel 2010, and my file is saved as .xlsx. Please help!
OMG – life saver!
Amazing, thank you!! I got it to work for the workbook protection. How can i unlock worksheet protection?
I converted to zip but could to able to open up the zip file
I cannot read any of the pages he presents so I cannot find the areas he goes to that will allow me to unlock a work sheet. I increase the screen to 400%
i forget my excel password..which apply general password not workbook..how to recover it
Doesn't seem to work for Excel 365 until I also removed the protection listed in the sheet.xml.
Hi, how do you do this on a MacBook? any help appreciated 🙂
very good video for excel
Thanks its worked
Thank you, you are a life saver
THANK you, very helpful!
Thank you a lot brother! Everything worked.
Hi Jie, I cant find the lock structure term. Maybe because I have the Office 365?
This is worrying. Where am I supposed to store my passwords in a big 'ol Excel Spreadsheet now?
Hi, I forgot my password of an excel file and tried to unlock by using your method. But when I open the zip file, it looks different from your video. My file shows 'EncryptedPackage'. I have no idea how to open this. Can you help? Thanks.