renaming column when already used by multiple pivot tables

[wolewyck]

Hi folks,

I'd like to rename a column, which I've used in multiple pivot tables throughout a workbook. Is there a way to do this that will not mess up all my pivot tables? I'd like them to continue to draw from the same column, only to have a different label for it. I'm using Excel 2010. Thanks.

Thanks!

 

[Jerry Sullivan]

Hi and Welcome to the Board,

Pivot Report Fields have a Source Name (the name in your data source), and Custom Name (the name that appears in the PivotTable Field list).
Initially, these two names are the same, but you can modify the Custom Name on some or all the the PivotTables that reference this Source Name.

You can use Find-Replace to do that; however if your existing field names are used elsewhere in your workbook, you'll want to confirm each Replace instead of using Replace All.