title: Shared Strings in Excel 2010
body: <p>Can someone help me in understanding the Shared Strings in <em>MS Excel</em>? I tried to understand using some blogs but could not get complete idea. Everyone is explaining how to access Shared String using Open XML and where the Shared Strings stored (as <code>sharedStrings.xml</code>). Accessing using API is fine. But, </p>
  
  <ol>
  <li>How to create Shared Strings in <em>Excel</em>. (Creating manually in <em>Excel 2010</em>, not using API) </li>
  <li>What is the exact need of Shared Strings?</li>
  <li>In which cases i can go for Shared Strings?</li>
  </ol>
  
  <p>I tried following.</p>
  
  <p><a href="http://www.sadev.co.za/content/reading-and-writing-excel-2007-or-excel-2010-c-part-iii-shared-strings" rel="noreferrer">http://www.sadev.co.za/content/reading-and-writing-excel-2007-or-excel-2010-c-part-iii-shared-strings</a></p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/gg278314.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/gg278314.aspx</a></p>