title: Working with huge Excel content - presetting dependency chain
body: <p>Am trying to build a large excel solution. The Excel file (200MB xlsb) has a sheet with 300,000 rows X 100 columns, containing formulae with long chain of dependencies. </p>
  
  <p>Have incorporated most Excel performance tips. No a single volatile function. No array formulae. Eliminated forward references (cell formulae always refer only to previous rows and/or cells on the left in same row and/or sheets prior in alphabetic order, no external links). 
  Am using 64-bit Excel 2013 on 2.2GHz 4GB system, have disabled AutoSave (huge file), disabled multi-threading (single dependency chain). For those wondering, used optimized VBA code to create 30 million formulae of excel code. </p>
  
  <p>The file takes some minutes to open. Smart recalc (F9) works great &lt;1s on small changes. Full Calculation using (Ctrl+Alt+F9) takes 30s. Full Calculation Rebuild using (Shft+Ctrl+Alt+F9) takes 3mins to build dependency &amp; calculation sequence (noticed as cursor busy), and 30s for Calculation (status bar shows Calculating). File close with/without Save takes longer than File Open. Deleting all these formulae takes forever (cancelled after >1hr). AutoFilter is extremely slow (file unresponsive). Many other operations have become slow. </p>
  
  <ol>
  <li>Can we tell Excel to not bother identifying dependency tree and work left-to-right top-to-bottom alphabetic worksheets. </li>
  <li>Given Calc speed is already optimized, Are there additional ways to improve Response Rates for excel operations like Autofilter, insert/delete row/col, etc.</li>
  </ol>
  
  <p><em>To replicate: Range("B2:CW300001").formula="=A2+len(F1)"</em></p>
  
  <p>Any guidance will be greatly helpful. </p>