locked
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)?
    Thanks.

    Cross posting

    "http://www.ozgrid.com/forum/showthread.php?t=89466"
    "http://www.mrexcel.com/forum/showthread.php?t=315637"

    Tuesday, April 22, 2008 2:28 PM

All replies