Tuesday, February 19, 2013

How to edit protected Excel Sheet using Gnuneric.

I am getting an MIS Report every day in Microsoft Excel. Although there is no need to change the contents of the file I clicked out of curiosity on one of the cells and found that I could not read the formula. When I right clicked on Sheet Tab I found the sheet protected with a password.

Since I use Libreoffice I searched about how to crack the password and found a couple of lengthy solutions.

I also keep Gnumeric on my machine. I opened the file in Gnumeric, right clicked on Sheet Tab, selected Manage Sheets and clicked on Lock icon. I was surprised to find that the lock opened without any password. After saving I could edit that file in Libreoffice.

I suppose this is possible in Gnumeric on Windows as well.

Gnumeric is a fantastic software.
Post a Comment