A PivotTable Report cannot overlap another PivotTable Report

patchkek

New Member
Joined
Sep 4, 2018
Messages
9
Hi All,

I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables.

I seem to have maybe identified the sheet of where it is coming from. If i delete all of the pivot tables in the sheet, then refresh, I do not get this error. I can then "undo" to bring all of my pivot tables back, refresh again, and then the error comes back.

I tried to delete each pivot table on this sheet one at a time to see if I could identify the problematic table, but this was unsuccessful.

Any advice?

Thanks a bunch!
K
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
I usually put 5-10 extra columns between each and that often solves the issue, its just they have to expand before they contract back to normal
 
Upvote 0
your symptom is just that pivots over reaching another, maybe 20 is the number, its difficult to be precise
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

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