Error: PivotTable report cannot overlap another PivotTable Report

osscie3

Board Regular
Joined
Apr 30, 2014
Messages
70
Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one.

Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics.

There's only one PivotTable on the sheet.

I get the typical error message when I hit refresh.

The weird part is that I can move around my fields, remove, add, etc except for one field. It looks like I created some sort of calculated field of a date field. It's named "Years" and it has a little filter icon beside it in the PivotTable Fields area. When I try to remove that field from the Rows section, I get the overlap error message again. Does the same thing when I try to move that field to a filter, value, or column area.

Any thoughts or ways I could troubleshoot this thing?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Add this code to a new module in your workbook and tell us what the message says:

Code:
Sub HowManyPivots()
msgbox activesheet.pivottables.count
end sub
 
Upvote 0
Are there other pivot tables in the same workbook that use the same source data?
 
Upvote 0
Ok now we're on to something. When I delete all other pivot tables in the workbook (they're on separate sheets), I don't get the error anymore but the "Years" field goes away as well.
 
Upvote 0
Right click your date field in the pivot table and choose Group, then include Years in the grouping. That should bring back the Years field. Now you just need to figure out which of the other pivot tables was behind the error message. Did you have more than one pivot on any of your sheets?
 
Upvote 0
Figured out which sheet was causing it. For some reason though when I go back and try to Group by Year, it tells me "Cannot group that selection". Edit - It can group but it basically just puts all the data up under "Group1". Edit2: Got it to work finally. Had to do some data integrity checks.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top