More information for Err: "A PivotTable Report cannot overlap another PivotTable Report"
More information for Err: "A PivotTable Report cannot overlap another PivotTable Report".
I had multi PivotTable share the same data source in a single worksheet.
This error had little meaning for me to find out which PivotTable having problem.
Please improve the error message and advice which PivotTable cause this problem.
Improving the usefulness of error messages in general would be a very worthwhile investment in Excel. I know its not the **** stuff you get to tout at conferences. But just announcing to the user that somewhere (won't say where) there's a problem just sends us on a hunt that could be resolved faster with more specific details.
Excellent Useer commented
Yes like a highlight on the pivot table that is trying to expand. OR introduce an option users can set where the pivot tables will insert cells and push everything down.
jeffrey Weir commented
Yes please. For Tables too. Meanwhile, here's a link to my workaround code http://dailydoseofexcel.com/archives/2017/12/08/identifying-pivottable-collisions/