title: Excel table not expanding when new data is added
body: <p>I have an Excel spreadsheet which contains four data tables on the same tab. The final 3 columns in each contain formulae.</p>
  
  <p>I then have a vba code which performs an sql look up within an SQL Server table and returns a set number of columns to update each of the four tables.</p>
  
  <p>For three of these tables, the data is pasted in and the table automatically expands and the formulae is copied to the end of the table.</p>
  
  <p>However, for the first table, the data is pasted in but the table does not expand and hence, the formulae does not get added to the rows outside of the table.</p>
  
  <p>I have searched high and low for a fix but no joy. I have searched the data extraction VBA code with no luck (the code is an exact match) and no joy in the table properties. I have also checked the Options menu for Auto Format As You Type settings but all seems fine.</p>
  
  <p>Does anyone have any ideas for me?</p>
  
  <p>Thanks,</p>
  
  <p>David.</p>
  
  <p>Hi All again,</p>
  
  <p>Would love to know if anyone has an answer for this but, in the mean time I have fudged the code to automatically adjust the size of the table based on the row number for the last cell of data.</p>
  
  <p>Thanks,</p>
  
  <p>David.</p>