Hey all!

I have a pretty large report (around 1GB in size - lol), with numerous pivot tables. One of them is overlapping something else and causing me to not be able to refresh the report, but this particular report has over 100 sheets inside, so it'll take literally forever to try to figure out what is overlapping what.

According to the error, it's pivottable3, but no idea where that is. lol

Do you guys have any elegant solutions for locating pivot table locations?