How to remove protection in Excel. How to remove a password with an excel file: a few simple methods. Tell your friends on social networks

Periodically, during operation, it is necessary to establish or remove the password to the Excel file. In this article, we will look at how this can be done in various versions of Excel.

If you need to install a password in Excel, then you can do it in a special dialog box. The location of this window in different versions Excel is different.

Password must be installed after all changes in the file before saving it. To do this, go to the section Service → Parameters

After that, the Excel Book parameters dialog box opens, you need to select the tab Safetywhere you can enter either password for opening a file Exceleither password to change it In the appropriate field

After entering the password, you must click OK, while the window opens in which you need to confirm the password you entered. This is necessary so that you are confident that the password was first introduced correctly and remembered it. Changes will come up after saving the file.

Install or delete a password in Excel, and the way it is discussed below.

Install or remove password in Excel 2007 and 2010

Installing the password in Excel 2010 is slightly different from 2003, and now we will look at how it can be done. Set the password you can immediately before saving the file. To do this, select a dialog box to save the file: File → Save as

After that, the window will open where you need to select item Service → Common parameters

You worked hard and hard on the file for a long time, created complex formulas and made many data. Of course, such a file is better passing! And now it takes half a year, you need to make changes in the file, but password is forgotten? How to remove protection now leaf Excel Or as they say reset the password?

How to quickly remove the protection of the Excel sheet, if you forgot your password? In essence, hack a book.

There are several ways, but besides one, they are all bulky enough. Create () select double-click item "This book" as in the picture

Copy the window on the right window

Sub password_cracker () Dim T! Dim I As Integer, J As Integer, K AS Integer Dim L AS Integer, M As Integer, N As Long Dim i1 As Integer, I2 As Integer, I3 AS Integer Dim I4 AS Integer, I5 AS Integer, I6 AS Integer Dim Kennwort AS STRING T \u003d TIMER ON ERROR GOTO ERR_ FOR I \u003d 65 TO 66: FOR K \u003d 65 TO 66 FOR L \u003d 65 TO 66: FOR M \u003d 65 TO 66: FOR I1 \u003d 65 TO 66 FOR i2 \u003d 65 to 66: for i3 \u003d 65 to 66: for i5 \u003d 65 to 66: for i6 \u003d 65 to 66 kennwort \u003d chr (i) & chr (j) & chr (k) & chr (L) & chr (m) & chr (i1) & chr (i2) & chr (i3) & chr (i4) & chr (i5) & chr (i6) for n \u003d 32 to 126 ActiveSheet.unprotect Kennwort & Chr (n) MSGBox "Done In" & Format (Timer - T, "0.0 Sec") EXIT Sub NXT_: Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next Exit Sub Err_: NEXT EXIT SUBBER Resume NXT_ End Sub.

Want to install or remove the password in the Excel file, but do not know how? Need to remove the protection, but forgot the password? Or are you just interested in nuances for hacking protection in Excel?

Answers to these questions, practice and a little theory - below, in this small article.

Want to be a crow? See a 2-minute video. No extra words:

Installing the opening password in Excel

Set the password in Excel in two ways. They are not obvious to everyone, but expected simple.

See yourself.

Method 1. When working with the document is over ...

  1. click the tab File (File)
  2. select Menu Information (info)
  3. click
  4. and select

In the window that appears, enter the password and confirm it to avoid errors when entering.

Easy, simple and reliable!

You just protect the file from the opening - encrypted all its contents using the password. it the most reliable way of protectionwhich is the hardest hack.

Valuable Council - Do not lose your password!

Also through the menu Intelligence You can install other password protection - on the book and page of the document. But keep in mind: protection of the book, pages, VBA macros is unreliable in all versions of Excel. Such protection is crashed instantly.

Method 2. The second way to install the password is even easier to first.

Keeping a document as usual (File (File) - Save as Save AS)...

  1. in the dialog box, click Service (Tools)
  2. and select the point in the menu General Options (General Options)

In a new window, enter your password and confirm its correctly by re-entering.


Here you can also install not only a password for opening a file, but also a password for recording changes (yes, it is also always instantly wagged).

Password deletion in Excel

When the file protection of the file cannot be removed from the document and do not worry about his loss.

The procedure for deleting the password from Excel is similar to its installation.

Open the document and through the tab File (File)...

  1. call the password input window (Menu Information (info)
  2. press the button PROTECT WORKBOOK
  3. select Encrypt with Password)
  4. just erase password and click OK

In the password saved after this document will not be.

Password recovery for Excel

Everything is easy and simple when the password is known. But what if the password is lost and the important data was not available?

The answer depends on the type of protection and the version of Excel, which creates a document.

Three options are possible:

Restoring Excel password. Weak defense

For different purposes in Excel there are various protection options. Passwords for some of them are or removed instantly, regardless of the complexity of the passwords themselves and the Excel version.

