How to Fix Excel Read-Only or Password Prompt Not Appearing
Question details
The user needs to restore the 'Open as read-only or enter password' prompt that previously appeared when opening a specific workbook.

- 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.
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.
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.
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.
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.
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.
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.

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. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet you want to protect.
- 2. Navigate to Document Encryption: Go to the 'Menu' tab at the top left, hover over 'Document Encryption', and click on 'Encryption'.
- 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. 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.

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.




