Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table overlap | Excel Discussion (Misc queries) | |||
"A pivot table report cannot overlap another pivot table report" | Excel Worksheet Functions | |||
Pivot Table Issue | Excel Worksheet Functions | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) |