问答文章1 问答文章501 问答文章1001 问答文章1501 问答文章2001 问答文章2501 问答文章3001 问答文章3501 问答文章4001 问答文章4501 问答文章5001 问答文章5501 问答文章6001 问答文章6501 问答文章7001 问答文章7501 问答文章8001 问答文章8501 问答文章9001 问答文章9501

excel加密后忘记密码了,怎么办?

发布网友 发布时间:2022-03-25 07:39

我来回答

4个回答

懂视网 时间:2022-03-25 12:00

产品型号:ASUS S340MC

系统版本:Windows 10

软件版本:Microsoft Office Excel 2019

excel忘记密码是无法找回的,但可以删除加密数据,来解锁excel文件,具体操作如下:

1、首先选中被加密的excel文件,按F2键把文件后缀名改为rar。

2、然后双击打开该压缩文件,选择打开XL文件夹。

3、接着打开worksheets文件夹,将sheet1.xml文件拖到桌面。

4、右键该文件选择使用记事本打开,按Ctrl+F键查找protection。

5、删除该词所在尖括号内的全部内容并保存,再将该文件拖回压缩包。

6、最后在弹窗中点击确定按钮,将压缩文件后缀名重新改为XLSX即可。

总结

1、首先选中被加密的excel文件,按F2键把文件后缀名改为rar。

2、然后双击打开该压缩文件,选择打开XL文件夹。

3、接着打开worksheets文件夹,将sheet1.xml文件拖到桌面。

4、右键该文件选择使用记事本打开,按Ctrl+F键查找protection。

5、删除该词所在尖括号内的全部内容并保存,再将该文件拖回压缩包。

6、最后在弹窗中点击确定按钮,将压缩文件后缀名重新改为XLSX即可。

热心网友 时间:2022-03-25 09:08

只要知道密码特征,根据组合遍历尝试,一般情况下是可以解密的。

举例说明。

将文件sample保存为带密码的文件,密码设置为“123”。如图:

第二步:创建新文档。

第三步:插入模块,输入以下代码。

Sub crack()

Dim i As Long

Dim FileName As String

i = 0

FileName = Application.GetOpenFilename("Excel文件(*.xls & *.xlsx),*.xls;*.xlsx", , "VBA破解")

