Folks, Puzzling behaviour in a Pivot Table I've inherited and I can't figure out what's going on. I'm using Excel 2010 but the table may not have been initally created in that version. The underlying data has a field called Partner_Status and in the Pivot Table it appears as Partner_Status in the Report Filter and Partner_Status2 in the Row Labels. Partner_Status seems to behave as expected when data is refreshed but Partner_Status2 does not refresh and shows values that no longer exist in the underlying data. Two questions, firstly what is the way to create a field like Partner_Status2 (it is not calculated) and 2 how do I get it to refresh?