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.