title: Unable to get PivotFields property of the PivotTable class
body: <p>I'm trying to make a macro that changes the filters of several PivotTables (not all), but i'm getting an error on the PivotFields, here's a sample of my code:</p>
  
  <pre><code>Sheets("Sheet1").PivotTables("PivotTable" &amp; pivot_counter).PivotFields( _
  "[year].[year].[year]").VisibleItemList = Array("")
  </code></pre>
  
  <p>My questions are:</p>
  
  <p>1- Why do we use PivotFields("[year].[year].[year]") when using VisibleItemList? Why do we have to repeat it and what's the meaning of it, couldn't anything about it anywhere.</p>
  
  <p>2- What is supposedly wrong with this code? My pivot table has a field called "year" and the filter is set for a specific year (let's say 2013) and i wanted it change for all possible years.</p>