Enumerating PivotItems collection fails to display duplicate values

[kirk]

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.

 

[Tom Ogilvy]

Maybe showing your code would help.

 

[kirk]

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.