Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

share|improve this answer

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.