Permission & Access Issues

Fix Excel Not Prompting for Password on a Protected Workbook

WPS Content Manager Oct 9, 2026 873 views

Question details

The user applied password protection to an Excel workbook, but the file opens directly without prompting for the password.

Fix Excel Not Prompting for Password on a Protected Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to secure an Excel file so that unauthorized users are prompted for a password upon opening.
Observed behavior: The Excel file bypasses the password prompt and opens directly, indicating a possible mismatch between the intended security level and the applied protection type.

Before you start

Verify whether you want to prevent users from opening the file entirely, or if you only want to prevent them from modifying the workbook's structure (like adding or deleting sheets).

Solution 1Recommended

Use 'Encrypt with Password' Instead of 'Protect Workbook'

The 'Protect Workbook' feature secures the structure of the file but does not prevent opening. To force a password prompt upon opening, you must use the 'Encrypt with Password' feature.

Many users confuse structural protection with file encryption. If you want Excel to ask for a password before displaying any data, file encryption is the correct tool.

Access the Info Menu

Open your Excel workbook. Click on the 'File' tab in the top-left corner, then select 'Info' from the left-hand menu.

Select Encrypt with Password

Click the 'Protect Workbook' dropdown button and choose 'Encrypt with Password' from the list of options.

Set the Password

Type your desired password in the prompt box and click 'OK'. Re-enter the password to confirm it, then click 'OK' again.

Save and Test

Save the workbook, close Excel entirely, and reopen the file to verify that the password prompt now appears.

Use 'Encrypt with Password' Instead of 'Protect Workbook'

Password Recovery Warning: Microsoft Excel cannot recover forgotten passwords. Ensure you store your password in a secure password manager.

Solution 2

Check the 'Save As' General Options

Check if a password was accidentally set as 'Password to modify' instead of 'Password to open', which allows the file to be viewed without a prompt.

Solution 3

Test Protection on a Blank Workbook

If the password prompt still fails to appear, your current workbook might be corrupted. Test the behavior on a fresh file.

Secure Spreadsheets with WPS Office

Password Protect Your Spreadsheets Easily with WPS Office

WPS Office Spreadsheet provides an intuitive and straightforward way to encrypt your files. You can quickly set up passwords to open or modify documents without navigating through confusing menus.

1. Open File in WPS Spreadsheet: Launch WPS Office and open the spreadsheet you want to password protect.
2. Access File Encryption: Click on 'Menu' in the top left corner, navigate to 'File', and select 'File Encryption'.
3. Set Password to Open: In the Encryption dialog, type your password into the 'Document password' field and confirm it.
4. Save the Document: Click 'OK' to apply the settings, then save the document. The password prompt will appear the next time it is opened.

Easily apply file encryption to restrict unauthorized access to your data.Fully compatible with Microsoft Excel (.xlsx) formats and standard encryption methods.Clear distinction between read-only passwords and file-opening passwords.Lightweight, fast, and free to use for everyday office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between 'Protect Workbook' and 'Encrypt with Password'?

'Protect Workbook' restricts structural changes, such as adding, deleting, or hiding worksheets, but allows anyone to open and view the file. 'Encrypt with Password' locks the entire file, requiring a password before the contents can be viewed or edited.

Why does my Excel file open as read-only instead of asking for a password?

This happens when a password is only entered into the 'Password to modify' field under the 'Save As' General Options. To prevent users from opening the file at all, the password must be placed in the 'Password to open' field.

Can I recover a forgotten password for an encrypted Excel file?

No, neither Microsoft Excel nor WPS Office offers a built-in password recovery feature for encrypted workbooks. If you lose or forget the password, the data cannot be easily recovered.

Does saving an encrypted file to OneDrive remove the password?

No, saving to OneDrive or SharePoint does not remove the password. However, AutoSave is disabled for encrypted workbooks, meaning you must manually save your changes.

Document & File Issues