What to do if the Excel password forgets

Source: Internet
Author: User

Method One: Third party office Password remover Software

Through the loss of data we will guide the use of Third-party data recovery software to repair, and the password has forgotten, we can also collect third-party tools to crack the password way to solve. Here we recommend that you use the office2003 version: Password Remover2.0 software.

Office Password Remover is a tool that can instantly crack Word, Excel, and Access document passwords, typically with a decryption process of less than 5 seconds, and is simple to operate without setting. But use the software need to connect to the Internet, because to the software server to send a small amount of data and decryption, but the software does not disclose any personal privacy, please feel free to use. As shown in the figure:

Method Two, by enabling the macro program to crack the Excel document

If the above method to break the exception, we collect through the macro-enabled program method for password cracking, the specific operations are as follows:

Create a new Excel document file to make sure that the macro can be enabled (menu tools-Macro---Security settings, adjusted to "medium"). Press ALT and F11 at the same time, go to the VBA interface, insert on the order list, module, paste the code in the new window:

Sub crack ()

Dim I as Long

Dim FileName as String

i = 0

FileName = Application.getopenfilename ("Excel File (*.xls & *.xlsx), *.xls;*.xlsx", "VBA Cracked")

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

Then this interface directly press F5 to run this macro, select the file (see password length). If more than 6 digits of the password may take longer, here we need to slowly wait.

Classification:
  • Excel Tutorials

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.