power query -- get & transform

Copper Contributor

Hi,  I have office pro plus 2016. When trying to open a query I get no response. I go to Data tab >get & transform > new query > from file > from workbook, and literally nothing happens. 

2 Replies

@finance305 

It shall open pop-up window to select the file, approximately the same as for Save as, etc. Try to check, for example, on ribbon Insert->Picture if you have same window. Does double click works from file explorer to open Excel file?

 

If all around works try to repair Office.