Pivot Table and Zeros

D

Debra Dalgleish

You could use the PivotTableUpdate event to run it when the pivot table
is refreshed. For example:

'==========================
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
HideZeroRowTotals
End Sub
'===================

The HideZeroRowTotals code goes on a regular module and the
PivotTableUpdate code goes on the module for the sheet that contains the
pivot table.

There are instructions here for pasting the code:

http://www.contextures.com/xlvba01.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Surpressing rows and columns with zero values in a pivot table 1
Pivot Table Shows Only Zeros 3
Using VBA to create a new worksheet, and then target new worksheet 1
Pivot table - undo of a macro 1
Hide zero values in a pivot table 3
Exclude zeros from pivot table averages 1
Excel 2007 Pivot Tables - do not display zero values 2
Count of Non-Zero pivot table entries 1

Top