title: How can I hide pivot items but include them in totals in Excel 2003
body: <p>In Excel 2003 I am trying to create a Workbook_SheetPivotTableUpdate Sub that enforces a restriction on a pivot table such that a particular pivot item of a particular row field must never be visible but must still contribute to subtotals and grand totals.</p>
  
  <p>I know there is a setting "Subtotal hidden page items" that allows this to happen if the field is a page field. I also know how I can force the pivot item to be visible or not:</p>
  
  <pre><code>Private Sub Workbook_SheetPivotTableUpdate(ByVal Sh As Object, ByVal Target As PivotTable)
      Dim pvtField As PivotField
      Dim pvtItem As PivotItem
      Set pvtField = Target.PivotFields("Specific Field")
      If pvtField.Orientation = xlRowField Then
          Set pvtItem = pvtField.PivotItems("Specific Item")
          pvtItem.Visible = False
      End If
  End Sub
  </code></pre>
  
  <p>But I don't know if it is possible to put it in a state where the user cannot see it but it continues to contribute to the subtotals and grand totals in the pivot table.</p>
  
  <p><img src="https://i.stack.imgur.com/QkEFo.png" alt="enter image description here"></p>
  
  <p>Short of iterating through the rows of the pivot table and setting the row heights to 0, is there a state for pivot items or a way to manipulate the way Excel calculates the totals to accomplish this?  </p>