ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why do my outlines change on my pivot table when I add new data? (https://www.excelbanter.com/excel-programming/372063-why-do-my-outlines-change-my-pivot-table-when-i-add-new-data.html)

[email protected]

Why do my outlines change on my pivot table when I add new data?
 
I tried outlining my detail information and I want to show the first
and last line of my detail information. It is broken down by Customer,
detail next customer next detatil. When I close the grouping, It shows
Customer and then the last line is customer total.

The problem I am having is when I refresh the pivot table and get more
data, the data shifts out of the outlines, I originally created. Is
this something I am stuck with redoing the outlines when new data is
added or is their a way to prevent it.


Regards,


Chris



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

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