title: Edit External Data in Excel Table
body: <p>How can I develop an Excel plug-in to edit external data in an Excel data table?</p>
  
  <p>Excel can make connections to external data sources but as far as I am can see they are one-direction read-only data tables. What I am trying to do is something like TFS plug-in for excel. I am sure there are many more ones like that.</p>
  
  <p>For those who do not know that plug-in: 
  When installed, TFS Excel plug-in takes place as a new menu in Excel. Through that menu you can open a connection to a TFS server and bring your (work item) records into Excel as an Excel table. You can add new rows or edit the data in the table. Some cells has drop down lists attached to them but only valid options are shown in the list and that is different for each record. You can edit rows in the table and you can bulk push those records back to server.</p>
  
  <p>I don't know if it makes a difference but the connection and update operations on my datasource will be through web services.</p>
  
  <p>I guess this would require some serious development but I am lost between web pages about external data ranges (which are only for reading). Can someone please direct me to some further reading on the topic?</p>