One pivot table cannot overlap another pivot issue.

A

Avi

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
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top