I have a shared workbook where multiple users will be entering data about
clients. Some columns are calculated based on entered data. I locked the
columns that are calculated so they can not be changed, but when I protect
and share the workbook the locked cells no longer have the 'locked' effect.
Format|Cells|Protection the Locked check box is checked.
Can anyone help me with locking cells in a shared workbook?

Thank you!