Forum Discussion
adishet34
May 14, 2021Copper Contributor
Power Query not loading functions
Hi, I'm using MS Office Home & student 2019. I want to transform the data from my current workbook. I open the Power Query editor as a Blank query and while typing the function "Excel.CurrentWork...
- May 15, 2021
"That feature is available on 365 only, sorry."
SergeiBaklan
May 15, 2021MVP
"That feature is available on 365 only, sorry."
adishet34
May 15, 2021Copper Contributor
I guess it's an Excel version issue after checking with two other systems with Office 365.
It is just mind-boggling that, I have a power query but to get just formulas automatically loaded while typing, I have to change the Excel version.
Thank you for providing a quick input on my query.
- SergeiBaklanMay 15, 2021MVP
Yes, all latest functionality is on 365, better to use it. You are welcome.