Monday 24 May 2010

how to unprotect excel worksheet without knowing the PASSWORD.

 

I discover this during my attempts to get solution from the www.  There is a shortcut to this.

 

people likes to be protective, and that’s why they like to protect worksheet with password.  And sometimes, they didn’t realize that other people just need to get the content and to check it against another file.  

 

Here’s the excel error: The cell or chart you are trying to change is protected and therefore read-only.  To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu).  You may be prompted for a password.

 

So what now, there is no way you can do so except knowing the password?

 

No! Where there’s a will there’s a way.

 

The solution is as simple as A-B-C. You just need to save the excel file as an older version eg. Microsoft Excel 4.0 Worksheet (*.xls)

 

This is indeed useful to me.  Hurray, now I know how to hack into the password protected worksheet, now I think it’s good to start explore how to open a protected excel file.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...