Question

The use of cell protection for spreadsheets and write-protect tabs for storage devices only partially provides read-only access. That is, knowledgeable users can "turn off" the cell protection and write-protect functions. Why, then, would you want to use these two features if they can be bypassed? (Excel)

Answer 1

Cell protection in a spreadsheet helps in preventing accidental or intentional changes to data by the viewer of a document. It also helps several people collaborate over cloud by granting access to specific cells in a spreadsheet to specific users and preventing other users editing those cells. The write-protect on security tab of a folder or a storage devices similarly helps in granting various access privileges to users of those devices to prevent accidental or intentional modifications to the documents or files.