How to copy the grouping conditions to multiple Pivot Tables

Hi all,

I have a reporting file with more than 30 pivot tables, and every week I have to refresh all of them with new raw data.

All pivot tables have dates grouped by 7 days in their rows, and they all start the grouping on the 14/05/2018 and end it on whichever date I need to generate the weekly metrics.

When refreshing the raw data, most of the pivot tables ungroup and I need to group one by one all over again, which takes an unnecessarily high amount of time.

Does anybody know a way to copy the grouping conditions of one pivot table into another?

Many thanks for your help!

Cheers,

Paula

I was under the impression that all pivot tables using the same pivot cache would have the same grouping.
Could you rustle up a file that has say 8 pivot tables, and attach it here, and say how you change the source (you call it raw) data?
It may just be a case of ensuring that all pivot tables are linked to the samepivot cache.