View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BhavdeepSachdev BhavdeepSachdev is offline
external usenet poster
 
Posts: 4
Default Pivot Tables - Remove the "(All)" from the dropdowns

We have a requirement such that it has become necessary to remove the default
"(All)" form the drop down pivot fields lists for one of the pivot tables.

If you really want to know why, we are creating a report in which "All" is
one of the fields in the dropdowns. And that "All" is computed differently
(is not the sum of everything). So, to make sure the users are not confused,
we need to remove the default "(All)" that pivot table puts in.

If this cannot be done, I am thinking of writing some code that will select
our "All" in the highly unlikely event that the user selects the default
"(All)" :).

Thank you all in advance for your inputs.
- Peace.