title: Append new data to an External Data table in Excel
body: <p>If I have a table in Excel, populated via an external data connection, how can I refresh the data in such a way as to insert new rows for new data, but keep the old rows as well?</p>
  
  <p>For example, this is my table:
  <img src="https://i.stack.imgur.com/PrTmv.png" alt="enter image description here"> 
  <br /><br />
  Unfortunately the database that I'm working with <strong>only holds onto the current month's data</strong>, so if I refresh, I'll only get February 2011's data back.  The end result I want is:<br/>
  <img src="https://i.stack.imgur.com/Ryz1c.png" alt="enter image description here">  <br/>Are there any built-in Excel options that I'm missing (similar to "External Data Properties"->"Insert entire rows for new data, clear unused cells") or should I go the programmatic route and save the old data in a temp table, etc?</p>