In Excell 2007, I have pivot tables that refreshon data sets that sometimes do not have 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 si not checked but it is also greyed out. Is There some other setting or condition that is keeping me form using this option?
