Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any way to programmatically make pivot tables behave more like data tables?
I'm wondering if there's any way to make the data filtering process in
pivot tables behave the same way they do in data tables/lists. In tables/lists when you filter on a column the filter option on the rest of the columns only show the remaining available data - which makes great sense. In pivot tables the filters always show all of the available data regardless of other filtering going on. I hate that - makes it very difficult to filter in on specific sets of data. Any suggestions on adjusting pivot table behavior in that way? I haven't done much VBA with pivot tables so I'm not sure where to start. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any way to programmatically make pivot tables behave more like dat
No, there is no support for this.
-- Regards, Tom Ogilvy "Ferris" wrote: I'm wondering if there's any way to make the data filtering process in pivot tables behave the same way they do in data tables/lists. In tables/lists when you filter on a column the filter option on the rest of the columns only show the remaining available data - which makes great sense. In pivot tables the filters always show all of the available data regardless of other filtering going on. I hate that - makes it very difficult to filter in on specific sets of data. Any suggestions on adjusting pivot table behavior in that way? I haven't done much VBA with pivot tables so I'm not sure where to start. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
(Tom?) Pivot tables, code to refer to all pivot tables on template | Excel Programming | |||
Make 2 Pivot Tables in same items | Excel Programming | |||
Can we make XY Scatter Chart using Pivot Tables | Excel Programming | |||
pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) |