Home

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

Related Conversations
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
Query Design
Siriah in Access on
1 Replies
Power Query freezes in Excel
ire123 in Excel on
0 Replies