Finding source data column of pivot field

L

Luca Brasi

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

Eduardo

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

Luca Brasi

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
 
Top