In Excel 2007, I have noticed that pivot tables may have a column heading of values or data. What determines which is displayed and how can it be changed?

I have a template where I paste the pivot table to calculate results, but the results don't display properly when the column heading appears as values.

Thanks for your help.