ExcelBanter - Show all data in Pivot Table

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Show all data in Pivot Table (https://www.excelbanter.com/excel-programming/413431-show-all-data-pivot-table.html)

AbsentiaAdmin

Show all data in Pivot Table

Hi,

When I double click on the type button the "Show items with no data" is
greyed out.
How am I able to get these items to show?
I'm using Excel 2003 with Data cubes.

Thanks!

All times are GMT +1. The time now is 12:55 PM.