We have an issue with a user here that has many spreadsheets that are locked for editing by that user only. All of a sudden today, he is unable to unlock the sheets. We've tried the usual is cap locks on, blank password e.t.c. but nothing unlocks the sheets. Also, he has the password documented in a password file so more than likely is entering correctly.
Is there a software program for Excel 2007 that helps retrieve or reset spreadsheets are password protected? Maybe another method of retrieving or resetting the password on these sheets? 500 points for best answer as I need this sorted as high priority. Thanks.