'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Make an Excel 365 Workbook Read-Only Without an Open Password
Question details
The user wants to configure an Excel 365 workbook so that it opens in read-only mode for most users, requiring a password only if they wish to modify the file.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Sharing a workbook where the author needs to prevent unauthorized edits but wants to allow seamless open access for viewing purposes.
- Observed behavior
- The user needs to set up a modification password so that unauthorized users are prompted to open the file as read-only instead of being blocked entirely by an open password.
Ensure you have decided on a strong, memorable password, as forgotten modification passwords cannot be recovered by Excel, meaning you could permanently lose editing access to your original file.
Set a Password to Modify via Save As General Options
This is the standard method in Excel 365 to allow users to view a workbook without a password, while restricting their ability to save changes to the original file.
By setting a 'Password to modify', anyone who opens the file will be greeted with a prompt. They can either enter the password to gain full editing rights or click 'Read Only' to view the file without making changes to the original document.
With your workbook open in Excel 365, click on the 'File' tab in the top left corner, then select 'Save As' from the left sidebar.
Choose your save location. In the Save As dialog box that appears, click the 'Tools' dropdown button located near the 'Save' button, and select 'General Options'.
Leave the 'Password to open' field completely blank. Type your chosen password into the 'Password to modify' field. You can also check the 'Read-only recommended' box if you want users to be encouraged to open as read-only.
Click 'OK'. Excel will prompt you to re-enter the modification password to confirm it. Enter it again, click 'OK', and then click 'Save' to finalize your workbook settings.
Easily Set Read-Only Restrictions in WPS Office
You can quickly protect your worksheets from unauthorized edits while keeping them accessible for viewing using WPS Office Spreadsheet, a powerful and free alternative.
- 1. Open your Spreadsheet: Launch WPS Office and open the spreadsheet you want to restrict.
- 2. Navigate to Save As: Click the 'Menu' button in the top left corner and select 'Save As'.
- 3. Access Encryption Settings: In the Save As dialog box, click on the 'Encrypt' button located near the bottom.
- 4. Set the Modification Password: In the Encryption dialog, leave the 'Document Password' blank and enter your secure password into the 'Password to modify' field, then click 'OK' and save.
Frequently Asked Questions
Can a user save changes if they open the file in read-only mode?
Yes, a user can make changes to the data while viewing, but they cannot save those changes to the original file. If they try to save, Excel will prompt them to use 'Save As' to create a new, separate copy of the workbook.
What is the difference between 'Password to open' and 'Password to modify'?
A 'Password to open' completely blocks access to the file; nobody can even view the data without it. A 'Password to modify' allows anyone to open and view the file in read-only mode, but restricts them from overwriting the original file unless they know the password.
How do I remove the read-only modification password later?
To remove the restriction, open the file using your modification password. Go to File > Save As, click Tools > General Options, delete the password from the 'Password to modify' field so it is completely blank, click OK, and save the file over the existing one.
Does 'Protect Sheet' make the whole file read-only?
No, 'Protect Sheet' only locks specific cells or elements on a single worksheet to prevent editing. Users can still save the file. To make the entire workbook prompt for read-only access upon opening, you must set a modification password in the Save As options.
