Forum Discussion
Øyvind Granberg
Aug 23, 2020Copper Contributor
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. ...
Øyvind Granberg
Aug 23, 2020Copper Contributor
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.
HansVogelaar
Aug 23, 2020MVP
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?
- Øyvind GranbergAug 23, 2020Copper Contributor
Yes ... It works okay this way, but I hoped to avoid this detour.