Forum Discussion
Importing old xls files into Excel 365
Hi ... I am trying to set a query of this file, https://www.nordpoolgroup.com/globalassets/marketdata-excel-files/elspot-prices_2020_hourly_nok.xls into Excel 365, but it seems to be a problem. ...
Thanks for an quick answer.
But, I can't set this file up as a query in Excel 365.
I'll get get an message that it can't be done.
Have you tried opening the .xls file in Excel, saving it as .xlsx and then using the .xlsx file in your query, instead of the .xls file that doesn't work?
Yes ... It works okay this way, but I hoped to avoid this detour.