Want to know How To Fix Overlapping Pivot Tables in Excel?
*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***
Ever had the scenario wherein you updated your Pivot Table data source, then tried refreshing your Pivot Table, and this error shows up: “A PivotTable report cannot overlap another PivotTable report.”
How do we find a solution for a PivotTable report that overlaps another PivotTable report?
This means that one of your Pivot Tables is trying to expanded horizontally/vertically and will overlap with another Pivot Table.
You can simply select Move PivotTable and you can move your Excel Pivot Table very quickly to make more space!
For our example, we have added 2015 data to our data source, which will cause the first Pivot Table to overlap with the second Pivot Table.
STEP 1: Let us see the error in action. Right click on any cell in the first Pivot Table. Click Refresh
Excel prohibits us from doing so.
STEP 2: Make sure you have selected your second Pivot Table. Go to PivotTable Tools > Analyze > Actions > Move PivotTable
STEP 3: Select the new location where you want to move it. You have the options to move the Pivot Table to a New Worksheet or Existing Worksheet.
In our example, we selected cell G5 and click OK.
STEP 4: Right click on any cell in the first Pivot Table. Click Refresh again so we can show the 2015 data in our Pivot Table report:
Voila! You are able to fix the overlapping Pivot Tables!
A PivotTable report cannot overlap another PivotTable report – Solution