One pivot table cannot overlap another pivot issue.
 

Hi,

I have a sheet containing 10-15 pivot tables in a page with same
source data. When I change the data and do a refresh on pivot. I get
Error saying that "A pivot table report can not overlap another pivot
table report.". I know the root cause as it is explicitly given inthe
error message.

As of now i try to fix this by adding some rows and columns in between
two pivots. It is a little time consuming process. So, looking forward
for any optimum approach, may be some sort of macros or so..

I understand one way would be to delete all the pivots and re-build
them, but applying filter is again a teduous task. Any other
alternatives ? please suggest.

Thanks in advance,
av

One pivot table cannot overlap another pivot issue.
 

The optimium solution is to rebuild your tables. There is no substitute for
doing it right. Anything else is just going to be band-aides on a poor design.
--
HTH...

Jim Thomlinson


"Avi" wrote:

Hi,

I have a sheet containing 10-15 pivot tables in a page with same
source data. When I change the data and do a refresh on pivot. I get
Error saying that "A pivot table report can not overlap another pivot
table report.". I know the root cause as it is explicitly given inthe
error message.

As of now i try to fix this by adding some rows and columns in between
two pivots. It is a little time consuming process. So, looking forward
for any optimum approach, may be some sort of macros or so..

I understand one way would be to delete all the pivots and re-build
them, but applying filter is again a teduous task. Any other
alternatives ? please suggest.

Thanks in advance,
av