Enumerating PivotItems collection fails to display duplicate values
 

I have a PivotTable laid out with 5 RowFields. The 5th RowField
contains some duplicate strings amongst its PivotItems collection.
When I walk all of the PivotItems in a loop statement, the duplicate
strings don't enumerate. So if I had for example, 50 PivotItems and 5
of them were duplicate values of another PivotItem, my loop statement
would only show 45 PivotItems, just the unique strings.

Is there a way to enumerate all 50 PivotItems? There is unique data
within the 1-4 RowFields for each item in the 5th RowField that I have
to enumerate. Maybe my current implementation is the problem? For
each PivotItem I enumerate, I get it's associated
PivotItem.DataRange.Row value and pull data from columns "A", "B", "C",
"D", where those would equate to RowFields 1-4 in my case.

Enumerating PivotItems collection fails to display duplicate values
 

Maybe showing your code would help.

--
Regards,
Tom Ogilvy


"kirk" wrote in message
oups.com...
I have a PivotTable laid out with 5 RowFields. The 5th RowField
contains some duplicate strings amongst its PivotItems collection.
When I walk all of the PivotItems in a loop statement, the duplicate
strings don't enumerate. So if I had for example, 50 PivotItems and 5
of them were duplicate values of another PivotItem, my loop statement
would only show 45 PivotItems, just the unique strings.

Is there a way to enumerate all 50 PivotItems? There is unique data
within the 1-4 RowFields for each item in the 5th RowField that I have
to enumerate. Maybe my current implementation is the problem? For
each PivotItem I enumerate, I get it's associated
PivotItem.DataRange.Row value and pull data from columns "A", "B", "C",
"D", where those would equate to RowFields 1-4 in my case.

Enumerating PivotItems collection fails to display duplicate values
 

Thanks for the follow-up Tom.

I ended up restructuring my code to work successfully. What I did was
obtain the start and end rows of the pivot table, obtain the Excel
column for the data I was previously fetching pivot items from, obtain
the Excel columns for the necessary associated data, then just walk the
range of rows from start to end to perform my business.

Tom Ogilvy wrote:
Maybe showing your code would help.

--
Regards,
Tom Ogilvy


"kirk" wrote in message
oups.com...
I have a PivotTable laid out with 5 RowFields. The 5th RowField
contains some duplicate strings amongst its PivotItems collection.
When I walk all of the PivotItems in a loop statement, the duplicate
strings don't enumerate. So if I had for example, 50 PivotItems and 5
of them were duplicate values of another PivotItem, my loop statement
would only show 45 PivotItems, just the unique strings.

Is there a way to enumerate all 50 PivotItems? There is unique data
within the 1-4 RowFields for each item in the 5th RowField that I have
to enumerate. Maybe my current implementation is the problem? For
each PivotItem I enumerate, I get it's associated
PivotItem.DataRange.Row value and pull data from columns "A", "B", "C",
"D", where those would equate to RowFields 1-4 in my case.