title: Refresh PivotTable EPPlus
body: <p>I am editing an existing spreadsheet in C# using EPPlus. I am altering the raw data on the second worksheet which is being used as the data source for a Pivot table on the first worksheet. My edits all work perfectly, the problem I am having is that when I load the spreadsheet output I have to manually update the Pivot table by clicking the <code>Refresh Data</code> button on the Excel toolbar. </p>
  
  <p>Is there anyway to do this with C# EPPlus?</p>
  
  <p>I've tried:</p>
  
  <pre><code>package.Workbook.FullCalcOnLoad = true;
  </code></pre>
  
  <p>and</p>
  
  <pre><code>package.Workbook.Calculate();
  </code></pre>
  
  <p>without success.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I couldn't find a mechanism for doing this in EPPlus so would still like to know if there is an answer. However, because I am editing a pre-existing Excel file, I was able to edit the properties of the existing pivot table in Excel and change the setting to automatically update on first load. </p>