| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Pivot Table Fields In Field List Not in Source Data | Excel Programming | |||
| Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
| Finding Source of DropDown Field | Excel Worksheet Functions | |||
| How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
| Finding unique items in data field for pivot tables | Excel Discussion (Misc queries) | |||
Threaded Mode
