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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse 2
Pivot table multiple filters 2
Unable to Group in Pivot Table 1
Excel 2007 pivot tables - calculated fields and SSAS cube 3
pivot table + fixed column fields 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Using VBA on Excel Pivot Tables 3
Automatically Update a Pivot Table Field Used as Column / Row 1

Back
Top