Question Locked
Show items with no data on rows- Excel
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?