Hi,

Sorry to make this two posts, but I think the option you are trying for is
under
PivotTable Tools, Options, Field Settings, Layout & Print tab, Show items
with no data.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"J Austin" wrote:

Using Excel 2007 and have the need to show all items regardless of whether
there is data on the row. I have been successful in the past using the PT
Options under display to check the box that provides this capability.
However, I have a new PT and in trying to implement this, the option is
grayed out and cannot be checked. What conditions in Excel/PT or data may
cause this option to not be available.

Thanks,

J Austin