N/APosted on - 08/26/2016
Hi. I have recently started using MS-Excel. I had put up a password on my Excel worksheet but I don’t really know how to remove it now. How to open an Excel file that is password protected? Please reply ASAP. Thanks in advance.
How To Open An Excel File That Is Password Protected.
Hi. To learn how to open an Excel file that is password protected, first find the password protected Excel worksheet on your PC. Click on view and then mark the option next to file name extensions in the Explorer window. A .xlsx extension will appear for your file. Next, this .xlsx extension needs to be changed to zip. As soon as the extension is changed, a warning that the file will become unusable will be given by Windows and you need to click on continue to proceed with the procedure. After this, the zip file needs to be right-clicked and then you need to select the option of extracting all the files because of which a new folder will get created in the current location with the name as that of the Excel file. Next, click on the xl folder to open it and then the worksheets folder. All the sheets contained in the document will be displayed. Then, the worksheet which is locked needs to be right-clicked on and then edited.
Then, search for sheetProtection in the find window. Everything that appears within the brackets need to be selected and saved in a notepad file and closed. Copy the edited file and then double-click on the zip file to open it. Then, open the folder named xl and then the worksheets folder to find all the original worksheets present there. Paste the file which has been edited by you so as to overwrite the current file. Rename the zip file back to the Excel file extension. Now, open the worksheet and start working on it without using a password.
Hope we helped.