I created a web query (Get Data From Web) and it brought in my table. The web table will update every 10 minutes or so with new data, and any data older than 1 hour is removed from the web table view. Every time I click refresh, Excel will bring in the current table, overwriting any old data already imported. Is there a way to keep the data already imported and import new data?
@Tony671 You would need PQ to reference its own previous output and then merge it with the current "content" of the web-site it connects to. This has come up several times in the past, though in a different context. Attaching a file that creates a historic price list. Same principle there. If you can't apply the steps, please share a link to the web-site you are working with.