Accessing Pivot Table's Data in VBA

  • Thread starter Thread starter spjoseph0511
  • Start date Start date
S

spjoseph0511

I have a pivot table that is linked to data returned by MS Query.
I'd like to highlight cells in the data body of the pivot table, base
on the values of other fields returned by the query. How do
accomplish this
 
Select your cells and apply conditional formatting (format, conditional
formatting)

This would need to be done after each change in the pivot table I believe.
 
Tom,

The value I wish to format on is not on the active sheet. It is
field in the source row of the data. As far as I know, the only way
can view the value of that field is if I drill down, and a ne
worksheet opens with the row.

How would I reference the value of that field if it is not displayed o
the active sheet?

Thanks,
Stephe
 
I don't think there is an equivalent to drilldown in VBA.

You might have to grab the source data in ADO or something and try to get to
the data.
 
Back
Top