Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
solomon
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
How can I set the default line width HighPlanes Charts and Charting in Excel 3 December 3rd 04 05:21 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"