You may need to share an Excel file but want to discourage others from making changes. A standard read-only file can be opened and edited without any warning. The Read-Only Recommended feature prompts users to open the file as read-only, protecting the original data from accidental edits. This article explains how to apply this setting and manage file permissions.
Key Takeaways: Setting Read-Only Recommended in Excel
- File > Save As > Tools > General Options: This menu path opens the dialog where you can set the Read-Only Recommended password.
- Read-Only Recommended checkbox: Enabling this option displays a prompt when the file is opened, suggesting read-only mode.
- Password to modify: Setting this password forces users to enter it for editing rights, providing stronger protection than the recommendation alone.
Understanding the Read-Only Recommended Feature
The Read-Only Recommended setting is a file-level property in Excel. It does not lock the file or prevent editing by force. Instead, it displays a dialog box when someone opens the workbook. This dialog asks if the user wants to open the file as read-only. The user can choose Yes to open in protected view or No to open with full editing capabilities. This makes it a gentle nudge rather than a strict barrier.
This feature is different from marking a file as read-only using Windows File Explorer properties. That Windows setting can often be ignored or overridden. It is also distinct from protecting sheets or the workbook structure with a password. Read-Only Recommended is best for collaborative environments where you trust users but want to prevent mistakes. For mandatory protection, you should use the Password to Modify option in the same dialog.
Prerequisites Before Applying the Setting
You must have the Excel file open and saved at least once. The feature is applied during the save process. Ensure you are using a file format that supports this property, such as .xlsx, .xlsm, or .xls. Older .xls formats also support it. You do not need administrator rights on your computer to set this option. However, to later remove it, you will need access to the original file with editing permissions.
Steps to Save a File with Read-Only Recommended
Follow these steps to add the Read-Only Recommended prompt to your Excel workbook. The process is the same in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016.
- Open your Excel file
Launch the workbook you want to protect from accidental edits. - Click File > Save As
Select the File tab on the ribbon. Then choose Save As from the menu on the left. - Choose a save location
In the Save As dialog, navigate to the folder where you want to save the protected version. You can save it with the same name or a new one. - Click the Tools button
In the bottom-left corner of the Save As dialog, click the small Tools button. A dropdown menu will appear. - Select General Options
Choose General Options from the Tools dropdown menu. This opens the General Options dialog box. - Check Read-Only Recommended
In the General Options dialog, find the checkbox labeled Read-only recommended. Click to place a checkmark in it. - Click OK and then Save
Click OK to close the General Options dialog. Back in the Save As dialog, click the Save button. If you are saving over an existing file, confirm you want to replace it.
Adding a Password to Modify for Stronger Control
If a recommendation is not strong enough, you can require a password for editing. In the same General Options dialog, you will see two password fields.
- Set a Password to modify
In the General Options dialog, type a password into the Password to modify field. Do not fill the Password to open field unless you want to encrypt the entire file. - Confirm the password
A confirmation dialog will appear. Re-enter the exact same password and click OK. This password will be required for anyone to edit the saved file.
Common Mistakes and Limitations to Avoid
The Read-Only Prompt Does Not Appear for Me
If the prompt does not show, the user may have disabled alerts. In Excel, go to File > Options > Trust Center > Trust Center Settings > Protected View. Ensure the option Enable Protected View for files originating from the Internet is checked. Also, the prompt will not appear if the file is opened from within a macro or script that suppresses dialogs.
Users Can Still Save Over the Original File
Read-Only Recommended does not prevent saving. A user who opens the file as read-only can still save a copy with a different name. However, if they ignore the prompt and open in edit mode, they can directly overwrite the original file when saving. To prevent this, use the Password to modify setting or store the original file in a restricted folder.
How to Remove the Read-Only Recommended Setting
You must open the file with editing permissions. Follow the same steps to open the General Options dialog via File > Save As > Tools. Uncheck the Read-only recommended checkbox. If a Password to modify is set, you must enter it to make this change. Then save the file. The prompt will no longer appear for future opens.
Read-Only Recommended vs. Password to Modify: Key Differences
| Item | Read-Only Recommended | Password to Modify |
|---|---|---|
| User Experience | Shows a suggestion dialog when opening | Requires a password to edit; opens as read-only without it |
| Protection Level | Advisory and optional | Enforced and mandatory |
| Best Use Case | Collaborative review, preventing honest mistakes | Distributing templates or final reports |
| Recovery if Forgotten | Setting can be removed without a password | File cannot be edited without the password; data may be lost |
| Impact on File Opening | No delay if user clicks Read Only | Delay for password entry each time |
You can now protect your Excel files from unintended changes using the Read-Only Recommended prompt. For stronger security, combine it with the Password to modify feature in the General Options dialog. Remember that this setting travels with the file itself, no matter where it is emailed or copied. An advanced tip is to use the Protect Workbook feature under the Review tab to restrict structural changes like adding or deleting sheets.