Hi,

I noticed that no matter how I change the name of a field in Pivot, when I
look at field properties I still see the original field name. Is there a
way to get the original field name? I want to constantly change the caption
of that particular field.

I want to change the name of a field from month to month (ie Sept Cost, Oct
Cost). I would request the user to input the month in an input box, but how
do I change the field? It's impossible to say replace "Sept Cost" with "Oct
Cost" because I do not keep track of the field index and won't know the
original name.

Thanks,
Carmen