Microsoft Office Tutorials and References
In Depth Information
Open a Read-Only Version of a Workbook
Chapter 9: Protecting Excel Data
Excel displays a list of
options for opening the
6 Click Open Read-Only.
Excel opens a read-only
copy of the workbook.
Read-Only appears in the
If other people will be opening the workbook, you can add an extra level of safety by
telling Excel to recommend that the file be opened as read-only. Click File, and then
click Save As to open the Save As dialog box. Click Tools and then click General Options
to open the General Options dialog box. Click to select the Read-Only Recommended
check box, click OK, click Save, and then click Yes.
Now, each time someone tries to open the workbook, Excel displays a dialog box asking
the user whether the file should be opened as read-only. The user then clicks Yes to
open the workbook as read-only, or No to open the workbook normally.