A PivotTable Report cannot overlap another PivotTable Report

[patchkek]

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

 

[mole999]

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

 

[patchkek]

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

didn't work for me =[

thanks so much though!

 

[mole999]

your symptom is just that pivots over reaching another, maybe 20 is the number, its difficult to be precise