That option isn't available if the source is an OLAP cube.

HJM wrote:
I'm creating a pivot table and only want to show items with data. When I
leave the "show items with no data" unchecked, it still shows all data. The
help pages indicate that some types of source data does support this option.
Which types would they be?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html