ExcelBanter - hide items with no data in pivot table

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

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

- - hide items with no data in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/261720-hide-items-no-data-pivot-table.html)

Heather

hide items with no data in pivot table

In Excel 2007 I created a pivot table from a set of data. How can I hide the
items in the pivot table that contain no data?

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