Tag Archives: 2020

How to break an Excel Password

How to break an Excel Password

How to break an Excel Password

 

There are many ways to protect an Excel spreadsheet from viewing and editing. One of them is to protect cells of selected ranges of the sheet against editing, changing the formatting, etc. There are situations, for example, that we forget our password to the sheet that we would like to unlock. We may also remember a password that, in fact, is incorrect.

The first thing to do is to check if CapsLock is on or off. The most common mistake in typing an incorrect password is CapsLock turned on. Before trying to crack a password in Excel, I suggest checking the password in both uppercase and lowercase.

  • Right Click on the name of the sheet
  • Click Unprotect Sheet…
  • Enter password what you remember
  • Click CapsLock
  • Enter again the same password

In addition, it may be worth trying to check frequently used passwords, such as 123456 or 654321. If these attempts do not help, you can try to crack the password in the sheet by using one of the three methods I have listed below.

Method 1. Using Macro VBA
Method 2. Unzip file and remove relevant code
Method 3. Using Google Sheet

Method 1. Break password using macro (VBA).
File with extension (.xls) version 2003 or before

    • Open a visual basic editor. Alt + F11
    • Right click on Sheet
    • Select Insert > Module
    • Paste code below  in the General Declaration page
Sub BreakPassword()

   Dim i As Integer, j As Integer, k As Integer 
   Dim l As Integer, m As Integer, n As Integer
   Dim i1 As Integer, i2 As Integer, i3 As Integer
   Dim i4 As Integer, i5 As Integer, i6 As Integer

   On Error Resume Next

   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

   ActiveSheet.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 ActiveSheet.ProtectContents = False Then
      Exit Sub
   End If

   Next: Next: Next: Next: Next: Next
   Next: Next: Next: Next: Next: Next

End Sub
  • Run the macro, press F5
  • If you received message below your sheet is unprotected.

 

 

 

 

Method 2. Break password removing relevant code. File with extension .xlsx version 2007 or later

  • Open a visual basic editor Alt + F11
  • Find relevant Sheet name
  • Unzip Excel file (e.g. you can use 7-Zip). Right Click on the file  and select from the menu 7-Zip —> Open archive
  • In the archive, go to the xl —> worksheets folder and set on the xml file with the code name you are looking for
  • Press F4 to go to editing in the default text file editor (most often it will be Notepad)
  • Open relevant file
  • Find, Select and delete text (blue selection below) from <sheetProtection…/> to  before<pageMargins…>

  • Save changes

The new file should be with unprotected relevant Sheet.

Method 3. Break password using Google Sheet

You have to be login-In to Google Account.

  • Start a new spreadsheet
  • Select File > Import
  • Select Upload from the menu.

  • Drag relevant file from your device and drop in the box above
  • Browse to the Excel spreadsheet on your computer. Select it, and click Open.
  • In the Import file window, select Replace spreadsheet and select Import Data.
  • Downlead as > Microsoft Excel (xlsx)
  • Choose where to save the document
  • Select Save As, give a name and Save

Now Your Excel Spreadsheet should be unprotected.

Send file: How to crack password in Excel? 

Each of the methods presented may not be sufficient in specific cases. There are different reasons for that. Different types of security are used, which requires additional complex actions. In such cases, we can try unlocking our Excel spreadsheet. Just click the link below and send the file for reviewing.

Request a quote

I also invite you to familiarize yourself with my projects in Excel, available in the Download tab, they may turn out to be useful.

UK Stamp Duty Calculator in Excel

UK Stamp Duty Calculator in Excel (England & NI)

Excel spreadsheet  calculates the Stamp Duty (SDLT) on your residential property purchase in England or Northern Ireland in 2020-21

UK Stamp Duty Calculator in Excel

It is extremely easy to use and you can save the file on your computer or any drive:

  1. Select Property:
    • Single property
    • Additional property or a Buy to Let

2. Property Price:

  • Enter a value of property.

Stamp duty automatically appears in the green box along with the effective tax rate below.

Stamp duty holiday.

The government has temporarily increased the stamp duty threshold to £500,000 for property sales in England and Northern Ireland, until 31 March 2021.

Download free New UK Stamp Duty Calculator 2020-21 by clicking button below:

Download Free

You can learn similar tips and tricks in Excel at a comprehensive Training in London.

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes is an Excel spreadsheet file created for season 2020 – 21. It allows bunch of people to run sweepstakes or office pool based on the outcomes of the matches and is fully automated. You can select interesting  teams and trace their trend.

Excel Premier League
Premier League Sweepstakes Excel spreadsheet contains worksheets:

  • Instruction – User manual and description
  • Schedule – Schedule matches, results and sweepstakes (manual parts)
  • Tables – Premier League Tables (Fully automated)
  • Players – Sweepstakes Players table and visualisation by round (Fully automated)
  • SET – Settings teams and calculates points for selected teams.

Sweepstakes rules

If contestant predicted exact result 3 points
If contestant predicted the winner of the match or a draw 1 point However, you are the owner of version PRO so you can easily change the number of points in worksheet SET and you can define different points for a different round.

FREE Premier League 2019-2020 Sweepstakes Excel spreadsheet download

Please feel free to download Premier League 2019-2020 Sweepstakes. It does not require any additional software or any registration and it is also free of VBA code. Just push the button below, save the file and enjoy supporting your team and keep calm during the contest if it is possible.

Download Free

Advanced version PRO

If you are interested in buying an advanced version of Premier League 2020-21 PRO 20, Sweepstake for 20 players, not protected by password, therefore you have a special access to advanced functions and methods used in this spreadsheet including easy settings point by round, please click button below Buy Now.

£9