Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I made a web service that generates a data table that I periodically want to download into Excel. Because there is a huge amout of old data, I don't want to always generate everything - only data for dates which have not been downloaded yet.

If I last downloaded data into Excel two days ago, the next time I hit refresh, I want Excel to append the existing table, not replace the existing data with the new data. The web service is set up so that it will only generate data that has not previously been requested.

Is there a way to do this?

share|improve this question

I am using 2010 so it may be different, but the XML Map Properties may get you where you want to go -

enter image description here

share|improve this answer

Similar to Ben Jones. Look at the external Data Range properties. enter image description here

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .