How to force to open as read only in Excel?
Sometimes, you want users who open your shared workbooks to be cautious before editing them. You can display a read-only prompt to warn them, as shown in the screenshot below.
Make a read-only prompt when open by clicking an option
Make a read-only prompt when open by Save As
Note: the methods provided in this tutorial are tested in Excel 2021, there may be some differences in different Excel versions.
Click "File" > "Info" > "Protect Workbook" > "Always Open Read-Only".
1. Click "File" > "Save As", and choose a location to place the new read-only file.
2. In the "Save As" window, after specifying the location, click "Tools" > "General Options".
3. In the "General Options" dialog, tick "Read-only" recommended. Click "OK" > "Save".
Tip: Click "Yes", if there is no change in the workbook, it can be saved, if there are changes, it will be saved as a new file when clicking Save. Click "No", users can do an edition in the workbook.
Other Operations (Articles)
How To Auto Update Exchange Rate In Excel?
If you are working in a financial enterprise, sometimes, you may use Excel worksheet to list all different currencies and convert them based on the exchange rates.
How To Calculate With Rounded Values In Excel?
Here in this tutorial, it tells you the method to always calculate with the rounded values in Excel.
How To Auto Complete Cells From Another Table
In this tutorial, it is talking about how to auto complete other column cells from a table in another sheet after entering one column value.
How to apply shading to odd or even (alternative) rows/columns in Excel?
While designing a worksheet, many people tend to apply shading to odd or even (alternative) rows or columns in order to make the worksheet more visual. This article will show you two methods to apply shading to odd or even rows/columns in Excel.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!