Pivot table - get rid of "All" in filter axis

[kiln]

How can I get rid of the All entry in the filter axis? I have

.FieldSets("Year").AllowMultiFilter = False

but a selectable "All" entry remains at the top of the list, which is
not what I want.

 

[Alvin Bruney [MVP]]

kiln,
as you may be aware, this newsgroup is not as vibrant as others. I suggest
you download the office web component toolpack from microsoft office
website. There are enough examples and code snippets there that you should
be able to piece together what you need to do. The helpfile is comprehensive
and there is also a good description of the object model.
hth

 

[kiln]

kiln,
as you may be aware, this newsgroup is not as vibrant as others. I suggest
you download the office web component toolpack from microsoft office
website. There are enough examples and code snippets there that you should
be able to piece together what you need to do. The helpfile is comprehensive
and there is also a good description of the object model.
hth

No, that doesn't help. I know about the tookpack and it's a lousy,
incomplete learning aid. The help file is the worst I've ever seen, most
of the definitions are one liners that provide no more than a whisp of
clarification.

By the way, did MS ever tell you if the OWC is a dead ender? I know you
asked a couple of weeks ago, and they didn't reply in public. Since
you're an MVP, they may have contacted you in via email. It would be
interesting to know if they have officially abandoned the OWC or if it's
considered alive but is just unsupported.

 

[Alvin Bruney [MVP]]

To tell the honest truth, I still don't know. I asked this question because
I am in the process of writing a book on OWC version 9 - 11 and I wanted to
know if the effort would be a wasted one. I haven't had a response yet but
it shouldn't be long.

 

[kiln]

To tell the honest truth, I still don't know. I asked this question because
I am in the process of writing a book on OWC version 9 - 11 and I wanted to
know if the effort would be a wasted one. I haven't had a response yet but
it shouldn't be long.

Well, count me in for a copy if you finish the book.

BTW I don't think that there is an example of a filter list in the OWC
Toolpack. Did you find one? Or were you just saying that it might be in
there...

 

[kiln]

To tell the honest truth, I still don't know. I asked this question because
I am in the process of writing a book on OWC version 9 - 11 and I wanted to
know if the effort would be a wasted one. I haven't had a response yet but
it shouldn't be long.

I meant an example of a filter list that didn't have an "All" selection
available...

 

[Alvin Bruney [MVP]]

I'll allocate some time tomorrow afternoon to help you with this problem.
(got a 2morrow AM deadline for a product, after that i should be free for
the day)

 

[kiln]

I'll allocate some time tomorrow afternoon to help you with this problem.
(got a 2morrow AM deadline for a product, after that i should be free for
the day)

Well, that is very kind of you. Frankly I don't see a property that
allows one to turn off the "All" checkbox. There are a couple that sound
relevant but are not, as far as I can tell.

 

[Alvin Bruney [MVP]]

In Office XP filtering is set by the PivotFieldSet.AllIncludeExclude,
PivotField.IncludedMembers
and PivotField.ExcludedMembers properties and you can filteron multiple
members
regardless of what axis the FieldSet is on. You can restict the filter axis
to a
single member (like Office 2000) using the PivotFieldSet.AllowMultiFilter
property.
The common case for filtering to a single member is AllIncludeExclide =
plAllExclide
and a single member one of the IncludedMembers.

 

[kiln]

Unless there is something implied in what you wrote that I didn't pick
up on, those options are known to me. What I'm looking for is a way to
get rid of the All selection option that still exists once you've set
AllowMultiFilter = False. In the app I'm working on, "All" is not always
an appropriate choice; in some cases the "All" filter produces
meaningless values. *Only* one single choice should be permitted. It may
be that this is a shortcoming of the OWC.