Pivot keeps old column headers

[CascadeDiver]

Hi all.

I noticed an irregularity with column names. I have a table with a header that I changed names on the old name : "CO. NAME" new name: "COMPANY". Yet when creating a pivot table the data is referencing the old name. Is there a way I can back track from where that bit of data is held so I can update it?

 

[sandy666]

create pivot from the beginning

 

[CascadeDiver]

Yes that was my first though. I deleted all pivot table and checked in VB that there were zero caches.

 

[CascadeDiver]

The header is reference correctly under the active pivot tables tabs but if using add to data model as seen above the header incorrect.

 

[sandy666]

with new pivot you have new cache so check for old cache is not necessary

 

[sandy666]

basic rule is don't change any header with existing pivot, less troubles

first do all what you need in data model then create pivot