How do you rename a calculated field in a pivot table, so that when the data is refreshed a different time, the new name shows. I renamed the field, but the field list still shows the old name.
Also how do you rename a calculated field that is not selected in the pivot.
