I’ve been sent a password protected Excel file through my e-mail as an attachment. I have the password but the file has refused to open. The message from the system is always “wrong password”. the password is six (6) lettered.
1.Create Gmail account. (If you don't have one!)
2.Login to your Gmail account.
3.Go to Google Drive.
4. Click on create. Click on spreadsheet.
5.Now in Google Sheets click on file>import>upload.
Google Drive automatically allows you to make changes and saves the file
6. Download the file as an 'Excel' file
7. It is saved as an 'xlsx'.
8. We can now 're-save' the file using our Excel 2007.
9. Work done!
*If nothing works then ask them to resend it. *
The error message is quite literal: Somewhere somehow the password is wrong.
Maybe wrong capitalization, maybe mistyped, if you haven't written it down maybe remember it wrong by one word or letter or number.
Since you got the file via email I assume the password was set by someone else so this person could have done the very same mistake(s). Remembered it wrong, forgot capitalization etc.
There are way too much options here where things can go wrong to "ignore" the error message and move on to troubleshooting Excel.
How to Unprotect an excel sheet without password
Crack Sheet Protection Password
well ask them to send you again the file maybe to rar it first, you can then extract excel and use the password to open it.