Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » PivotTables » Excel Server   (RSS)

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