Posts tagged: pivot

Hide zero value lines within a pivot table in Excel 2003/XP/2000/97

Great article with screenshots.. Doesnt get any clearer than this:

Spreadsheet123.com

Too bad it doesnt work for rows adding up to 0 in the pivot (say source has a -10 and 10, so the pivot shows 0, the trick above doesn’t work for that)..

Update all pivot tables in a workbook

Option Explicit

Sub RefreshAllPivots()
Dim ws As Worksheet
Dim pt As PivotTable

On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
   For Each pt In ws.PivotTables
     pt.RefreshTable
   Next
Next
End Sub