I have a large file with many tabs and even more pivot tables. The file works for my needs, but I've developed a problem where there seems to be a couple of overlapping pivot tables someplace. I'm getting the popup "A pivot table report cannot overlap another pivot table report." I've searched each sheet, and can't seem to find the problem. Checked to make sure there weren't any hidden sheets. I've searched the web for this, and seen the guidance around preventing this from happening, hidden columns, hidden sheets, etc. and understand these issue. I'm just wondering if there's a quick way of finding any sheet with multiple pivot tables. Maybe a macro that generates a list of pivots by sheet? Doesn't seem too tough, but I'm a little rusty in VB programming, so thought I'd ask here first.
Thanks in advance for the help.