Excel Built-In Exchange Rate

[smitpau]

Hi,

I recently watched the MrExcel YouTube Video about the built-in exchange rate function in Excel (link below).

It's very useful but currently has a drawback that to refresh the rates the only way possible seems to be Refresh All which really slows Excel down, is there a way to just refresh the selected cells as I imagine that should be quicker. Even if it was just to refresh on opening the Spreadsheet that would be good enough but you can't access the Queries and Connection settings like normal to do that so it actually currently seems more limiting than a normal data source, as I'm tempted to just get the FX Rate from somewhere like floatrates.com

Thanks for reading!

 

[smitpau]

Any ideas out there as to change how it refreshes, as if not I'll just revert back to a normal web page data source.