Excel passwords that can be instantly found or deleted:

  • password recording changes
  • password Protection Page
  • password working book
  • vBA password Macros
  • opening password for Excel 6-95

There is a whole class of programs to restore Excel passwords. It is difficult to allocate some of them - they all equally successfully cope with simple protection in Excel.

Password recovery Excel 97-2003. Reliable protection with a secret

Reliable protection in Excel documents of all versions (except an ancient Excel 6-95) is a discovery password: all the file content is fully encrypted and the document cannot be even open without a password.

Well, since the password is lost, we will look for a password, right?

No, not true! There is also a secret.

In fact, do not password encrypts the file, but encryption key - Special value that is obtained from cunning password transformations. You enter the password, Excel converts it to the encryption key and tries to decrypt the file. If the password is correct, then you get access to the data. If the password is incorrect, then the encryption key will be incorrect and the data will remain inaccessible.

It turns out to open an encrypted Excel file you can search for a password, and you can - the encryption key.

And here he is a secret - for Excel 97-2003 you need to look for a key encryption!

And that's why...

In different versions of Excel, different algorithms for the key password transform are used to calculate the key. The key at the same time has a strictly defined length, which does not depend on the complexity of the password or from its length.

In Excel 97-2003 at the encryption key, the fatally small length is only 40 bits.

The modern computer takes a day or two to go through all 2 40 possible key values \u200b\u200band find the desired one.

And there will be a key - there will be no password!

Programs that can do this not so much. One of them is Accent Office Password Recovery (in it this option is called "key search").

A couple of days on the key search is great but how about a couple of minutes?

With the help of so-called rainbow Tables Perhaps this!

Speaking simple language, Rainbow Table is a multiple gigabyte database that stores calculated in advance values \u200b\u200bfor checking the keys. Search in the rainbow table of the control value occupies a couple of minutes. After that, the Excel document can instantly decipher.

Neither the length of the password nor its complexity has absolutely no meaning. A couple of minutes and everything is no password!

Rainbow tables are used by some software manufacturers for password recovery and in online services that decrypt any Excel file loaded to them.

Vernidostostost.Ru - an example of such a service

Password recovery Excel 2007-2013. Flawlessly reliable defense

Jokes and secrets ended with the advent of Excel 2007. Since then, the level of protection is growing, and the speed of password hacking decreases with each new version Excel.

The encryption key length increased to 128/256 bits and cannot be found (many options 2 128 or 2 256 it is impossible to move simply). For the same reason, for Excel 2007-2013 there are no rainbow tables.

It remains to act in the forehead - to sort possible options passwords. In sequence.

And then they came to the rescue - video cards.

As it turned out, their power is suitable not only for super-terminal computer gamesBut for many other tasks.

So exactly and to recover Excel 2007-2013 passwords too.

The speed of passwords in just one video card can increase ten times, that is, the time of your expectation will decrease in tens of times.

Of course great! Connect one or two-all video cards to the password coupling and reduce your waiting time.

But pay attention: not all programs to restore Excel 2007-2013 passwords work on video cards. And those used them, do not always make it at high speed. We'll have to look, test, choose ...

Instead of the result

Summing up can be said: If you want to truly protect your data, use the opening password in Excel 2007-2013 documents and never lose it.

Now you know how to install a reliable password in two ways and know what to do if it is still lost.

Check yourself or what I exchanged my time

You have received useful practical knowledge. You learned:

  • passwords In Excel documents 2007-2010-2013 in two ways
  • delete password to open out excel files 2007-2013 in a couple of clicks

And you have received many theoretical knowledge that will help you right now or in the future. You learned:

  • what's in Excel whole line password protection that always instantly wake up
  • what for EXCEL Password Closed 97-2003 need to look for the encryption keynot password
  • what to decrypt documents Excel 97-2003 there are online services
  • what to search for a password opening documents Excel 2007-2013 you need to use video cards
  • what is the main criteria when searching for a program for recovery excel password 2007-2013 - support video cards and password size

It took urgently urgently to take protection from the sheets in Excel. Previously used this macro, but now the developer requires money for it. I had to look for a workaround. About him below.

Files recent versions Excel (2007 and above) represent "archive". Thus, you can either rename the XLS extension in Zip and open the archive, or open the XLS file itself in some file manager.

Opening to see such a picture:

Need to go to the folder xL, and after her folder worksheets.. In it, all sheets from the file will be located.

Copy these sheets from the archive (or one that is protected) into any directory and open Sheet1.xml using any text editor.

After that, we save the sheet1.xml and go to the next, if necessary.

Then copy the changed files back to the XLS file. And ... actually everything. 🙂 Now the sheets are open to change.

Perhaps the same procedure will ride in more early versionsIf the XLS file is previously turned into zip, but not sure.

Upd.: Just found a more elegant solution: "Open the file in LibreOffice. That's all. Libre does not care about all these passwords on editing, sheets, etc. It remains only to recover the file. "