limiting page values in a pivot table

kjpastorek · Mar 4th, 2002, 03:38 PM

I have some data that I allow users to page by 3 hierarchies in a pivot table. When a selection is made in the first hierarchy, it limits the valid values available in the second hierarchy. But, I cannot figure out how to force it to limit the values shown in the drop down box. Do I need a macro to do this? Does anyone have an example I could look at and copy?

Thanks,
Kelly

Mark W. · Mar 5th, 2002, 08:21 AM

This can't be done in a PivotTable. Fields "remember" all items in their domain -- even those that have been subsequently removed from the data source.

[ This Message was edited by: Mark W. on 2002-03-05 07:21 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 03:38 PM	#1
kjpastorek New Member Join Date: Mar 2002 Posts: 1	I have some data that I allow users to page by 3 hierarchies in a pivot table. When a selection is made in the first hierarchy, it limits the valid values available in the second hierarchy. But, I cannot figure out how to force it to limit the values shown in the drop down box. Do I need a macro to do this? Does anyone have an example I could look at and copy? Thanks, Kelly

Mar 5th, 2002, 08:21 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	This can't be done in a PivotTable. Fields "remember" all items in their domain -- even those that have been subsequently removed from the data source. [ This Message was edited by: Mark W. on 2002-03-05 07:21 ]