Data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-2370084%22%20slang%3D%22en-US%22%3EData%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370084%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20set%20some%20data%20validation%20rules%20in%20an%20excel%20sheet%20to%20allow%20only%20numbers%20to%20be%20entered%20in%20certain%20cells.%20As%20they%20read%20across%20a%20number%20of%20formulas%20it%20is%20important%20that%20these%20are%20adhered%20to.%3C%2FP%3E%3CP%3EAs%20the%20file%20is%20used%20by%20numerous%20people%2C%20t%3CSPAN%3Ehe%20sheet%20is%20locked%20and%20password%20protected%20to%20prevent%20any%20form%20of%20incorrect%20entry%20in%20any%20locked%20cells%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20however%20found%2C%20much%20to%20my%20surprise%2C%20that%20the%20validation%20rules%20in%20the%20open%20cells%20have%20very%20easily%20been%20circumvented%20by%20a%20user%20who%20simply%20copied%20%26amp%3B%20pasted%20an%20incorrect%20form%20of%20information%20from%20their%20own%20blank%20sheet%20into%20the%20validated%20cells.%3C%2FP%3E%3CP%3EHas%20anyone%20come%20across%20this%20before%20and%20maybe%20found%20a%20way%20to%20prevent%20this%20from%20happening.%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20simple%20example%20sheet%20is%20attached%2C%20locked%20with%20no%20password.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2370084%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have set some data validation rules in an excel sheet to allow only numbers to be entered in certain cells. As they read across a number of formulas it is important that these are adhered to.

As the file is used by numerous people, the sheet is locked and password protected to prevent any form of incorrect entry in any locked cells, 

I have however found, much to my surprise, that the validation rules in the open cells have very easily been circumvented by a user who simply copied & pasted an incorrect form of information from their own blank sheet into the validated cells.

Has anyone come across this before and maybe found a way to prevent this from happening. 

An simple example sheet is attached, locked with no password.

0 Replies