Hi,
Does anyone have a way, either through formulas or VBA (or a clever trick) of getting multiple pivot tables on one sheet to accommodate the overlap of pivot tables?
Hi,
Does anyone have a way, either through formulas or VBA (or a clever trick) of getting multiple pivot tables on one sheet to accommodate the overlap of pivot tables?
I try to avoid having multiple pivots on the one sheet because of this issue, unless I know 100% that the refreshed data will not make them overlap.
Hello,
position the pivot tables so they don't overlap when unfiltered. Then use VBA to hide the empty rows/columns when a filter is applied and the pivot tables change dimensions. That VBA can be tied to an event (Worksheet.PivotTableUpdate Event) so it runs when the pivot table is updated.
cheers, teylyn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks