Finding source data column of pivot field
 

How can I find the source data column of a pivot field (if it's not a
calculated field of course)?
Thanks, Luca

Finding source data column of pivot field
 

Hi Luca,
Go to the pivot table , Data , change data source. It will take and
highlight the source
Hope this help

"Luca Brasi" wrote:

How can I find the source data column of a pivot field (if it's not a
calculated field of course)?
Thanks, Luca

Finding source data column of pivot field
 

Thanks Eduardo, but as this is the Excel.Programming group I am not looking
for a manual approach.

My final goal would be to have a macro that loops through all pivot fields
and applies the same number format as the cell in the second row of the
appropriate data source column.

Is this possible?
Thanks, Luca



"Eduardo" wrote:

Hi Luca,
Go to the pivot table , Data , change data source. It will take and
highlight the source
Hope this help

"Luca Brasi" wrote:

How can I find the source data column of a pivot field (if it's not a
calculated field of course)?
Thanks, Luca