FileName = Right(FileName, Len(FileName) - InStrRev(FileName, "\"))

Application.ScreenUpdating = False

line2: On Error GoTo line1

Workbooks.Open FileName, , True, , i

MsgBox "Password is " & i

Exit Sub

line1: i = i + 1

Resume line2

Application.ScreenUpdating = True

End Sub

如图:

第四步:运行宏。如图:

第五步:按提示打开指定的文件。运行后结果如图:

说明:1、这段程序仅适用于纯数字的密码;

          2、如果知道密码的基本特征,对上述代码进行适当的修改,基本也可以实现。

热心网友 时间:2022-03-25 10:26

设置的什么密码?如果是工作表保护密码的话试试这个:
打开文件-----工具---宏----录制新宏------输入名字如:123-----停止录制(这样得到一个空宏)工具---宏----宏------选123,----点编辑按钮---删除窗口中的所有字符替换为下面的内容(呵呵,代码不是我写的,感谢写这段代码的人,非常好用)为免输错,你可以直接复制:
Public Sub AllInternalPasswords()
' Breaks worksheet and workbook structure passwords. Bob McCormick
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwords
'
' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)
' Modified 2003-Apr-04 by JEM: All msgs to constants, and
' eliminate one Exit Sub (Version 1.1.1)
' Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"Adapted from Bob McCormick base code by" & _
"Norman Harker and JE McGimpsey"
Const HEADER As String = "AllInternalPasswords User Message"
Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"
Const REPBACK As String = DBLSPACE & "Please report failure " & _
"to the microsoft.public.excel.programming newsgroup."
Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _
"now be free of all password protection, so make sure you:" & _
DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _
DBLSPACE & "Also, remember that the password was " & _
"put there for a reason. Don't stuff up crucial formulas " & _
"or data." & DBLSPACE & "Access and use of some data " & _
"may be an offense. If in doubt, don't."
Const MSGNOPWORDS1 As String = "There were no passwords on " & _
"sheets, or workbook structure or windows." & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = "There was no protection to " & _
"workbook structure or windows." & DBLSPACE & _
"Proceeding to unprotect sheets." & AUTHORS & VERSION
Const MSGTAKETIME As String = "After pressing OK button this " & _
"will take some time." & DBLSPACE & "Amount of time " & _
"depends on how many different passwords, the " & _
"passwords, and your computer's specification." & DBLSPACE & _
"Just be patient! Make me a coffee!" & AUTHORS & VERSION
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _
"Structure or Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _
"Note it down for potential future use in other workbooks by " & _
"the same person who set this password." & DBLSPACE & _
"Now to check and clear other passwords." & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _
"password set." & DBLSPACE & "The password found was: " & _
DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _
"future use in other workbooks by same person who " & _
"set this password." & DBLSPACE & "Now to check and clear " & _
"other passwords." & AUTHORS & VERSION
Const MSGONLYONE As String = "Only structure / windows " & _
"protected with the password that was just found." & _
ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean

Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do 'mmy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub

关闭编辑窗口

工具---宏-----宏运行----确定两次----等会儿(时间可能有点点长,要等会儿)----再确定
哈哈没有密码了

热心网友 时间:2022-03-25 12:01

付费内容限时免费查看回答1、先找到有工作表保护密码的Excel表格,然后将忘记密码的Excel文件名称后缀由 .xlsx改为 .rar,如果有提示可以忽略,一般不会造成什么影响。

2、用压缩文件打开忘记密码的Excel文件,然后按以下步骤进行操作:xl——worksheets——sheet1.xml(这里是将sheet1工作表设置了保护密码,可根据实际情况选择相应文件名)。

3、从压缩文件里面找到sheet1.xml文件,然后拖拽至一个方便找到的位置(因为我们要对其要进行修改) 。然后将sheet1.xml文件右击选择用记事本打开方式打开。

4、然后搜索,“protection”,把从这一段代码,全部删除掉。

5、然后再把修改后的sheet1.xml文件,选择拖拽到压缩的工作薄中,选择替换掉即可,点击确定。

6、最后一步,和第一步相反,把文件名称后缀,由“演示表格.rar”重新更改“演示表格.xlsx”。最后打开Excel表格,你会惊喜地发现是不是保护密码都取消了吧。

声明声明:本网页内容为用户发布,旨在传播知识,不代表本网认同其观点,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。E-MAIL:11247931@qq.com
做鼻小柱用什么材料好? 谁有visio2003版 WIN7 64位啊,有的话发个连接 中山东区怎样坐车去珠海 ...忘记了ID密码,苹果官网发来一个这样的网址,请问怎么操作? 苹果id被锁定26天后可以重设密码 快手发作品配的说说大全 四年级语文爬山虎的脚教案 工作井内有哪些设备 南方电网检查井内设有排管吗 安装电缆施工 ps怎么选取图片的一部分 ps怎么选定区域 苹果手机上的屏幕镜像怎么使用 PS如何移动选中部分 ps上怎么选中选择的部分 苹果手机同屏功能在哪里,怎么使用 ps中怎么选取自己要用的部分 苹果ipad 分屏功能怎么使用 ps怎么选取自己需要的部分 photoshop怎样选中图片的某一部分 ps如何选中自己要的部分 小米手环怎么调时间呀? 小米手环4怎么调时间 PS 如何选取自己需要的区域? 小米手环怎么调时间日期 小米手环怎么调时间呢? 小米手环怎样调时间? 电脑微信里的聊天记录如何上传给手机微信 手机微信聊天记录没有了,电脑上的能把以前的聊天记录迁移到手机上吗_问一问 微信电脑版的聊天记录可以同步到手机吗 ps如何选取部分区域 ps怎么选择部分选区 excel文档加密忘记密码怎么办 PS如何选中某区域 PS图片部分怎么选取 对于excel加密文件,忘记密码了怎么办 excel文档设的密码忘记了该怎么办啊? PS中如何单独处理选中的区域? excel文件加密密码忘记怎么办 ps 怎样选中要保留的部分 反选 ps中怎么保存自己想要的一部分? excel2007版文档加密后忘记密码,怎么解开? 如何复制PS中选中的部分 excel文件密码忘记了怎么办_excel文档密码破解方法汇总 急求问!!! ps 怎么选中图片的一部分并使其变为一个独立的图层??? 微信怎么看手机号码 微信怎么看电话号码? word文字右边不对齐 怎么样从微信里看电话号码 word里后面字不对齐怎么调