Home

Power Query freezes in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-826141%22%20slang%3D%22en-US%22%3EPower%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826141%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20issues%20editing%20queries%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20I%20enter%20a%20Power%20Query%20window%2C%20the%20window%20opens%20but%20shows%20no%20data%20and%20all%20excel%20sheets%20freezes.%20I%20can%20highlight%20the%20tools%20but%20they%20do%20not%20react%20when%20I%20try%20to%20click%20them.%20Nor%20can%20I%20close%20the%20Power%20Query%20window.%20The%20only%20way%20I%20manage%20to%20close%20excel%20is%20by%20forcing%20it%20through%20task%20manager%20in%20windows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20the%20problem%20started%20when%20I%20updated%20excel%20from%20verision%201902%20to%201907.%20I%20have%20reinstalled%20office%20and%20I%20am%20now%20running%20version%201908%2C%20but%20the%20problem%20is%20still%20present.%20I%20have%20tried%20to%20access%20power%20query%20in%20multiple%20workbooks%2C%20but%20with%20no%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20experienced%20a%20similar%20problem%3F%20Any%20suggestions%20on%20how%20to%20fix%20this%20would%20be%20very%20welcome.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFreeze%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ire123
Occasional Visitor

Hello,

 

I'm having issues editing queries in Excel.

 

Whenever I enter a Power Query window, the window opens but shows no data and all excel sheets freezes. I can highlight the tools but they do not react when I try to click them. Nor can I close the Power Query window. The only way I manage to close excel is by forcing it through task manager in windows.

 

I believe the problem started when I updated excel from verision 1902 to 1907. I have reinstalled office and I am now running version 1908, but the problem is still present. I have tried to access power query in multiple workbooks, but with no success.

 

Has anyone experienced a similar problem? Any suggestions on how to fix this would be very welcome.

 

Thank you for your time!

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies