The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.
A PivotTable Trick That Brings Data Validation to Excel Services
Example file
Summary: Using a common car insurance questionnaire, shows an alternative way to validate data by using a PivotTable report filter, and provides an example file to download.