If you have a file that is sensitive to changes, you can force Microsoft Excel 2019, 2016, or 365 to prompt the user to open as Read Only whenever they attempt to open the file. Here’s how to enable this setting.
- In Excel, select “File” and click Save As.
- Excel 2019 users, select “Browse“. Excel 2016 users select “More options…“.
- Choose “Tools” > “General Options” at the bottom of the window.
- Select the check-box for “Read-only recommended“, then select “OK“.
- Select “Save“.
- If prompted, choose “Yes” to update the file with the read-only setting.
That’s it! Anybody who opens the file in Excel will now be prompted to choose “Open as Read-Only“.
Markus says
April 21, 2019 at 6:20 pmThank you for this straightforward explanation.
John C. says
January 18, 2019 at 12:49 pmWorks the same for Excel 2013
Issac says
January 8, 2019 at 11:24 pmIf I want to remove the pop up message how do I go about removing it,
Tom Bates says
December 10, 2018 at 1:51 pmNice. Piece of cake once you know where to find it. :-)
Jon says
December 5, 2018 at 7:49 amTHANK YOU for this simple explanation! It’s amazing how difficult it was to find this simple answer anywhere else. VERY helpful, thanks again!