ExcelBanter - Pivot table zero values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table zero values (https://www.excelbanter.com/excel-discussion-misc-queries/197937-pivot-table-zero-values.html)

R Ormerod

Pivot table zero values

In Excel 2007 Pivot Table Options, in the Display tab, there are check boxes
which allow you to show items with no data on rows/columns.

I have Excel 2003 and cannot find any similar option in the Options dialog
or in any of the Field Settings.

Is this possible in Excel 2003?
--
R Ormerod

All times are GMT +1. The time now is 01:52 AM.