Forum Discussion
Solved
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...
"That feature is available on 365 only, sorry."
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
"That feature is available on 365 only, sorry."
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.
Yes, all latest functionality is on 365, better to use it. You are welcome.