| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Pivot Table's Data in VBA
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 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Pivot Table's Data in VBA
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. -- Regards, Tom Ogilvy "spjoseph0511" wrote in message ... 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, based on the values of other fields returned by the query. How do I accomplish this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Pivot Table's Data in VBA
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 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Pivot Table's Data in VBA
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. -- Regards, Tom Ogilvy spjoseph0511 wrote in message ... Tom, The value I wish to format on is not on the active sheet. It is a field in the source row of the data. As far as I know, the only way I can view the value of that field is if I drill down, and a new worksheet opens with the row. How would I reference the value of that field if it is not displayed on the active sheet? Thanks, Stephen ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table accessing data from OLAP cube | Excel Worksheet Functions | |||
| PIVOT TABLE's Custom Calculated Fields | Excel Discussion (Misc queries) | |||
| how do I extend an existing pivot table's range | Excel Discussion (Misc queries) | |||
| Changing a pivot table's data range in Excel 2007 | Excel Worksheet Functions | |||
| Pivot table accessing external data | Excel Discussion (Misc queries) | |||
Linear Mode
