Finding source data column of pivot field

  • Thread starter Thread starter Luca Brasi
  • Start date Start date
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
 
Hi Luca,
Go to the pivot table , Data , change data source. It will take and
highlight the source
Hope this help
 
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
 
Back
Top