Hi There
I have a couple of problems working with with Excel 97 & pivottables.

1). I am trying to rename a couple of datafields where Excel is creating field names such as 'Sum of Breach' & 'Count of Call_Ref' I wish to rename them. I have tried code such as
Set myField = myPivot.PivotFields("Breach")
then myfield.name = "NewName" but the value appears to be read-only.

2). I am trying to create a Calculatedfield using code such as
Set slafield = myPivot.CalculatedFields.Add("SLA", "(=x)"). I can find little or no info on how to set the formula part of the Calculated field.

Any help would be appreciated

Well my problem now boils down to summing 2 calculatedfields.
I have field1 which is a count of one set of values, field2 which is a sum of another field now I wish to create a new calculatedfield which manipulates field1 and Field2 ie :-

Set slafield = myPivot.CalculatedFields.Add("SLA", "=(Field1 + Field2)")

But it doesn't appear that you can do this with calculated fields, has anybody any idea how I can do this ??