Roderick_E
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 2,051
I understand why this happens and how to fix it by making sure there is ample space between pivottables, however I was thinking about a way to tell a user of a potential conflict. Is there something in VBA I could do (a maximumpivot range property or something) that I could run/make to see the potential maximum range each pivot table would consume if it were completely unfiltered? In this way, I'd hope to find the potential conflicts BEFORE they happen