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

@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
Excel web query DataFormat.Error "not a valid path"
Simon Pearce in Excel on
7 Replies
Power Query freezes in Excel
ire123 in Excel on
0 Replies
Power Query Merge Causing Dropped Rows
IlyaVee in Excel on
1 Replies