You have an Excel file you need to share, but you want to prevent others from changing the data or formulas. You need a way to let people open and view the workbook while blocking any edits. This is done by setting a write or modify password in Excel. This article explains how to apply this protection and what it does to your file.
Key Takeaways: Protecting an Excel File from Editing
- File > Save As > Tools > General Options: This menu is where you set the password to modify, which allows read-only opening.
- Password to open vs. Password to modify: The first encrypts the file, while the second only restricts editing unless the correct password is entered.
- Read-Only Recommended checkbox: This setting prompts users to open the file as read-only but does not enforce it with a password.
Understanding Excel’s Password to Modify Feature
Excel provides two distinct password layers for file security. A password to open encrypts the entire file, requiring a password just to view its contents. The feature covered here is the password to modify, also called a write password. This protection does not encrypt the file. Anyone can open the workbook, but they cannot save changes to the original file name unless they provide the correct password.
When a user opens a file with this protection, Excel displays a password dialog box. They can click Read Only to view the file or enter the password to gain editing rights. If they open as read-only, any changes they make must be saved with a different file name, preserving your original document. This is ideal for distributing reports, templates, or data sets where viewing is necessary but controlled editing is required.
Prerequisites for Setting a Password
You must have full editing access to the file you want to protect. The feature is available in all modern versions of Excel for Windows and Mac. Ensure you save a backup copy of your file before applying any password. If you lose the modify password, you cannot remove the protection without specialized software, as it is not stored within the file in a recoverable way.
Steps to Apply a Password to Modify
Use the Save As dialog to configure file-level passwords. This method applies protection to the entire workbook structure and contents.
- Open your Excel file
Launch the workbook you want to protect. Make any final edits before proceeding. - Go to File > Save As
Click File on the ribbon, then select Save As. Choose the location where you want to save the protected version. - Click the Tools button
In the Save As dialog box, look for a Tools button next to the Save button. Click it and select General Options from the dropdown menu. - Enter the modify password
A General Options dialog box will appear. Leave the Password to open field blank. Type your desired password into the Password to modify field. - Confirm the password
Click OK. A Confirm Password dialog will prompt you to reenter the password to modify. Type it again and click OK. - Save the protected file
Back in the Save As dialog, click Save. If you are saving over the original file, confirm you want to replace it. The write protection is now active.
Using the Read-Only Recommended Option
For a softer approach, you can suggest read-only mode without a password. In the General Options dialog, check the Read-only recommended box. When users open the file, Excel will ask if they want to open it as read-only. They can choose No to open it with full editing rights, so this does not enforce protection.
Common Mistakes and Limitations to Avoid
Confusing Workbook and Worksheet Protection
The password to modify is a file-level setting. It is different from protecting specific worksheets with Review > Protect Sheet. Worksheet protection locks cells within a sheet but does not prevent users from saving the entire file. For comprehensive security, you might use both file-level and worksheet-level passwords.
Losing the Modify Password
Microsoft does not provide a way to recover a lost password to modify. If you forget it, you will only be able to open future copies as read-only. Always keep an unprotected master copy in a secure location or use a trusted password manager.
Password Protection in Shared Workbooks
The legacy Shared Workbook feature is incompatible with file-level passwords. You cannot set a password to modify on a file enabled for sharing via Review > Share Workbook. You must first stop sharing the workbook before applying the password.
Password to Open vs. Password to Modify
| Item | Password to Open | Password to Modify |
|---|---|---|
| Primary Purpose | Encrypts the file to block viewing | Allows viewing but blocks editing and overwriting |
| File Encryption | Yes, uses strong encryption | No, the file content is not scrambled |
| User Experience | Password prompt appears before the file opens | Password prompt appears after the file opens, with a Read Only option |
| Use Case | Confidential or sensitive data | Distributing templates, reports, or reference data |
| Recovery Option | Extremely difficult without the password | Changes can be saved with a new file name |
You can now distribute Excel files confidently, knowing the data cannot be altered without permission. Remember that the password to modify does not encrypt the file’s contents. For stronger security, combine it with worksheet protection for specific cells. A useful advanced tip is to use the General Options dialog to set both a password to open and a different password to modify, creating two separate access levels for your file.