Ever had the scenario wherein you updated the data, 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 overlapping Pivot Tables?
This means that one of your Pivot Tables expanded horizontally/vertically and is overlapping 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, 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 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
Voila! You are able to fix overlapping pivot tables!
How to Fix Overlapping Pivot Tables