title: Excel formulas are not being generated by Reporting Services
body: <p>I'm working on a report for my employer where the end product is a SSRS report, but one that will almost ALWAYS be exported to Excel for further manipulation.  In this report, there is a row that is really just a row of calculations based on other cell values.  </p>
  
  <p>I've read that Reporting Services can "figure out" Excel formulas, and will generate and insert them where it can so long as your expressions for the cell's value do not contain database field references, only report item references.</p>
  
  <p>Well, I've done this and I'm still not able to get the formulas to come through.  I've tried rendering the report every way I could think of, and I've tried modifying the DeviceInfo parameters to include the <code>OmitFormulas</code> option set to <code>False</code>, and still I've come up empty.  I've even tried creating a VERY simply table based report with hard-coded values, and even then I don't get formulas.</p>
  
  <p>Here's a sample expression from my report:</p>
  
  <pre><code>=(ReportItems!Balance2.Value + ReportItems!Supply3.Value) - ReportItems!Demand3.Value
  </code></pre>
  
  <p>My environment is VS 2008 (fully patched/updated) running on SSRS 2008 (not fully patched).  I've talked to the server admin, and he says it's running CU1 (I think, can't remember for sure).  Our company's Excel is version 2007.</p>
  
  <p>I'm really at my wits end here, so I'm hoping someone out there has dealt with this before and can give me an answer. Thanks!</p>