ExcelBanter - Pivot Table - hide blank cells

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

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

- - Pivot Table - hide blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/40871-pivot-table-hide-blank-cells.html)

Kirk P.

Pivot Table - hide blank cells

Is there any way to suppress the display of blank cells within the data area
of a pivot table?

Dave Peterson

Debra Dalgleish has posted code to do this:
http://groups.google.co.uk/group/mic...900b96 680905

or

http://tinyurl.com/axk75

Kirk P. wrote:

Is there any way to suppress the display of blank cells within the data area
of a pivot table?

--

Dave Peterson

All times are GMT +1. The time now is 08:58 PM.