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

Single Filter to change all Pivot Tables in a Workbook 8
Excel VBA For excel 0
Duplicating Pivot Tables 2
One pivot table cannot overlap another pivot issue. 1
Excel Pivot Table problem 8
Pivot Data and Filter on separate sheets 1
How can you have two pivot tables on one worksheet? 2
pivot tables 4

Top