How to Unlock Excel Sheets Without a Password. 7:36 am March 31, ... Identify the XML file corresponding to the protected sheet and open it in a text editor such as Notepad.

First of all, open the input Excel file in which you want to lock formulas using the File > Open option. 2] Unlock all the cells using the Format Cells feature Now, you need to make sure that all ...