overlapping pivot tables

  • Thread starter Thread starter cwinters
  • Start date Start date
C

cwinters

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?"
 
Create each pivot table on a separate worksheet, then use multiple
windows in the workbook to view them simultaneously.
 
Hi
I have the same problem. :)
Have you actually managed to find a solution to this problem.
Thank
 

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

Similar Threads

Pivot Table conundrum 2
Dynamic data ranges in pivot tables 3
Problem with pivot tables overlapping with new data 1
One pivot table cannot overlap another pivot issue. 1
Adding to an existing Pivot Table 7
Excel 2007 Pivot Table 3
Pivot Table - Efficient Source Range 2
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top