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."
adishet34
May 15, 2021Copper Contributor
I have attached the screenshot of my Excel version. If anybody can clarify if it is specific to the version or some options that must be enabled, would be a great help. I couldn't find much from other sources regarding this issue.
Thank you
SergeiBaklan
May 15, 2021Diamond Contributor
"That feature is available on 365 only, sorry."
- adishet34May 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, 2021Diamond Contributor
Yes, all latest functionality is on 365, better to use it. You are welcome.