As in Excel, remove the file protection. Excel Remove sheet protection not knowing password? Using the archiver and notepad
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 ...
- click the tab File (File)
- select Menu Information (info)
- click
- 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)...
- in the dialog box, click Service (Tools)
- and select the point in the menu Common parameters 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)...
- call the password input window (Menu Information (info)
- press the button PROTECT WORKBOOK
- select Encrypt with Password)
- 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 ancient Excel 6-95) - this is an opening password: all the contents of the file are 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 Excel To calculate the key, different password conversion algorithms are used. 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 go through the possible options for 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 reliable password In two ways and know what to do if he 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 On the opening from 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:
- that Excel has a number of password protection, which always instantly wake up
- what for EXCEL Password Closed 97-2003 need to look for the encryption keynot password
- what to decryption excel documents 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
Information is perhaps the most valuable thing that is. Especially in the era computer technology. That is why developers software Provide their users with data encryption. No exceptions and craftsmen from Microsoft, which in all programs office package Added this very opportunity. However, after encryption, it is important not to forget the password to get information back. This article will tell how to remove the protection in Excel, regardless of whether you blocked the book or sheet.
Ways unlocking
You will be interested:
As it was said earlier, you can block the book and a sheet in Excel, respectively, the method of unlocking is different. Below they will be considered more in more detail. In addition, I would like to highlight the ways that are removed in Excel protection from a sheet or book when you forgot the password. This will be also told at the end of the article.
Methods 1: Unlock books
First of all, we will analyze the method of unlocking the book directly, and then we will tell you how to remove sheet protection in Excel 2007.
After you need to save changes, simple wordsjust save the book. To do this, while in the "File" tab, click on the "Save" or "Save As" row. In the second case, you will then need to specify the place of saving.
Method 2: Removing Leaf Protection
There is another way to block the contents of the document - protection of the sheet. In this case, the user can easily open the book and even view the contents of all sheets, it only forbidden to make adjustments to the table. If he tries to do this, then the appropriate content is notified, which is notified of the need to remove the protection from the sheet in Excel. Now we will consider in detail how to do it:
As soon as you do it, you will immediately open the entire range of options for adjusting the table data.
Method 3: Unlock through changing the file code
We figured out how to unlock sheet if special code Known, but how to remove the protection from the sheet in Excel 2010, if you forgot your password? Fortunately there is a way that does not even imply the use of third-party software. However, if the table has an extension of XLS, it must be recoded in XLSX. This is done as follows:
After that the file will be the desired expansion And you can go directly to removal of protection from the leaf in Excel:
You can run a file in Excel, now blocked previous sheets have become available for editing.
Method 4: Using third-party programs
In Excel, remove the protection from the sheet or from the book if you have forgotten the password, it is still easier - using special software. IN this example ACCENT OFFICE PASSWORD RECOVERY program will be used.
After decoding is completed, all passwords will be removed from the document. The success of this operation directly depends on the complexity of the cipher itself.
Open Exel from the Start menu for example.
Choose File - Parameters - Add-in - Overview
Click overview and specify the path to the file.
This script is in its way embedded in Excel. When you open, Excel warns you that the macro starts, do not hesitate and boldly launch it. Further open the file in which you want to break the password. The Straxx tab will appear at the top panel, click on it. There we appear 2 icons, when you click on which you can remove protection either from the sheet, or from the whole book.
Using the archiver and notepad.
Everything is simple here. We take and change the extension file S.XLSX N.Zip. If there is no extension in the name of the file, it means you need to go to the folder parameters (Service → folder parameters → View tab) and remove the checkbox from the "Hide extensions for registered files".
The second moment if the file is created in old version Programs and has an extension .xls, then such a focus will not pass with it. First, it needs to recover V.XLSX. To do this, open the file in Excel, click Save as in the "File Type" line "Excel Book (* .xlsx)".
Now the new archive is open by any archiver, such as free 7-zip, and we find and open the following file: "Vashfile.zip / XL / Worksheets / Sheet1.xml".
You can open it with a standard Windows notepad. Now in the text we are looking for "SheetProtection", do not forget about Ctrl + F \u003d).
The block that we need should look something like this:
Remove it completely. Then we save all the changes, change the extension of our file back V.XLSX, open in Exel and the defense as it did not happen.
In the latest headings of the office (starting from the tenth), the removal of the entire block leads to the locking of the sheet as a result of an error and an attempt to restore, resulting in a data loss. It is solved like this: not the entire block is removed, but only the value of the Password variable, and leave the quotes to password \u003d "", then open the sheet and simply remove the sheet protection without a password.
The number of sheet.xml files will correspond to the number of sheets in your document: Sheet1.xml, sheet2.xml, sheet3.xml and so on, and everyone can be pereln.
Remove protection with macro.
To begin with, let's go to excel Settings and turn on the Developer tab.
Go to the Developer tab, click the "Macro" button (Alt + F8), enter the name of the macro, the name can be any and press to create.
The window should open:
To the window that appears copy the following code:
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 j \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 i4 \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_: Resume NXT_
End Sub.
It should get like this:
Close, and again in the Developer tab, click the "Macro" button (Alt + F8), select our macro and this time click execute.
We are waiting, in my case 29.5 seconds, everything, the protection is removed.
using OpenOffice.
OpenOffice is free package Office applications. Open our long-suffering file in OpenOffice, come in service → document protection and click on "Sheet", and this is all manipulation \u003d).
Save the file, open in Excel and make everything with it that will do.
By default, the sheet protection blocks all cells so that none of them is editable. To enable some cell changes, leaving other cells locked, you can unlock all cells. You can block only certain cells and ranges before protecting the sheet and, if necessary, allow specific users Change only in certain ranges of protected sheet.
Lock only certain cells and ranges of cells on a protected sheet
Follow the steps below.
Password is optional. If you do not specify a password, any user can remove the protection from the sheet and change the protected items.
Select an easily memorable password, because in the case of the password loss, you will no longer be able to access protected sheet elements.
If the sheet is protected, do the following:
Highlight the entire sheet by pressing the button. Select all.
On the tab the main Press the call button dialog box cell font format . You can also press Ctrl + SHIFT + F or Ctrl + 1 keys.
In the dialog box Format cells On the tab Protection Uncheck the box blocked and click OK.
When protecting the sheet, all cells will be unlocked. Now you can choose specific cells that need to be protected.
Highlight only those cells that need to be blocked on the sheet.
Open the pop-up window again Format cells (Ctrl + SHIFT + F).
This time on the tab Protection Check the Protected Cell checkbox, and then click OK.
On the tab Review Press the button Protect sheet.
In the list, select Elements to be available to users to change.
|
Leaf elements chart
In the Enter the password for the sheet, click OK
Unlocking the ranges of cells on a secure sheet to change them by users
To provide certain users to resolve the ranges on a secure sheet, the computer must be installed on the computer. operating system Microsoft Windows. XP or later, and the computer itself must be in the domain. Instead of using permits for which a domain is required, you can also set a password for the range.
To add a new editable range, click Create.
To change the existing editable range, select the field, then click Change.
To remove the editable range, select Field Protected Sheet Ranges Unlocked by Passwordthen click Delete.
Making changes to graphic objects, including cards, built-in charts, figures, text fields and controls that were not unlocked before installing the sheet protection. For example, if there is a button that runs the macro on the sheet, you can click to start the macro, but you cannot delete.
Making any changes (for example, formatting) into the built-in diagram. The diagram will still be updated when it changes its source data.
Adding or changing notes.
Select the sheets you want to protect.
On the tab Review in a group Change Press the button.
This command is available only if the sheet is not protected.
Perform one of the following actions:
In field Name Enter the name of the range you want to unlock.
In field Contains cells Enter the equal sign ( = ), and then reference to the range that you want to unlock.
You can also click the button. Collapse dialog box, choose a range on a sheet, and then press the button again. Collapse dialog boxTo return to the dialog box.
To control access using the password in the field Password range Enter the password to access the range.
When using access permissions to set a password optional. Using a password allows you to view the credentials of all authorized users changing the range.
To set access permits, select item. Permissions and click Add.
In field Enter object names to select (examples) Enter the names of users who need to be resolved to change the ranges.
To see how usernames must be entered, click examples. To check the correctness of the names, click Check names.
Press the button OK.
To specify the type of permissions for the selected user, in the field Permissions Install or uncheck the checkbox Allow or Banand then click Apply.
Press the button OK twice.
If necessary, enter the specified password.
In the dialog box Allow changing ranges Press the button Protect sheet.
In the list Allow all users of this sheet Select items to change users.
Additional information about sheet elements
|
Leaf elements chart
In field Password to disable sheet protection Enter the password, click OKAnd then re-enter the password to confirm.
Password is optional. If you do not specify it, any user will be able to remove protection from the sheet and change the protected items.
Make sure you choose the password you can remember. If you have lost the password, you will not be able to access protected items on the sheet.
If the cell belongs to several ranges, users can edit users with the right to edit any of these ranges.
If the user tries to change several cells at the same time and it is allowed to make changes, but not all these cells, the user will be asked to change the cells on one.
additional information
You can always ask a question by Excel Tech Community specialist, ask for help in the Answers Community Community, and also offer new feature Or improvement on the Excel User Voice website.
Note: This page is automatically translated, so its text may contain inaccuracies and grammatical errors. It is important for us that this article be useful to you. Was the information useful? For convenience also (in English).