My Excel 2010 workbook has 5 pivot tables in sheet 2 through sheet 6. All use the same data source from sheet 1. I will oversimplify and pretend the data source looks like this
Building part qty cost Total value
bldg1 bolt 500 10 5000
I want to change the column heading from "part" to "model". Must I manually revise each of the 5 tables to change "part" to "model" or is there a way to do this automatically in a single step?