Hi

I was just wondering if it is possible to save cumulative data from XML feeds into Excel.

I want to save the latest news of the xml feeds into Excel. I have a couple of questions I hope somebody might be able to answer:

1) When the feed is updated can I stop the oldest data from being pushed off the screen?

2) Will I have to refresh every few hours in order to capture all the data?

The website I want to capture the data from has around 100 updates over 24 hours and only the top 20 news items are in the XML/RSS feed at any one time, but I want to keep the data even if I don’t press “refresh”.

I managed to get the data in (Data>Get External Data>New Web Query), but is there a way of “saving” the data forever in a spreadsheet and only having to press refresh once of twice a day?

Thanks in advance.