title: Copy & Paste Values into Excel Defined Table Really Slow
body: <p>I have an Excel defined table of ~20K rows and ~20 columns.</p>
  
  <p>Every month I need to refresh the data set.  But when I copy paste values in, my Excel crashes.</p>
  
  <p>However, if I convert the table to a named range, the copy paste takes &lt;10 seconds.  </p>
  
  <p>Has anyone else had this issue?  Does Excel need to create/update some sort of index with every value you put into a table?  That could help explain why it takes so long when copy &amp; pasting data.</p>