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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies