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 |
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) |