ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   help! dimension members how to not be selected by default (https://www.excelbanter.com/excel-discussion-misc-queries/827-help-dimension-members-how-not-selected-default.html)

solomon

help! dimension members how to not be selected by default
 
for a dimension in pivot table,imagining only several of its members are what
I am interested to concern;if some new members are added into this dimension
when refreash the pivot table,I find these new members are selected
automatically, this is an annoyance since I just want to see specific members
not new ones.

Is this an Excel config option to pre-select new members?
Can this option be turned off?

thanks


All times are GMT +1. The time now is 09:19 PM.

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