Getting Error while opening excel file which is created by OpenXML SDK 2.5
<p>I have an excel file. I want to cut a row from one sheet to another. Using OpenXML 2.0 I achieved the aim. My excel consists ofa column which calculates the sum</p>

<p>Reference: <a href="https://stackoverflow.com/questions/11453636/inserting-new-rows-and-moving-exsisting-ones-with-openxml-sdk-2-0">Inserting new rows and moving exsisting ones with OpenXML SDK 2.0</a></p>

<p>Now the excel is coming out perfectly. Even i have validated excel using productivity tool and there is no error. But when i will open the excel from folder it is giving 2 errors.</p>

<p>1.Error: .... If you trust the source of this workbook, click Yes. This message box is appearing all the time.</p>

<ol start="2">
<li>Removed Records: Shared formula from /xl/worksheets/sheet3.xml part   </li>
</ol>

<p>On evaluating the xml of sheet3, I found a row like</p>

<p></p>

<pre><code>     &lt;x:c r="A79" s="55" t="s"&gt;
        &lt;x:v&gt;57&lt;/x:v&gt;
     &lt;/x:c&gt;
     &lt;x:c r="B79" s="55"/&gt;
     &lt;x:c r="C79" s="56"/&gt;
     &lt;x:c r="D79" s="56"/&gt;
     &lt;x:c r="E79" s="102"&gt;
        &lt;x:f t="shared" ref="E78" si="0"&gt;SUM(E76)&lt;/x:f&gt;
        &lt;x:v&gt;0&lt;/x:v&gt;
     &lt;/x:c&gt;
  &lt;/x:row&gt;
</code></pre>

<p>After removing " t="shared" ref="E78" si="0" " from the xml the excel is not giving errors anymore.</p>

<p>How can i avoid this error using openxml???? </p>