In last week’s video I showed how to create an Excel based currency converter using Data Types. But that method is not without its problems.

Not all versions of Excel include Data Types. Even if you do have access to them, the auto-refresh settings are only available to users subscribed to the Microsoft 365 Beta Channel and talking of auto-refresh settings, that functionality is very limited.

Using Power Query, which is not only more robust, more mature and available in most versions of Excel since 2013, we can achieve the same result with more flexibility, especially when it comes to refresh settings.

This video covers how to use Power Query to import web-based exchange rate data into Excel and automatically keep the data up-to-date