title: on Startup of Excel file collapse all the drilldowns on an Excel Pivot Table
body: <p>I am fairly new to the Pivot Table concept and I am having some issues with getting an Excel Pivot Table to be collapsed on start up.</p>
  
  <p>I am developing this in .NET 4.5 and C#</p>
  
  <p>The first image is when I start up by excel file, my pivot table has all the drill downs shown.</p>
  
  <p>Example:
  <a href="https://i.stack.imgur.com/ty9SW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ty9SW.png" alt="Image"></a>
  </p>
  
  <p>I would like them to be suppressed so It shows a general Summary, then if the user wants to, they can drill down from there. Like so:</p>
  
  <p><a href="https://i.stack.imgur.com/wMXHm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wMXHm.png" alt="Image"></a>
  </p>
  
  <p>Is there a property from the pivotable I am just not seeing?
  currently I have these set on my pivottable...</p>
  
  <pre><code>            pivotTable.DataOnRows = false;
              pivotTable.ColumGrandTotals = false;
              pivotTable.Compact = false;
              pivotTable.CompactData = false;
              pivotTable.MultipleFieldFilters = true;
  </code></pre>
  
  <p>Thanks for the help.</p>