I have a dynamic range set up for a pivot table which works well but I was hoping to also make the Field Names dynamic. At the moment whenever the field name changes (as I have the source data headings dynamic) the fields all drop out of the pivot & have to be added again.

This is time consuming as there are many columns of data to be added, does anybody know of a way to make the Field Headings in the pivot match the source data without dropping out of the pivot when the heading changes? It is always the same columns of data that are needed in the pivot.

Thanks!