A Pivot Table report cannot overlap another Pivot Table report

[asyssolvers]

Hi I have 3 pivot tables in same sheet and data source is danamically changing when refresh depend on the parameter value which is passing from the front end. It is a report and I have done the layout. But sometimes when the row count is more, Im getting above error message which is "A Pivot Table report cannot overlap another Pivot Table report" .

Do we have any setting to do setup to auto add cells depend on no of rows ? like in tables/data range ?

How can we resolve this issue dynamically ?

Thanks everyone in adavance.

 

[Hermanito]

if your data source is changing often, and you cannot predict its effect on the size of your pivottables (either in number of rows or number of columns), it might be best to have only one pivottable per sheet.

Otherwise you would end up with a clumsy solution of a lot of VBA which in the end would not be very reliable in this case anyway, imho.

Maybe there is a solution I'm not aware of in pivottable settings, but I have not yet found it