05
Mar
A Pivot Table Cannot Overlap. 1642003 The basis data for some of your pivots is different. To quickly find pivot tables that might have an overlap problem use the macro. A pivot table report cannot overlap another pivot table report. The overlapping ones are probably not limited like that though.
Pivot tables need enough space to display their content and can therefore not overlap with one another. Excel does not insert rows when it draws a pivot table. The solution is to insert rows or columns before making the. This makes some pivot tables bigger that the first time you recorded them. If it will then the wizard will stop preventing you from creating the pivot table. 612012 I am getting errors in my Excel workbook that contains around 50 reports that say A pivot table cannot overlap another pivot table.
1 Replies 179 Views Similar Articles PageSpeed 11.
It doesnt tell you which pivot tables are concerned. Last moth you had info on eg. I dont believe this is possible unless you know something about the structure of the Pivots beforehand. A PivotTable report cannot overlap another PivotTable report. To quickly find pivot tables that might have an overlap problem use the macro. The responses that resolved your issue and to click Unmark as Answer.