hey what's going guys in this video
we're going to try to break the excel
sheet password so right here under the
test
excel file add two worksheets so right
now these two worksheets are password
protect so going to apply a worship as
well and so for the route data let's go
ahead and right-click the tab and click
on potage sheet so here I'm going to
randomly check some options
okay and that should be enough I'm going
to name the password on Microsoft and
for the other Archy one I'm
also going to do the same so here I'm
going to type some text and right-click
potenti and this time I'm going to use
the password Excel and save this file
now if I try to type something on the
excel sheet I am going to get a warning
message that this whooshes password Pat
at the same for the route data as well
now let me close the excel file I am
going to make the icon look bigger so
the first step is to make a copy of the
excel file and just in case if you
corrupt the excel file you know you have
a backup to come back to and we're going
to use the test dot xlsx excel file for
demonstration so I'm going to move the
copy to a new folder and before get
started
I make sure that you set the setting to
display the file extension name and to
do that in your folder go on the view
and go to options and you want to go to
view so you want to uncheck the hide
extensions for known file type make sure
that these are options uncheck my suit
under click on OK and that will display
the for our file name plus the extension
now that's going to change the extension
from xlsx to the IP so we need to
convert this to a zip file now double
click on the zip file and that gives you
all the I'll say the Ralph files that
make out to the excel file what we need
to focus on is the Excel folder the
Excel folder basically contains all the
file make out to your sheet so here if
we go
if we look at the Excel folder and here
we have the thing to deem basically just
the your Excel on team style and here's
the worksheets and workbooks tiles and
share settings and want to go on the
double sheet folder and you can see that
we have two files so she won that XML
file and she to the XML file
so this two file are basically the route
data that make up to those two both
sheets now last slide is to file and
drag these two file to your desktop or
somewhere on your computer in here grab
a notepad so here I'm going to choose a
notepad it will drag did she want that
XML file to a notepad and I will display
all the XML markup make out to the siwon
excel worksheet and now you want to
scroll down a little bit towards the
bottom and here you want to look for a
tag sheet protection now I like the shoe
protection tag from the beginning all
the way to the end of the tag so right
here you notice the end of the the tag
is when you see a four slash now delete
the tag and safe and okay now let's open
a new notepad and we'll do the same way
sheet to that XML file so we'll scroll
down all the way to host again and we'll
look for she protection right here
and well how I owe that text all the way
to the end like right here mentally
and save the file now open up the file
again and my was open still now you want
to remove these two files and you want
to replace where the existing will
sheets XML file and close now we need to
change the extension name back to the
regular Excel extension named Excel SX
and refresh my okay now if we open the
original excel file and here we're not
getting any errors and now if we hover
our mouse and right-click and now you
can see that the petitioner got removed
so now if I try to type something on the
worksheet and we're not getting the
warning message anymore in same with the
raw data was she so here if I want to
delete all the data on the raw data was
she mmm and now I'm able to do that
successfully so this if thing I have to
show you guys I know a lot of time
people forget their what she password
and most of time people scramble to are
not able to figure out know how to
achieve the information from the excel
file and I hope this video will be
useful to some of you guys if you guys
found this video useful please my video
like and subscribe to my channel as
always thank you guys watching I'll see
you guys on the next video