title: Excel workbook size quite large
body: <p>I have a workbook that is quite large (approx. 30 MB). I realize this is fairly small compared to some but the math just doesn't seem to add up.</p>
  
  <ul>
  <li><p>There are 19 sheets total and I have about 15-20 named ranges.</p></li>
  <li><p>All but four of these sheets have a small used range (under 100 rows and 25 columns)</p></li>
  <li><p>Two of the four are tables (minimal formatting) approx. 35,000 rows by 40 columns comprising of data paste-valued from separate files totaling approx. 20 MB.</p></li>
  <li><p>The other sheets are not tables and not formatted and approx. 9,000 rows 100 columns and 11,000 rows by 5 columns.</p></li>
  </ul>
  
  <p>So my question is this: Where is the additional 10 MB coming from?</p>
  
  <p>Edit:</p>
  
  <p>Please note that I have already cut my used range down on each sheet to the bare minimum. Also, the workbook is copied from our company template with significant VBA but that file is less than 1 MB.</p>