Howdy folks!

I need help

I have a pivot table (actually i have a lot of them 100+)
With DataRange from A to Z columns

The A column name is "how old are you" .. now after I created all the pivot tables, I need to rename the A column name to "age" .. if I do that and click refresh on pivot tables.. All the pivot tables "break apart" because the field "how old are you" doesn't exist anymore.. Is it possible to re-link that automatically somehow?

Thanks in advance