Office Settings & Configuration

How to Fix Excel Read-Only or Password Prompt Not Appearing

Steven ParkerSteven Parker Oct 19, 2026 875 views

Question details

The user needs to restore the 'Open as read-only or enter password' prompt that previously appeared when opening a specific workbook.

How to Fix Excel Read-Only or Password Prompt Not Appearing
Product
Excel / WPS Spreadsheet
Device & OS
not provided
Scenario
Opening a shared or protected spreadsheet that is intended to prompt users for a password to modify or offer a read-only viewing option.
Observed behavior
The prompt no longer appears when opening the workbook, and the file opens directly, indicating that the document's password protection or read-only recommendation settings were accidentally removed or disabled.
Before you start

Ensure you have the correct password for the workbook (if it is currently locked) and that you have full edit permissions, as you will need to re-save the file to apply new security settings.

Solution 1Recommended

Reconfigure General Options in the Save As Dialog

Re-apply the 'Password to modify' and 'Read-only recommended' settings through the Save As dialog to restore the prompt on startup.

The read-only and password-to-modify prompts are controlled by the workbook's General Options. If a user previously saved the file and cleared these settings, the prompt will stop appearing. You must manually re-enable them.

1
Open the Save As Dialog

Open your workbook. Click on 'File' in the top-left corner, select 'Save As', and choose a location on your computer to save the file.

2
Access General Options

In the Save As dialog box, look for the 'Tools' drop-down menu (usually located near the 'Save' button at the bottom) and click it. Select 'General Options' from the list.

3
Set Password and Read-Only Recommendation

In the General Options window, check the box that says 'Read-only recommended'. To strictly enforce the prompt, type a password into the 'Password to modify' field.

4
Confirm and Save

Click 'OK'. If you entered a password, you will be asked to re-enter it to confirm. Click 'OK' again, and then click 'Save' to overwrite the existing file or save it as a new copy.

Reconfigure General Options in the Save As Dialog
Password Recovery Warning: Keep your password in a secure place. If you forget the 'Password to modify', you and other users will only be able to open the workbook in read-only mode and cannot save changes directly to the original file.
Secure Your Spreadsheets with WPS Office

Easily Manage Workbook Passwords with WPS Spreadsheet

WPS Office provides a highly intuitive interface to manage workbook encryption, set passwords to modify, and enforce read-only recommendations, ensuring your data remains secure and behaves exactly as expected.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet you want to protect.
  2. 2. Navigate to Document Encryption: Go to the 'Menu' tab at the top left, hover over 'Document Encryption', and click on 'Encryption'.
  3. 3. Set the modifying password: In the Encryption dialog box, enter your desired password in the 'Password to modify' field and check the 'Read-only recommended' box if you want to offer a read-only viewing option.
  4. 4. Confirm and Save: Click 'OK', confirm your password when prompted, and save the document. The read-only and password prompt will now appear the next time the file is opened.
Set 'Password to open' and 'Password to modify' with just a few clicksFully compatible with Microsoft Excel (.xlsx) password protection and security settingsLightweight, fast, and free to use for daily spreadsheet managementBuilt-in document encryption for enhanced data security
microsoft office alternative - wps office

Frequently Asked Questions

Why did the password prompt disappear in the first place?

The prompt usually disappears if a user with modifying privileges used the 'Save As' function and accidentally cleared the 'Password to modify' field or unchecked the 'Read-only recommended' option before saving.

What is the difference between 'Password to open' and 'Password to modify'?

'Password to open' prevents anyone from viewing the workbook's contents without the password. 'Password to modify' allows users to open and view the workbook as read-only without a password, but requires the password to save changes back to the original file.

Can I remove the read-only prompt later if I change my mind?

Yes. Simply go back to 'File' > 'Save As' > 'Tools' > 'General Options', clear any text from the 'Password to modify' field, uncheck 'Read-only recommended', and click 'Save'.

Does this setting apply to all users opening the shared file?

Yes, once the file is saved with 'Read-only recommended' or a 'Password to modify', anyone who opens that specific file—regardless of the device or compatible spreadsheet software they use—will encounter the prompt.