Ⅰ excel表格密碼忘記了,怎麼找回密碼
選中加密文件，後綴名改為rar。雙擊該文件，選擇打開XL文件夾。打開文件夾，將sheet1文件拖到桌面。右鍵該文件選擇記事本打開，查找。刪除該詞所在括弧內的全部內容並保存。點擊確定，將後綴名重新改為XLSX即可。
清除Excel工作表密碼
選中需要清除密碼的表格文件，「右鍵」-「重命名」，將「.xlsx」表格文件後綴改成「.zip」或「.rar」壓縮包後綴。（該方適用於.xlsx後綴文件有效）。雙擊打開壓縮包文件，進入「xl」下的「worksheets」，在這里找到你需要清除密碼的工作表，雙擊打開，「打開方式」設為「記事本」。
使用快捷鍵「Ctrl + F」，打開查找功能，輸入「protect」查找，刪除protect所在的<> 括弧及括弧中所有內容，然後保存，確定。刪除。再將壓縮包重命名，將後綴改回來。
最後，我們打開表格看看，現在工作表密碼就已經被我們清除掉了，我們可以隨意改動，都不會有彈窗提示了。
Ⅱ 我的excel表格密碼忘記了，怎麼解密啊
excel表格密碼忘記後的解密步驟如下：
1.按住快捷鍵ALT+F11，然後切換出VBA編輯窗口，如圖一；在該窗口的左側我們的選擇那個忘記密碼的工作表，比如sheet 1。
Ⅲ EXCEL文件上加密了，可是忘記了密碼，怎麼辦
樓主的是暴力破解器，如果你設置的密碼超過8+的話
那就很難破解！
office密碼破解器
office
password
remover
v1.0.0.2
這個也許可以幫助你
Ⅳ Excel文件忘記密碼怎麼辦
可以通過以下步驟解除Excel加密密碼：
所需材料：Excel、記事本、解壓軟體。
一、首先點擊選中被加密的表格文檔，按F2重命名，把文件格式改為RAR。
Ⅳ Excel的保護密碼忘記了怎麼辦，急用
有兩種方法可以解決：
方法1：使用密碼破解程序破解。以下為具體方法：
1打開文件
2工具---宏----錄制新宏---輸入名字如:aa
3停止錄制(這樣得到一個空宏)
4工具---宏----宏,選aa,點編輯按鈕
5刪除窗口中的所有字元(只有幾個),替換為下面的內容:(復制吧)
6關閉編輯窗口
7工具---宏-----宏,選AllInternalPasswords,運行,確定兩次,等2分鍾,再確定.OK,沒有密碼了!!
內容如下：
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
再用該密碼給保護，原來使用者的密碼同樣能打開。
方法2：使用壓縮包解決。
將文件後綴名改為RAR。
打開壓縮包文件，找到一個xml文件，用文本方式打開。
打開之後，找到代碼pssword 語句，將該句刪掉。
再將後綴名改為xls，再打開就沒有密碼了。
Ⅵ Excel文件忘記密碼怎麼辦
1.開啟excel文件點擊撤銷工作簿保護時忘記密碼的情況,
2.這時就可以右鍵文件,開啟右鍵菜單列表,
3.點擊重命名把文件後綴改成rar,
4.改成完rar使用壓縮應用打開這個rar文件,
5.然後打開xl目錄下的worksheets文件夾,
Ⅶ 如何解鎖excel中的密碼忘了怎麼辦
Excel保護密碼若是忘記，可通過以下步驟進行解鎖：
所需材料：解壓軟體（這里用的WINRAR）、Excel2007演示。
一、下圖中這個表格文件被保存，雙擊表格內單元格內會彈出該表格為只讀，那麼開始破解該表格。
注意事項：
1、第五步查找的內容「sheetPro」中，「P」必須是大寫，其他字母必須全部為小寫，否則找不到。
2、第六步選中的是「sheetPro」所在尖括弧內的全部內容，包含尖括弧。
3、若是使用能夠在壓縮包內修改的壓縮軟體，第三步可跳過，直接在壓縮包內進行修改。