title: Change Named range EPPlus
body: <p>I'm using EPPlus to populate an excel file, I have many pivot tables that refresh when the file is opened.</p>
  
  <p>Their source is always one of the two sheets populated by my application. </p>
  
  <p>The problem is that everytime I populate there is a different number of rows,
  I tried using a named range in their source but when I change the range of the named range with EPPlus , it doesnt work.</p>
  
  <pre><code>   epplusWs.Workbook.Names["named_range"].Address = "data_sheet!$A$1:$H$" + row.ToString();
  </code></pre>