Home

Unable to open Get & Transform

%3CLINGO-SUB%20id%3D%22lingo-sub-1087994%22%20slang%3D%22en-US%22%3EUnable%20to%20open%20Get%20%26amp%3B%20Transform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1087994%22%20slang%3D%22en-US%22%3E%3CP%3EPotentially%20significant%3A%20I%20recently%20replaced%20Office%202016%20Enterprise%20with%20Office%20365%20and%20this%20is%20the%20first%20I%20have%20tried%20to%20use%20queries%20since%20then.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20unable%20to%20open%20query%20editor%20in%20a%20document%20that%20has%20existing%20queries%2C%20and%20I%20am%20unable%20to%20create%20connections%20in%20a%20document%20using%20Get%20%26amp%3B%20Transform.%20I%20wish%20I%20was%20getting%20an%20error%20message%2C%20but%20absolutely%20nothing%20happens.%20I%20go%20to%20click%20on%20something%2C%20and%20it%20highlights%20as%20normal.%20Then%20I%20click%20and%20nothing%20happens.%20It%20doesn't%20even%20try%20to%20open.%20I%20tried%20repair%20followed%20by%20a%20full%20uninstall%2Freinstall%20of%20Office%20and%20another%20repair...%20reboots%20in%20between%20all%20of%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20it%20happened%20on%20new%20documents%20as%20well%2C%20I%20had%20a%20coworker%20try%20the%20document%20I%20need%20to%20edit%26nbsp%3Band%20it%20was%20fine%20on%20his%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20try%20a%20new%20document%20with%20a%26nbsp%3Bnew%20connection%20to%20any%20of%20the%20data%20sources%2C%20example%20Odata%2C%20I%20don't%20get%20the%20next%20window%20where%20I%20should%20have%20the%20prompt%20to%20enter%20a%20path.%20It%20does%20not%20look%20like%20it%20even%20tries%20to%20open%20the%20window%2C%20no%20pinwheel%20or%20anything.%20I%20can%20tell%20it%20clicks%20because%20of%20the%20color%20change%2C%20but%20nothing%20happens%20after%20the%20click.%20I%20tried%20reinstalling%20the%20latest%20.net%20framework.%20No%20fix.%20I'm%20out%20of%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Pivot%20and%20other%20add-ins%20appear%20to%20be%20working%20fine.%20I%20can%20create%20a%20new%20connection%20in%20Power%20Pivot.%20Power%20Query%20works%20fine%20in%20Power%20BI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20else%20might%20be%20involved%20that%20would%20affect%20the%20ability%20to%20launch%20that%20control%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1087994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1088286%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Get%20%26amp%3B%20Transform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1088286%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20there%20is%20something%20that's%20more%20than%20meet%20the%20eyes%20for%20Get%20%26amp%3B%20Transform%20not%20to%20open%20on%20your%20system.%20Just%20a%20little%20advice%2C%20kindly%20disable%20some%20add-ins%20and%20retry%20again..%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Potentially significant: I recently replaced Office 2016 Enterprise with Office 365 and this is the first I have tried to use queries since then.

 

I am unable to open query editor in a document that has existing queries, and I am unable to create connections in a document using Get & Transform. I wish I was getting an error message, but absolutely nothing happens. I go to click on something, and it highlights as normal. Then I click and nothing happens. It doesn't even try to open. I tried repair followed by a full uninstall/reinstall of Office and another repair... reboots in between all of that.

 

Though it happened on new documents as well, I had a coworker try the document I need to edit and it was fine on his computer.

 

If I try a new document with a new connection to any of the data sources, example Odata, I don't get the next window where I should have the prompt to enter a path. It does not look like it even tries to open the window, no pinwheel or anything. I can tell it clicks because of the color change, but nothing happens after the click. I tried reinstalling the latest .net framework. No fix. I'm out of ideas.

 

Power Pivot and other add-ins appear to be working fine. I can create a new connection in Power Pivot. Power Query works fine in Power BI.

 

What else might be involved that would affect the ability to launch that control? 

1 Reply
Highlighted
Hello,

I think there is something that's more than meet the eyes for Get & Transform not to open on your system. Just a little advice, kindly disable some add-ins and retry again..

Regards