Pivot Table VBA - Data Field - Original (source) field name RRS feed

  • Question

  • I have created simple pivot table (no OLAP) from excel data.
    I have data fields as CY (Current Year) and NY (Next Year).
    Once Pivot Table is build, I change the caption for CY to "Year 2008" and caption for "NY" to "Year 2009".
    In VBA, the problem is once I change the caption, the field name changes to "Year 2008" / "Year 2009" and I loose reference to "CY" / "NY". I am looking at object structure "ActiveSheet.PivotTables("PivotTable1").DataPivotField.PivotItems". Now the name, caption and value have become "Year 2008" / "Year 2009". How can I refer to original source field name (the field names in data are still CY and NY)?

    Cross posting


    Tuesday, April 22, 2008 2:28 PM

All replies