Expand Excel PivotTable without overlaying another PivotTable (VBA)

Question

Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I click the button to expand the data, the other table below is "pushed" so that it doesn't overwrite. Currently, if I click the table button to expand or collapse, I will get an error saying "A pivot table cannot overwrite another pivot table". I need to fix this.

yea_so · Answer

Rai__LS&nbsp;move it&nbsp;

rai__ls · Answer

I need this to be automatic, do the opposite every time I expand the table I will have to move it manually.

yea_so · Answer

Rai__LS&nbsp;&nbsp;Pivot table expand going down and going right. so what part of the worksheet can you put something that will not get affected with the expansion, find that place.

rai__ls · Answer

Yah, i know that, is because of that i need do it using a VBA code. I´m looking for this code in the web.

yea_so · Answer

you don't need VBA to find that place, that place is to the left of the location of the pivot table will not be affected by the expansion/contraction of the pivot table.

Forum Discussion

Expand Excel PivotTable without overlaying another PivotTable (VBA)

5 Replies