Forum Discussion
Get external data from web not showing
Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea ...
Hi
I don't know why there's suddenly activity on this very old thread, but much has changed since it originated. The current update is no longer 16.23. Now it's 16.63.1 so you can see there have many intervening updates.
I think the answer for version 16.23 and all versions including the current channel update version is to use the Menu Bar and choose Data > Get External Data > Run Web Query. For more information on how to build a web query, visit this page: Making and using Excel Web Queries (agentjim.com)
As on Jan 2024, it worked for me. I had been struggling to import currency exchange rate data in Excel 2019 Mac version. Just follow the steps outlined in the above link.