0
How do you recover the lost password in a protected Excel work sheet?
Wiki User
∙ 12y ago
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.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
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 set a password in an Excel file?
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.
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
How do you unprotect an Excel page?
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 make a result sheet in Excel?
how to create a 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 is the full form of PFA in Excel sheet?
Pfa the excel sheet
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
How do you make a cover sheet in excel?
Add a sheet
How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?
Calculating DSCR in Excel sheet
