title: ExcelCom writing formula into cell results in #name?
body: <p>In my project i have to fill formulas into cells of an ExcelSheet. To do that I use the <code>Microsoft.Office.Interop.Excel</code> Library.</p>
  
  <p>The code itself is very easy</p>
  
  <pre><code>mySheet.Cells[1, 1] = SomeString;
  mySheet.Cells[1, 2].Formula = "=SUMME($E$2:E" + SomeInteger + ")";
  </code></pre>
  
  <p>And that's it already. 
  (Since I live in germany, my excel version understands "Summe" as "SUM"</p>
  
  <p>Now when looking at the excel sheet, the result ist #name?.
  When clicking into the cell, and so forcing it to update, it calculates perfectly.</p>
  
  <blockquote>
    <p>I found a few posts related to this, but the link they provided with
    the solution does not exist anymore. (And are about 10 years old)</p>
  </blockquote>
  
  <p>I have tried the following steps:</p>
  
  <ul>
  <li><p>calling </p>
  
  <p>mySheet.Calculate()
  after setting the formula. (Did not work)</p></li>
  <li><p>Changing the function. Some other functions (simpler ones) work fine. But not mine...</p></li>
  </ul>
  
  <p>I would be glad to hear from you - more experienced - guys...</p>
  
  <p>Thank you!</p>
  
  <p>Details:
  Excel version: 2016
  Windows 10</p>
  
  <p>PS: This is my first question. So if you have some tipps concerning that, I would be glad too!</p>