Permission & Access Issues

Excel: Add a Password Prompt When Opening or Editing a Workbook

Rana GarciaRana Garcia Nov 12, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Save As

In Excel, select File > Save As, then choose More Options if the traditional Save As dialog is not visible.

2
Open General Options

In the Save As dialog, click the Tools drop-down beside the Save button and select General Options.

3
Set the modification password

Enter a password in the Password to modify box, then click OK.

4
Confirm and save

Re-enter the password when prompted and click Save to apply the protection to the workbook.

Read-only access remains available: Users who do not know the modification password can still open the workbook as read-only, depending on the file format and application.

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. 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, open WPS Spreadsheet, and load the Excel-compatible workbook you want to protect.
  2. 2. Open Save As options: Select Menu > Save As, then open the traditional Save As dialog and choose Tools > General Options.
  3. 3. Set the editing password: Enter a password in Password to modify, select OK, confirm the password, and save the workbook.
  4. 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.
Set a password to restrict workbook editing while allowing read-only access.Encrypt a workbook so users must enter a password before opening it.Use a familiar spreadsheet interface with support for Microsoft Excel .xlsx files.Edit and save protected workbooks with a lightweight Office-compatible application.
microsoft office alternative - wps office

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.