Hi

I am trying to find a way to programmatically read the sub-total values from
the data field of a pivot table. The problem is that i don't seem to be able
to access the single pivot items in the Data Field. I read a KB article
describing this as a problem in MS Excel's object model
(http://support.microsoft.com/default...en-us;Q213455). Anyway the
suggested workaround doesn't work as even when accessing the fields from
the'VisibleFields' property of the pivot table object instead of 'DataFields'
I get exactly the same field objects among which the one generated by the
aggregate function 'Count of..', which contains no pivot items.

Is there another way to read the values of the generated sub totals in a
pivot table or am i doing something wrong?

--
Thanks in advance
/Enrico