Data Protection Issues

Password-Protect an Excel Workbook Before Emailing It

Algirdas JasaitisAlgirdas Jasaitis Nov 12, 2026 870 views

Question details

The user needs to encrypt an Excel workbook so recipients must enter a password before opening an emailed file.

Password-Protect an Excel Workbook Before Emailing It
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in Excel

Open the workbook you want to email, then select File in the upper-left corner.

2
Open workbook protection options

Select Info, choose Protect Workbook, and then select Encrypt with Password.

3
Create the opening password

Enter a strong password in the Encrypt Document dialog box, select OK, and enter the same password again to confirm it.

4
Save the encrypted file

Select File > Save, or press Ctrl+S, to apply the encryption to the workbook.

5
Send the file and password separately

Attach the saved workbook to your email, but send the password through a separate secure channel rather than in the same email thread.

Encrypt the Excel workbook with an opening password
Password recovery is not built in: If you forget the workbook-opening password, Excel cannot recover it for you. Encryption can also be subject to specialized password-cracking attacks, especially when a weak password is used.
WPS Office spreadsheet protection

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. 1. Open the spreadsheet in WPS Spreadsheet: Launch WPS Office and open the workbook in WPS Spreadsheet.
  2. 2. Open encryption settings: Select Menu, choose File, and select Encrypt.
  3. 3. Set an opening password: Choose Encrypt with Password, enter a strong password, and confirm it when prompted.
  4. 4. Save the protected workbook: Select Save or press Ctrl+S to save the encrypted spreadsheet file.
  5. 5. Share credentials separately: Email or share the protected file, then provide its password through a separate secure communication method.
Password-encrypt spreadsheet files before emailing or sharing them.Use a familiar, lightweight spreadsheet interface for file protection tasks.Open and save Microsoft Excel .xlsx and .xls files with strong format compatibility.Share protected spreadsheet files while keeping the password in a separate secure channel.
QA img-9

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.