Problem with pivot tables overlapping with new data

J

jjonessnl

I am trying to put 3 pivot tables on one worksheet. The amount of data will
vary depending on the criteria I use to filter on. Is there a way to insert
section breaks between the pivot tables so that more data in the tables does
not produce overlap between the pivot tables.
 
J

Jim Thomlinson

No there is no way to put breaks between pivots. Generally speaking I avoid
multiple pivots on one sheet.
 

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 Tables and Filter Criteria Display 0
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Excel 2007 pivot table using analysis services cube as data source 0
Embed the same Excel multiple times 0
Excel 2007 pivot table: select multiple data easier 0
Single Filter to change all Pivot Tables in a Workbook 9
Shift Rows Down When Expand Pivot Table 0

Top