You can change the field names manually by clicking the cell with the field
heading you want to change, then edit it in the Formula Bar.

To do the same using VBA, you change the Caption property of the field, as
follows:

Sub AAAA()
'Change Product to ProductX
ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Product").Caption = "ProductX"
'Change Sum of Quantity to Count of Quantity
ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Sum of Quantity").Caption = _
"Count of Quantity"
End Sub

Hope this helps,

Hutch

" wrote:

hi,

i'm currently working on a pivot table using a german version of Excel
2003.
Whenever I open the file using the english verison the pivot field
names are stilled displayed in german. ("Summe von... " instead of
"Sum of...")

but the really weird stuff starts now:
if I change the aggregation function from sum to count, the values
displayed in the table change accordingly but the pivot table field
name remains at "Summe von..." (in german!!)

seems like an annoying bug :-(
any ideas how to change/update the names displayed programmatically?

thanx for any suggestions

Verena