Home > Resources > Office Password > Unlock Excel Spreadsheet without Password

How to Unlock Encrypted Excel Sheets without Password

Locked out of encrypted excel spreadsheet and forgot excel password? It is so annoying. But excel sheets in important excel file are protected usually. So if you get such a file and you want to edit worksheet, you just could accept the fact and learn to unlock encrypted excel spreadsheet without password.

Before beginning to unlock encrypted excel spreadsheet, it is also necessary to know that excel file is usually encrypted with open password and modify password. And probably there is also a powerful password protecting spreadsheet from unwilling changes. Hence, if you want to unlock excel spreadsheet, two sections are needed to do.

  1. Section 1: Open encrypted Excel file with or without password
  2. Section 2: Unlock encrypted excel spreadsheet when excel file is opening

Section 1: Open encrypted Excel file with or without password

In this section, we would learn how to open encrypted Excel file with or without password, by recovering excel file(xls/xlsx) open password with iSunshare Excel Password Genius or removing excel xls file open password with iSunshare Excel Password Remover.

Way 1: Open encrypted Excel file after password recovery

Step 1: Install and run Excel Password Genius on your computer.

Step 2: Select and import excel xls/xlsx file into Excel Password Genius.

Click Open button on Excel Password Genius menu, and in pop-up diaglog, navigate to location of excel file you want to recover password. Select it and click OK to import into Encrypted File box.

import encrypted excel file

Step 3: Click "Start" button to recover excel file open password.

In order to recover excel file password more effectively, Type of attack is recommended to choose and make detailed settings for attack type you select before you tap on Start button to recover excel password.

choose excel file password recovery type

Then while you see a dialog appears after you click "Start" button and shows excel file open password, you can click Copy button to copy recovered password and tap on Open button on this dialog to instantly open encrypted excel file with recovered password.

successfully recover encrypted excel file open password

Way 2: Open encrypted excel file after password remove

Step 1: Install and run iSunshare Excel Password Remover full version on your PC.

Only full version of iSunshare Excel Password Remover could help you to remove excel file open password.

Step 2: Click Open button to add encrypted Excel xls file into iSunshare excel password removal tool.

add encrypted excel xls file

Step 3: Click "Remove Password" and wait for successfully excel file password remove.

remove excel xls file password

Click Open button on following dialog, and you would be able to successfully open encrypted excel file without password.

successfully remove encrypted excel xls file open password


When you try to open encrypted excel file, after entering open password, probably you would be also prompted to type password for write access. At this moment, just click "Read Only" to ignore it and open encrypted excel file in read-only mode.

open encrypted excel file in read only mode

Section 2: Unlock Excel sheet when Excel file is opening

After encrypted excel file is open, please try to save as the excel file to remove modify password from excel file and you could unlock excel spreadsheet/worksheet.

1. In Save as dialog, click Tools > General Options next to "Save" button.

select to change general options in Excel save as dialog

2. In following General Options dialog, clear password in Password to open and Password to modify. Click OK.

clear password to open and modify excel file

3. Type another name in "File name" field and click Save button to save encrypted excel file as unencrypted one.

save as unencrypted excel file to unlock excel sheet

4. While you open the new excel file you just saved as, you would find you have unlocked encrypted excel spreadsheet because you can open excel file and edit sheet without password.


Above methods just apply to situation when encrypted excel file is just protected with open and modify password. If every spreadsheet is also encrypted with password in excel file, you would need to know the password to unlock encrypted spreadsheet one by one, or you can try VBA to unprotect excel spreadsheet free or could effectively remove forgotten sheet protection password with iSunshare Workbook Unprotect Genius at once after removing open password, otherwise you would not be able to unlock and edit encrypted spreadsheet in excel file.

Related Links:

Hot Categories
Windows Password
iTunes Password
Office Password
More +
Hot Articles
Locked Out of Office Files - How to Open
3 Ways to Remove Word Password
Forgot Excel Workbook 2010/2013/2016 Password | How to Do
How to Unlock Password Protected PowerPoint Presentation
How to Remove Forgotten Password from Access Database
More +
Latest Articles
How to Unprotect Excel Workbook without Password
How to Recover Outlook 2016 PST File Forgotten Password
Office 2016 Password Recovery after Forgot or Lost
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +