renaming header row in pivot table source data

[urungus]

If I rename cells(s) in the header row of my pivot table source data, the next time I refresh the pivot table, the corresponding column(s) in the pivot table disappear. I am forced to manually rebuild the pivot table by dragging the new column name(s) out of the pivot table field list. Is there any way to avoid having to do this?

 

[Andrew Poulsom]

Welcome to the Board.

Sorry, no.