The data validation example at Data Validation|Documentation has the following line:
Validation validation = validations[validations.Add(ca)];
However, this doesn’t compile, as there is no ValidationCollection.Add that…...(runnable) code snippet and sample Excel files (you may zip prior attaching...help you to fix it and only alternative would be upgrade to latest...