Refreshing XML overwrites existing data

[mariam15]

Hi,

I have created an XML map to pull RSS feeds onto my spreadsheet. However, when I refresh the table, it overwrites the existing data. I don't want the older feeds to be overwritten. I would like to keep a track of all the feeds coming in over time. How do I avoid overwriting? I'm using Excel 2016.

Thanks!

 

[tonyyy]

mariam15,

On the Developer tab, in the XML group, click on Map Properties. Near the bottom of the dialogue box is an option to "Append new data..."

Cheers,

tonyyy

 

[mariam15]

Thanks tonyyy!!

 

[tonyyy]

You're very welcome, mariam15...