ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with pivot tables overlapping with new data (https://www.excelbanter.com/excel-discussion-misc-queries/244681-problem-pivot-tables-overlapping-new-data.html)

jjonessnl

Problem with pivot tables overlapping with new data
 
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.

Jim Thomlinson

Problem with pivot tables overlapping with new data
 
No there is no way to put breaks between pivots. Generally speaking I avoid
multiple pivots on one sheet.
--
HTH...

Jim Thomlinson


"jjonessnl" wrote:

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.



All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com