cooolboy
09-04-2015, 03:52 AM
I have sheets in a workbook with many pivot tables on it. All pivot tables in sheet are arrange one after another (Row wise). As the sizes of the pivot table are not fixed, I couldn't fix the positions of 2nd, 3rd, 4th pivot table and so manually go to everysheet and hide/unhide rows between the pivot table as required after refresh. Could we able to automate such that whenever the pivot is refresh through VBA, it also rearrange the pivot table one after other.