How to unlock password protected sheets in OpenOffice Calc?
To unlock the password protected sheet in a spreadsheet file do the following.
Step 1: Keep the password protected sheet as active sheet.
Step 2: Click Tools tab and select Protect Document -> "Sheet..."
Step 3: Unprotect sheet dialog box opens. Type the password under Password field and click OK.
Now the sheet will be unprotected and it wont ask for the password next time.