Tag Archives: Protecting

Excel – Restricting editing in worksheets and workbooks

SharynAvatarBlog120x120There may be times when you have created a single worksheet or an entire workbook containing data that you do not want other users to be able to change.

By protecting a selection of cells, the entire worksheet or workbook you can feel confident you have minimised the risk of this happening. Continue reading Excel – Restricting editing in worksheets and workbooks

Don’t be fooled – protecting isn’t bullet-proof

SharynAvatarBlog120x120When I’m asked to teach a class on how to restrict editing within a document, the first 5 minutes of my instruction is usually spent explaining that protecting isn’t bullet-proof.

Why do I do this?  Because I have met so many people who assume that restricting the editing of a document by adding a password is in fact securing it so that only the holder or holders of the password can access the file.  Not true!  Via the Internet you can easily access a multitude of work-arounds that coach you through how to easily access the content of a restricted file. Continue reading Don’t be fooled – protecting isn’t bullet-proof