Hi all,

I have a dedicated "data selection" pivot table on one of my sheets.
The user is free to move the fields into the rows, columns and report
filter. After the user has set up the fields the way he likes, and
after he has applied all filters he needs, I need to capture the total
filtering on the fields in order to apply it to the other pivot tables
in the same workbook. I want to do this by looking which items are /
aren't displayed in this "data selection" pivot.

And here comes the question: I already found out that I cannot simply
use PivotField.HiddenItems, since that won't work for page fields. I
therefore just loop through all fields and items and inspect their
PivotItem.Visible property, but now I find out this doesn't work for
label filters - it only returns if the item is manually selected
(ticked) / deselected in the field item list.

What options do I have? I know I can use PivotTable.ActiveFilters to
look what label filters have been applied, but I cannot seem to get how
they have been processed on the item list itself.

--
Kind regards,
Carl Colijn

TwoLogs - IT Services and Product Development
A natural choice!
http://www.twologs.com
TimeTraces: the powerful and versatile time registration system!
http://timetraces.twologs.com