-
Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for our readers. Here's a short description of...
-
Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options for validating data entry. The most popular is probably validating against a list of values. The list can be included in the validation...