power query -- get & transform

%3CLINGO-SUB%20id%3D%22lingo-sub-872958%22%20slang%3D%22en-US%22%3Epower%20query%20--%20get%20%26amp%3B%20transform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%26nbsp%3B%20I%20have%20office%20pro%20plus%202016.%20When%20trying%20to%20open%20a%20query%20I%20get%20no%20response.%20I%20go%20to%20Data%20tab%20%26gt%3Bget%20%26amp%3B%20transform%20%26gt%3B%20new%20query%20%26gt%3B%20from%20file%20%26gt%3B%20from%20workbook%2C%20and%20literally%20nothing%26nbsp%3Bhappens.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-872958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873282%22%20slang%3D%22en-US%22%3ERe%3A%20power%20query%20--%20get%20%26amp%3B%20transform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873282%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414372%22%20target%3D%22_blank%22%3E%40finance305%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20shall%20open%20pop-up%20window%20to%20select%20the%20file%2C%20approximately%20the%20same%20as%20for%20Save%20as%2C%20etc.%20Try%20to%20check%2C%20for%20example%2C%20on%20ribbon%20Insert-%26gt%3BPicture%20if%20you%20have%20same%20window.%20Does%20double%20click%20works%20from%20file%20explorer%20to%20open%20Excel%20file%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20all%20around%20works%20try%20to%20repair%20Office.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873284%22%20slang%3D%22en-US%22%3ERe%3A%20power%20query%20--%20get%20%26amp%3B%20transform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414372%22%20target%3D%22_blank%22%3E%40finance305%3C%2FA%3E%26nbsp%3B%2C%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FRE-Modern-Excel-webinars%2Fm-p%2F872570%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FRE-Modern-Excel-webinars%2Fm-p%2F872570%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

@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.