A. Unblock a spreadsheet in Excel
1. Open the worksheet that is protected.
2. Click the “Review” tab.
3. Click “Unprotect Sheet”. The calculation time will now be unlocked.
If the worksheet is password protected, type the password to unlock the worksheet.

1. Opens the Excel spreadsheet that is protected.
4. Once you’re signed in to Google Docs, click “New” and select “Sheets.”
5. Returns to the Excel spreadsheet that is protected.
6. Click the cell in the corner that has no label, which is located above row 1 and to the left of column A. All the data in your spreadsheet will be selected.
7. Select “Copy” to copy all data or press ^ Ctrl + C on your keyboard.
If you are using a Mac, press ⌘ Command + C to copy all data.
8. Go back to the Google spreadsheet and paste the data you copied from the protected Excel sheet. Now the data will be unprotected and you can work with them on Google.

C. Unlock a password protected document using developer code
1. Opens the Excel spreadsheet that is protected.
2. Press ⎇ Alt + F11. This way, you can work with your spreadsheet in developer mode.
3. Copy and paste the following code into the blank space of developer mode:
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
MsgBox “A possible password is” & Chr (i) & Chr (j)
Chr (k) & Chr (l) & Chr (m) & Chr (i1) & Chr (i2)
Chr (i3) & Chr (i4) & Chr (i5) & Chr (i6) & Chr (n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub”

4. Click “Run” at the top of the window, or press F5 to run the command. Excel will display a message on the screen that will contain the password of your spreadsheet.
5. Enter the password and click OK.
6. Click the “Review” tab, then click “Unprotect Sheet”.
7. Enter the password for the document. Now your Excel worksheet will be unlocked.