I have a Pivot Table which is the "parent" to several other Pivot Tables. In the source data for the pivot table, 12 of the column heading contain the Month and Year to effectively represent a rolling 12 month cycle (Example Sept 2007 through August 2008). Each month the data range feeding the table is updated to a new/current rolling 12 months - I do not move any of the data, I ONLY change the column headings. Unfortunately in doing the update, the column heading within the Pivot Table do NOT reflect the update in the source data range. Due to this I have to rebuild the Pivot Tabe from scratch each time and then update the "children" Pivot's.

Remember the actual locations of the data did NOT change, just the column headings. Any suggestions on how to get these changes to propogate into the piviot table?