I love the “external data source” feature, and use it quite a bit to automatically reference data available from web-sites.
But the only way I know to change anything about such a link – the page’s URL, the table within the page, the refresh interval – is to wipe the sheet based on it, and recreate the link from scratch.
There is got to be a better way – what is it?