I have Excel 2007 pivot tables that refresh on data sets that sometimes have
no data for a particular item. I want to display all items, even zero or
empty. Under Pivot Table Options there is a selection "Show items with no
data on rows". It is not checked but it is also greyed out. Is there some
other setting or condition that is keeping me from utilizing this option?

Thanks in advance,

J Austin