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
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
all Excel file freezes when I try to save
dericksd18 in Excel on
0 Replies
Excel web query DataFormat.Error "not a valid path"
Simon Pearce in Excel on
7 Replies
Intelligent Search for Fact Repository - Help please!
camthe1man in Excel on
1 Replies
Excel doc very slow
Lucas Fernandes de Jesus in Excel on
7 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies