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 i
creating field names such as 'Sum of Breach' & 'Count of Call_Ref'
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 fin
little or no info on how to set the formula part of the Calculate
field.

Any help would be appreciate

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com