I have a bunch of pivot tables one after another. They all refer to the
same dynamic range. Problem is that when I expand the dynamic named
range (generating more rows) the pivot tables overlap one another and
excel won't allow it.

Is there a way to make the placement of the pivot tables dynamic in a
way that adjusts for whatever size range they need to accomodate. In
other words, "how can I make my pivot table output as flexible as my
dynamic named range input?"


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376870

Create each pivot table on a separate worksheet, then use multiple
windows in the workbook to view them simultaneously.

cwinters wrote:
I have a bunch of pivot tables one after another. They all refer to the
same dynamic range. Problem is that when I expand the dynamic named
range (generating more rows) the pivot tables overlap one another and
excel won't allow it.

Is there a way to make the placement of the pivot tables dynamic in a
way that adjusts for whatever size range they need to accomodate. In
other words, "how can I make my pivot table output as flexible as my
dynamic named range input?"




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi
I have the same problem. :)
Have you actually managed to find a solution to this problem.
Thanks


--
bakakitraki
------------------------------------------------------------------------
bakakitraki's Profile: http://www.excelforum.com/member.php...o&userid=36030
View this thread: http://www.excelforum.com/showthread...hreadid=376870