Pivot Table labels

[arvnranger]

A week back I was given a pivot table with Products in Rows, Warehouses in Columns and quantities in the body. The Warehouses (column headings) were displayed as names although in the date table upon which the pivot table was based showed only numerical codes for the warehouses. I'm new to pivot tables and I'm interested to know how this (substituting descriptive strings for numbers) is achieved. AFAICS the entire workbook has just 2 sheets - one with the data table, the other with the pivot table, and no other data which might be used for lookups or the like.

Cheers,
ARVNranger

 

[Worf]

Headers can be typed manually after the pivot table is created.

 

[arvnranger]

If the table were to be refreshed, or the parameters changed, such that another column would appear or the order of the columns were different, would the manually typed headings be retained with the relevant data?

Thanks, Mr Worf! (Full spread, maximum yield

 

[Worf]

I performed some testing and the new labels seem to stay in place.

 

[arvnranger]

That was above and beyond Thanks again, Mr Worf.

 

[Worf]

You are welcome, Excel warrior.