ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot tables lose of data fields when selecting (https://www.excelbanter.com/charts-charting-excel/197694-pivot-tables-lose-data-fields-when-selecting.html)

Justin[_3_]

Pivot tables lose of data fields when selecting
 
Having an issue with setting up pivot tables not to lose certain
fields if users de-selects some. For example I have muliple column of
data.

a, b, c, d, e, f

The user de-selects d, e, f; The next time they want to see D, E, F.
The go back to the drop down menu and only see Show all, a, b, c. Is
there anyway I can always keep them so they can reslect the data? I
can go back into the wizard and add them back but that is time
consuming and tring to teach that to 30 users is a bit tricky.


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

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