Validating Data in Template Sheet

Nov 6, 2013 at 1:03 PM

I have a manually created Excel sheet that has a number of drop down lists in it, with the set of drop down values being defined on a hidden sheet. There are data validations set up on the appropriate fields so that the user gets a prompt if attempting to enter invalid values manually in Excel.

Using EPPlus, I am populating some of these values, however nothing seem to prevent me from entering values that are not available in the drop down list.

Is there some way of running the validation on the worksheet and getting back all the fields (and error messages) that are causing validation errors?

Thanks in advance,