Hi.
I am not sure if this had been solved.
My problem is the following:
I have 2 sheets - 1. Source data with 40 columns and 10000 rows. 2. a pivot sheet which has 10 pivots linked to the source data sheet
I need to change the source data columns (about 10 of them every month) as the months change (so do the columns names example from actual 2021 to May 2021 and so on).
When the source data is updated and I refresh the pivots sheet it removes the pivot columns that were renamed.
Any help on this.
Thanks
Bookmarks