title: Pivot Table filter out only 1 option
body: <p>I'm having a problem with removing one option from the filter in my Pivot Table, if I record a macro and try to apply changes with only one of ~20 options removed, Excel pops up a message:</p>
  
  <blockquote>
    <p>Too many line continuations!</p>
  </blockquote>
  
  <p>Seems like it is trying to declare each of the possible filter options by name, just like here:</p>
  
  <pre><code>ActiveSheet.PivotTables("PivotTable1").PivotFields( _
      "[Product Component].[(c) Segment 4].[(c) Segment 4]").VisibleItemsList = Array _
      ("[Product Component].[(c) Segment 4].&amp;[31558]", _
      "[Product Component].[(c) Segment 4].&amp;[315516]", _
      "[Product Component].[(c) Segment 4].&amp;[3152027]", _
      "[Product Component].[(c) Segment 4].&amp;[3152028]")
  </code></pre>
  
  <p>Is it possible to remove only one option and show the rest ~20 with one command?</p>