hello everyone in this video I'm going
to show you how to unlock the protected
worksheets are without using any of the
paid software or macro code so this is a
very simple trick and I'm going to show
you with our two simple steps on but
before that I finally request you to not
misuse this trick to unlock up non
copyrighted workbook or others workbook
um
so please use this if this workbook is
owned by you and you unfortunately
forget the password and don't use in
others workbook so this is some of the
sample data and what I am going to do is
um I am going to lock it
protect this sheets one with a password
so I am going to protect sheet I am
going to enter one of the complicated
password and click on OK and it's asking
again so I'm entering the password again
and click on ok now this sheet one is
completely protected so I'm just
checking it now I am saving and closing
this so this is the protected sheets I
am just trying to alter some values and
let's see what happens so it is a
displaying that the suit is protector
and you cannot able to do any changes so
now close this seat and I am going to
show you how to unlock it please watch
it carefully I am just editing this a
workbook name and change the file format
from excel sx to zip if you change the
filename extension the file might become
unusable or you sure want to change it
go ahead with s button now just extract
all here so now a new folder is created
called the sample folder is created on
inside that all
zip contents are extracted now what you
have to do is go to this Excel folder
please note that you should go to excel
folder not toda core error something for
the excel and inside the excel you will
find a three folder go to worksheets
folder so worksheets folder contain
three XML file sheet1 sheet2 and sheet3
we have protector a sheet one dot XML
file that is a sheet one in the workbook
is protected so we need to edit or do
something in the sheet one that XML so
open it with WordPad so now it uh this
XML file contain lot of data and what
you have to do is you need to find a
word called protection here it is so
what you have to do is um you need this
protection start with a lesser than tag
and always ends with in XML all the data
starts with lesser than tag and end with
slash followed by greater than tagging
so this sheet protection what you have
to do is this sheet protection start
with this lesser than symbol and the
ends with ends here at person arias is
equal to one it's in here with slash
followed by greater than sign what you
have to do is you need to remove these
from the XML you need to remove this
portion and this portion as well as this
tag also so I am just removing this tag
after removing this tag save this and
close this XML file now come back so all
your data is inside the sample folder
select all data and click on zip so you
need to select all this data and zip it
name this as unlocked XLS so I am just
zip it and name the file as unlock sorry
this is not properly unlock the name is
not correct okay leave it up I'm just
naming it as unlock followed by a file
name dot XLS so and again it is asking
that it might be commands unusable so or
you sure want to change it yes I want to
change it and just open this workbook
you are trying to open in a different
format specified by this so you pump
with that error message and after that
you will see the data in the sheet 1
which is unlocked now you you can do
anything what we want in the sheet 1
which is saw previously a lock with a
password so I am able to do anything on
the sheet editing or deleting or
anything I can do
it's purely unlock up please let me know
if you have any doubts and thank you for
watching this video please subscribe