Excel: Add a Password Prompt When Opening or Editing a Workbook
Question details
The user needs to configure an Excel workbook to request a password when it is opened or when someone attempts to edit it.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The workbook owner wants to control editing access while optionally allowing users without the editing password to open the file as read-only.
- Observed behavior
- The workbook needs separate protection options for opening the file and modifying its contents.
Decide whether users should be blocked from opening the workbook entirely or only from editing it. Keep the workbook in a supported format such as .xlsx and choose a password that can be securely shared with authorized editors.
Require a password to modify an Excel workbook
Use this option when people may view the workbook but only authorized users should edit and save changes.
A modification password allows users without the password to open the workbook as read-only. This is different from file encryption, which requires authentication before the workbook can be opened.
In Excel, select File > Save As, then choose More Options if the traditional Save As dialog is not visible.
In the Save As dialog, click the Tools drop-down beside the Save button and select General Options.
Enter a password in the Password to modify box, then click OK.
Re-enter the password when prompted and click Save to apply the protection to the workbook.
Require a password before opening the workbook
Use file encryption when no one should be able to view the workbook without authentication.
Protect Excel-compatible workbooks with WPS Spreadsheet passwords
WPS Spreadsheet can add a password for modifying a workbook or encrypt the file so a password is required before opening it. Its familiar menus support Excel-compatible files while providing a lightweight way to manage workbook access.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, open WPS Spreadsheet, and load the Excel-compatible workbook you want to protect.
- 2. Open Save As options: Select Menu > Save As, then open the traditional Save As dialog and choose Tools > General Options.
- 3. Set the editing password: Enter a password in Password to modify, select OK, confirm the password, and save the workbook.
- 4. Use opening encryption when needed: For stronger protection, open the workbook's password or encryption settings and enter an opening password so authentication is required before the file can be viewed.

Frequently Asked Questions
What is the difference between a password to modify and a password to open?
A password to modify lets users open the workbook as read-only without the password. A password to open, also called encryption, blocks access to the workbook until the correct password is entered.
Where can I find the password-to-modify setting in Excel?
Select File > Save As, open More Options if necessary, choose Tools > General Options in the traditional Save As dialog, and enter the password in Password to modify.
Can someone edit the workbook without the modification password?
They can open it as read-only, but they cannot save changes as the original protected workbook without the password. They may be able to save a separate copy depending on the application and file permissions.
What should I do if I want to prevent anyone from viewing the workbook?
Use file encryption instead of only a modification password. In Excel, select File > Info > Protect Workbook > Encrypt with Password, then enter and confirm the opening password.




