I am using Excel 2016 and I go to the data ribbon and select the "Get & Transform" section and select any new query available. Nothing happens. Nothing at all. Suggestions? Believe it or not the Excel 2016 online help refers to the "Power Query" ribbon which the training video says was replaced by the "Get & Transform". So apparently Microsoft doesn't even know how to use its own software. HELP!
Hi Mike,
That sounds strange...the Power Query not working, not the Microsoft help being incorrect!
So, to be clear, if you select New Query > From Other Sources > Blank Query then the query editor doesn't open?
Mynda
Hi Mike,
Most probably, you have to clean up the office installation and perform a clean reinstall.
See this article for instructions and tools : https://support.office.com/