Password-Protect an Excel Workbook Before Emailing It
Question details
The user needs to encrypt an Excel workbook so recipients must enter a password before opening an emailed file.

- Product
- Microsoft Excel workbook
- Device & OS
- not provided
- Scenario
- The user wants to send a workbook by email while limiting access to people who know the opening password.
- Observed behavior
- The desired result is that the workbook cannot be opened without the password.
Choose a strong, unique password that you can store securely, because Excel does not provide a built-in method to recover a lost workbook-opening password. Plan to send the password through a separate secure channel, such as a phone call or encrypted messaging app.
Encrypt the Excel workbook with an opening password
Use this method when you need recipients to enter a password before they can open the Excel file.
Workbook encryption protects the file contents when the workbook is saved and shared. It is stronger than worksheet protection, which is intended mainly to restrict editing rather than prevent file access.
Open the workbook you want to email, then select File in the upper-left corner.
Select Info, choose Protect Workbook, and then select Encrypt with Password.
Enter a strong password in the Encrypt Document dialog box, select OK, and enter the same password again to confirm it.
Select File > Save, or press Ctrl+S, to apply the encryption to the workbook.
Attach the saved workbook to your email, but send the password through a separate secure channel rather than in the same email thread.

Use a secure sharing method for highly sensitive workbooks
Use this approach when the workbook contains highly confidential data or when email attachment security is not sufficient for your organization.
Encrypt a Spreadsheet File with a Password in WPS Office
WPS Office lets you encrypt a spreadsheet before sharing it, so authorized recipients must provide the password to open the file. Its familiar spreadsheet interface makes it easy to protect files and continue working with Excel-compatible workbooks.
- 1. Open the spreadsheet in WPS Spreadsheet: Launch WPS Office and open the workbook in WPS Spreadsheet.
- 2. Open encryption settings: Select Menu, choose File, and select Encrypt.
- 3. Set an opening password: Choose Encrypt with Password, enter a strong password, and confirm it when prompted.
- 4. Save the protected workbook: Select Save or press Ctrl+S to save the encrypted spreadsheet file.
- 5. Share credentials separately: Email or share the protected file, then provide its password through a separate secure communication method.

Frequently Asked Questions
Does Excel password protection stop someone from opening the workbook?
Yes. When you use File > Info > Protect Workbook > Encrypt with Password and save the file, Excel requires that password before the workbook can be opened.
Is worksheet protection the same as encrypting an Excel workbook?
No. Review > Protect Sheet primarily limits changes to a worksheet. To require a password before opening the file, use File > Info > Protect Workbook > Encrypt with Password.
What should I do if I forget an Excel workbook password?
Excel has no built-in recovery option for a forgotten workbook-opening password. Store the password in an approved password manager or another secure location before sharing the file.
Should I include the Excel password in the email with the attachment?
No. Send the encrypted workbook by email, then share the password through a separate channel, such as a phone call, secure messaging app, or approved password-sharing tool.
Can an encrypted Excel workbook still be attacked?
No password protection is completely immune to specialized attacks. Use a long, unique password and consider approved secure file-sharing controls for highly sensitive information.




