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?

 

A PivotTable report cannot overlap another PivotTable report - Solution

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.

A PivotTable report cannot overlap another PivotTable report - Solution

DOWNLOAD EXCEL WORKBOOK

STEP 1: Let us see the error in action. Right click on any cell in the first Pivot Table. Click Refresh

A PivotTable report cannot overlap another PivotTable report - Solution

Excel prohibits us from doing so.

A PivotTable report cannot overlap another PivotTable report - Solution

STEP 2: Make sure you have selected your second Pivot Table. Go to Analyze > Actions > Move PivotTable

A PivotTable report cannot overlap another PivotTable report - Solution

 

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.

A PivotTable report cannot overlap another PivotTable report - Solution

 

STEP 4: Right click on any cell in the first Pivot Table. Click Refresh again

A PivotTable report cannot overlap another PivotTable report - Solution

Voila! You are able to fix overlapping pivot tables!

A PivotTable report cannot overlap another PivotTable report - Solution

 

 

How to Fix Overlapping Pivot Tables

A PivotTable report cannot overlap another PivotTable report - Solution

Helpful Resource:

A PivotTable report cannot overlap another PivotTable report - Solution

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin