View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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.