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.
 
Ad

Advertisements

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

One pivot table cannot overlap another pivot issue. 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Are copied Pivot Tables "linked" to each other ? 2
Adding to an existing Pivot Table 7
Pivot Table Update 3
Pivot Data and Filter on separate sheets 1
Pivot Table Data Source 1
pivot table data 2

Top