Show Pivot Table Items That Have No Data

J

J Austin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slicers and Calculated Items in Pivot Table 2
Pivot Table Counting Text Data 0
Data Lookup Question 1
Display No Data in Pivot 1
pivot table - show items with no data 0
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
date filter in a pivot table 1

Top