Best Answer

Suppose you have to view an important excel sheet data but you have forget the password then you need to do excel password recovery, unfortunately MS excel doesn't offer any option for password recovery. You can try the following steps but it will work in MS excel 2007 only.

1) Change file extension .zip from .xls/xlsx.

2) Extract this zipped file.

3) Go to the extracted files and navigate to the .xml for the target sheet (found in the 'xl\worksheets' directory) like filename.xml

4) Open this .xml file in to xml editor and file and find <sheetProtection password="CC58" sheet="1"/> line and remove it.

5) Now save this file and change extension back to .xlsx from .zip.

You will be able to open your file successfully without any password.

User Avatar

Wiki User

โˆ™ 2011-08-25 09:30:41
This answer is:
User Avatar
Study guides

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

See all cards
27 Reviews

Add your answer:

Earn +20 pts
Q: How do you recover the lost password in a protected Excel work sheet?
Write your answer...
Still have questions?
magnify glass
Related questions

How do you insert a photo in Excel when the sheet is protected?

You do not enter anything into a worksheet that is protected, unless the protection settings allow you to do so. You need to unprotect the sheet, insert the photo, then protect the sheet again. If the protection is locked with a password, then you need to contact the spreadsheet author to get the password. There are many ways to remove the password from an Excel workbook, but I will not discuss that topic here.

How do you copy a protected cell in excel without removing the protection to another excel sheet?

Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.

How do you unlock the Excel sheet without password?

You can't. You need the password to unlock it.

How do you unprotect an Excel worksheet?

In Excel 2007 and newer, click on the Review tab and select Unprotect Sheet. If you see Protect Sheetinstead of Unprotect Sheet, then the worksheet is not password protected.In Excel 2003 and earlier, follow this menu string:Tools --> Protection --> Unprotect SheetIf the worksheet has a password, you will need to enter the password to unprotect the worksheet. If there is no password, just leave the password section blank.

How do you delete password from Excel sheet?

In common with most other computer applications you need to know what the password is before you can remove it. This is to prevent unauthorised alterations.Go to the Tool... Protection... Unprotect sheet menu and a dialog box will appear, in which you have to type the password.You can google 'Excel Password Unlocker' and it will give you many options.It wont give you your old password but make you change it so you can get in.

How do you make a result sheet in Excel?

how to create a excel sheet

Can you have a password on an Excel file?

Yes, you can protect the entire workbook or sheet in different levels according to your need - for example you can protect from changing the data in the workbook and only by entering a password in can be unlock it. To do so {in excel 2010} go to the Review menu and choose Protect workbook or Protect sheet

What is the full form of PFA in Excel sheet?

Pfa the excel sheet

How can you edit an Excel sheet that was emailed to you on your Samsung tablet?

If you have Excel and the file is not protected, then you should be able to work on it. If not, open the e-mail on a computer with Excel or try opening it through something like Google Docs.

What do you mean by Excel sheet?

A new excel document. In Microsoft excel there is a new page button like in word. Click that to get a new excel sheet. It is effectively a page in excel.

Is a Excel work sheet the same as a spread sheet?

Yes. In Excel, a spreadsheet is called a worksheet.

How do you make a cover sheet in excel?

Add a sheet

People also asked