Show items with no data on rows- Excel

By bernice.alatorre ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums