Home > Resources > Office Password > Remove Forgotten Password from Excel Files

How to Remove Forgotten Password from Excel Files (XLS/XLSX)

As is known, our excel file can be protected with different kinds of passwords, such as open password, modify password (read-only password), workbook protection password, sheet protection password, shared workbook protection password and VBA protection password etc.

On one hand, all of them help to keep our excel files safe, because everyone who wants to open and edit the file needs to input relevant password. On the other hand, it's so hard to keep so many passwords in mind all the time that even the owers who forgot excel password won't do anything on the password protected excel file.

Therefore, this article will show several common ways that we can use to remove forgotten excel file password. In purpose of quickly finding out related methods to your problems, it will be discussed in three parts.

  1. Part 1: Remove forgotten open password from excel file
  2. Part 2: Remove forgotten modify password from excel file
  3. Part 2: Remove forgotten sheet/workbook password from excel file

forgot excel file password

Part 1: Remove forgotten open password from Excel file

Excel file has two types, *.xls and *.xlsx. In order to remove forgotten open password from excel file effectively, let’s discuss it separately in two cases based on the excel file format.

Case 1: Remove Excel XLS file forgotten open password

If it is excel xls file you want to remove open password, it would be easy to do with help of iSunshare Excel Password Remover, which could directly remove open password from xls file with one click on "Remove Password" button.

remove forgotten open password from excel xls file

Case 2: Remove forgotten open password from Excel XLSX file

If it is excel xlsx file forgot open password, get iSunshare Excel Password Genius instead of above password removal tool, to recover forgotten excel file open password at first. And then you can remove it anytime.

recover excel xlsx file forgotten password

Copy the password to open excel file in MS Excel. Then try to remove Excel XLSX file open password in MS Excel 2016/2013/2010/2007/2003 etc.

open excel xlsx file with recovered password

While excel file is only protected with open password, how to remove after password recovery?

1. Click File > Info > Protect Workbook > Encrypt with Password in MS Excel after opening excel file. (Eg. Excel 2010)

2. Clear password on pop-up "Encrypt Document" dialog. Click OK and save changes to remove open password from excel file.

remove open password from excel xlsx file

While Excel file is also protected with read-only password, how to do?

Click "Read Only" button in following pop-up dialog when you are trying to open excel file, in order to open it in read-only mode temporarily and remove open and modify password from xlsx file then in "Save as" dialog.

open excel xlsx file in read-only mode

1. Click OK on pop-up dialog while you try to save excel file after removing open password.

save changes after removing open password

2. In Save as dialog, type a new name in "File name" field and click "Save" button to successfully remove excel open password.

remove forgotten open and modify password by save as a copy

 

Part 2: Remove forgotten modify password from excel file

Surely if you have directly removed Excel XLS file open password and opened it in MS Excel, you can try to save the excel file as new one to remove modify or read-only password. Steps as below:

1. Click File > Save As.

2. In Save as dialog, click "Tools > General Options" and remove password in "Password to modify" box, or uncheck "Read-only recommended".

3. Click OK to save changes and save excel file with a new name.

From then on, please take new excel file instead of original password protected one to use.

 

Part 3: Remove forgotten sheet/workbook password from excel file

Are you still confused with protected sheet and workbook after removing open and modify password? Don’t be anxious and take iSunshare Workbook Unprotect Genius in hand. Then not only protection password on sheet and workbook structure/windows, but also read-only password can be removed at the same time. You will be able to insert, delete, rename, move, copy, hide or unhide worksheets, and change windows size or position in Excel file.

Step 1: Get iSunshare Workbook Unprotect Genius full version.

run workbook password removal tool

Step 2: Run it and import password protected excel file.

Before importing excel file into Workbook Unprotect Genius, something is necessary to be paid attention.

Case 1: If it is XLS file you have removed open password with Excel Password Remover, it should be converted to *.xlsx file firstly, because only *.xlsx file is available by default. And then you can successfully import excel file into Workbook Unprotect Genius.

change excel file name extensions to xlsx

import excel file

Case 2: If it is XLSX file you have recovered open password with Excel Password Genius, you have to remove open password and modify password at first in MS Excel. Then add the copy of excel xlsx file to Workbook Unprotect Genius.

add protected excel xlsx file

Step 3: Click "Remove Password" button to remove workbook/sheet protection password.

In case 1, you would see Sheet protection password, Read only password and Workbook protection password would be removed after you tap on "Remove Password" button.

remove forgotten excel file password

In case 2, you would see only Sheet protected password and Workbook protected password are removed, because read-only password has been removed while you clear excel file open password in MS Excel.

remove excel xlsx file forgotten password on sheet and workbook

Note: Above introductions have could help you to remove forgotten password from excel files. But if you find your excel file has another protection password, I think you would need to find other ways.

Related Articles:

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 +