Excel friends --

As a Microsoft Project MVP, a question that generates no replies usually
means that what the user wants to do in Microsoft Project simply cannot be
done. I would be grateful if an Excel MVP would simply tell me that what I
want to do is not possible. Any takers?

--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Dale Howard [MVP]" <dale(dot)howard(at)msprojecexperts(dot)com wrote in
message ...
Excel friends --

I am using Microsoft Office Excel 2007 and created a PivotTable that
includes a field in the Filter Fields drop area. When I click the pick
list button for the field in the Filter Fields drop area, the pick list
menu includes a "Select Multiple Items" option. After selecting this
option, I am able to select multiple items on which to filter using that
field. This option is very cool; however, I have run into a problem.
When I select this option and then select multiple items on the pick list,
I assumed that Excel would do an "And" filter with these multiple selected
items, but discovered that it does an "Or" filter instead. Does anyone
know of a way to change this functionality, so that selecting multiple
items forces an "And" filter and not an "Or" filter? Thanks in advance
for your help! :)

--
Dale A. Howard [Microsoft Project MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"