Keep the old data if query fails

[Legacy 143009]

Hi,

I have a web data query about exchange rates. But somehow, it can't refresh the data sometimes properly. (I think it is because of the page's bad design. Query can't find the target table every time.)

I have set "Refresh on workbook open" only. What I need is to keep the previous rates if it returns an error on update. Is there any setting for this?

Thanks a lot!

 

[Legacy 143009]

Hi,

I have a web data query about exchange rates. But somehow, it can't refresh the data sometimes properly. (I think it is because of the page's bad design. Query can't find the target table every time.)

I have set "Refresh on workbook open" only. What I need is to keep the previous rates if it returns an error on update. Is there any setting for this?

Thanks a lot!

Ahh "Remove ex data when close.." I think this is what I am looking for. Noprob