Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel Server » PivotTables » Data Validation   (RSS)
Sorry, but there are no more tags available to filter with.

Example file for PivotTable / Data Validation Trick

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

A PivotTable Trick That Brings Data Validation to Excel Services

Today's author: Dany Hoter, a product planner who works on the Excel Services team. 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
 
Page view tracker