Pivot Table Overlapping

[MikeJ100]

I have a workbook with many pivot tables and today when I update I get PivotTable report cannot overlap another PivotTable report.

I have inserted many rows and columns and still I get the dreaded message.

How can I find the pivot table that is causing my blood pressure to rise?

Thanks for your help.

 

[petertenthije]

If your pivot table always has the same layout (filters), you could use a helper column. Take for instance below screenshot. The pivot table should start with header ZONE, and end with either a blank line or ENDTOTAL (note: i manually translated the headers from Dutch, so they might be different from yours).


You could then use the following formula:
=IF(AND(D49="ZONE",AND(D48<>"",D48<>"ENDTOTAL")),1,2)


Any row with a 1 would be a pivot that overlaps the preceding pivot table.

If your pivot table does not have filters, then you could base it on the header "rowlabels". If the pivot table does not always have the same layout, then you are out of luck.