hello everyone Welcome To The Past Fab
Channel
there are several ways to protect the
data content of excel workbooks in Excel
files it is not possible to modify Excel
workbook data in this case if you forget
the password to unprotect your Excel
file how to remove it today this video
will show you how to unprotect excel
sheets without password
first let's open an Excel file that is
in the state without workbook protection
now let's set Excel sheet protection and
then delete it Part 1 unprotected sheet
in the review you can see the protect
sheet option
click it enter your password here and
you can customize the protection method
below click OK
enter the password again and click OK
press Ctrl s to save the Excel file
this sets up the Excel sheet protection
next let's create a copy of the Excel
file hold down control and click to move
the Excel file to create a copy this
will protect the Excel file from data
loss
select the Excel copy file and click the
name
change the file format to zip if your
Excel file does not show file name
expansion you can check the file name
expansion in the folder View
the Excel file will become the zip file
double-click to open the zip file
go to the following path to find the XML
file
copy this file out
right-click it and select notepad and
open with
you will see a large strain of text Data
Don't Panic
press Ctrl F to open find
enter sheet protection and find it
you will see the code for password
protection
we want to select the content between
the less than and greater than tags then
press the delete key next save the file
and close Notepad
then copy the XML file back into the zip
file to replace the original file
close the zip file and change the file
format to xlsx
[Music]
this turns it into an Excel file
double-click to open it you will see
that the Restriction protection removal
is complete you can freely edit the
content of the Excel sheet
next take a look at the part 2 and
protect workbook
select the protect workbook option of
review
enter the password and click ok
the protect worksheet setup is complete
double-click the sheet name and it
prompts that the workbook is protected
and cannot be changed
right-click the name to find that other
functions are also unavailable
close the Excel file and save it
next repeat the part 1 operation
[Music]
in the zip file find workbook XML copy
this file out
right click and open it in Notepad
press Ctrl F to open find type workbook
protection and click fine
[Music]
select the text between the less than
and greater than tags and press delete
[Music]
save the notepad and close it
copy the workbook XML back into the zip
file and replace it
change the zip file format back to excel
SX
[Music]
double-click to open the Excel file
worksheet protection restriction removal
is complete
next is part 3 and protect read only
read-only protection needs to be set in
the Excel file save as press F12 to open
save as
in the tools option below select the
general option
there are two options to set the
password enter your password in the
password to modify and click ok
change the file name and click save
close the Excel file and open the copy
of the saved Excel file
it prompts you to enter the password to
access or select read only
next let's see how to remove the
read-only protection restriction perform
the same operation as before
[Music]
find workbook saml in the zip file and
copy it out
right click it and open it with Notepad
press Ctrl F and type file sharing and
click find
select and delete the text between the
less than a greater than tags
save the notepad and close it copy the
workbook XML back into the zip file and
replace it change the zip file format
back to xlsx
double-click to open this Excel file
there is no prompt to enter the password
to access the Excel file content
properly if you think the previous
methods are tedious and can't be done in
bulk then please take a look at part 4
use passfab for Excel to unprotect excel
sheets
past Fab for Excel helps you to quickly
and safely and protect Excel sheets
launch passfab for Excel click remove
Excel restriction password
select to add Excel files with
protection restrictions
[Music]
now let's click remove
click open folder the Excel file for
unprotecting restrictions is in this
folder double-click to open
the Excel protection restrictions are
all removed
isn't it easy to operate click the link
in the description to get past Fab for
Excel and IT supports the recovery of
Excel and password come and try it
well that's all about how to unprotect
excel sheets without password thank you
for watching
if you found this video helpful please
give us a thumbs up and subscribe
see you in the next video