Hi all,
I’m having an issue where I insert the following link as external data:
https://www.x-rates.com/table/?from=USD&amount=1
This is just a live foreign exchange rate table. I go through the steps and select HTML_1.
It loads something like this: Screenshot - 7b2a4042616c622be0cd2ca350f14c51 - Gyazo
This is great, it updates the info every 60 seconds and all that.
I close the Calc file and re-open it. It has the (Automatic update of external links has been disabled - Enable Content) at the top. As soon as I enable it, it seems like the previous table isn’t overwritten (old data erased and new rates showing) but rather pushed down and the list is now the same 10 currencies twice:
I’m not sure how to fix this. I need the data to overwrite itself every time. This is messing up formulas that I have on a different sheet.
Thanks in advance.