Hi all,

I'm having an issue regarding Pivot Tables and my column header names. The problem is that my column header names can change at any time and the user can do this at any time. However, my pivot tables are obviously designed to use that specific column with a specific header name when you first create it.

For example, if I have 3 cells: B1 with the value = "Year 2010", C1 = "Year 2011", and D1 = "Year 2012". The pivot table will use those titles for the actual pivot table produced ("Year 2010", "Year 2011", etc)...

The issue is when the user can change B1, C1, and D1 later on... perhaps they can shift it to B1 = "Year 2011", C1 = "Year 2012", and D1 = "Year 2013".

If they do this and refresh the pivot table, the pivot table won't work. Is there anyway to have the Pivot Table understand what's going on (that just a simple name had changed for that column, but still to get data from that column)?

Thank you all.