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%3CLINGO-SUB%20id%3D%22lingo-sub-1235503%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1235503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399468%22%20target%3D%22_blank%22%3E%40ire123%3C%2FA%3E%26nbsp%3Bhas%20this%20been%20resolved%20for%20you%3F%20I've%20been%20experiencing%20this%20for%20a%20while%20and%20just%20now%20trying%20to%20look%20into%20it...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250815%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579727%22%20target%3D%22_blank%22%3E%40paulread820%3C%2FA%3EI%20have%20the%20same%20issue%20and%20has%20been%20a%20problem%20for%20a%20few%20weeks.%26nbsp%3B%20I%20am%20frozen%20right%20now%20when%20trying%20to%20split%20a%20column%20by%20delimeter.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1259163%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579727%22%20target%3D%22_blank%22%3E%40paulread820%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnded%20up%20asking%20IT%20to%20reset%20my%20outlook%20version%20back%20to%26nbsp%3B%3CSPAN%3E1902.%20It%20has%20worked%20since%2C%20although%20I%20am%20today%20back%20on%20version%201908%20today.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1259173%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399468%22%20target%3D%22_blank%22%3E%40ire123%3C%2FA%3EI%20think%20I%20have%20found%20a%20solution.%26nbsp%3B%20My%20Power%20Query%20Cache%20had%20exceeded%20the%20maximum%20allowed%20(I%20was%20at%206k%20vs%20the%204k%20max).%26nbsp%3B%20Not%20sure%20how%20that%20can%20happen.%26nbsp%3B%20I%20have%20cleared%20the%20cache%20and%20so%20far%20the%20issue%20has%20not%20recurred%20(I%20have%20not%20though%20been%20using%20Power%20Query%20much%20since%20then).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2050172%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20freezes%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2050172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F230760%22%20target%3D%22_blank%22%3E%40Mark%20Woollgar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20This%20helped%20me%20after%20spending%2090%20minutes%20and%20multiple%20reboots.%3C%2FP%3E%3CP%3EI%20cleared%20the%20PQ%20cache.%20That%20did%20not%20work.%20So%20then%20I%20lowered%20my%20cache%20ceiling%20from%209000%20to%204000.%3C%2FP%3E%3CP%3EThat%20worked.%3C%2FP%3E%3CP%3EStrangely%26nbsp%3B%20went%20back%20and%20put%20my%20ceiling%20back%20at%209000%20and%20PQ%20continued%20playing%20nicely.%3C%2FP%3E%3CP%3EAgain%2C%20THANK%20YOU!%3C%2FP%3E%3CP%3EJase%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

 

5 Replies

@ire123 has this been resolved for you? I've been experiencing this for a while and just now trying to look into it...

@paulread820I have the same issue and has been a problem for a few weeks.  I am frozen right now when trying to split a column by delimeter.

@paulread820 

 

Ended up asking IT to reset my outlook version back to 1902. It has worked since, although I am today back on version 1908 today.

@ire123I think I have found a solution.  My Power Query Cache had exceeded the maximum allowed (I was at 6k vs the 4k max).  Not sure how that can happen.  I have cleared the cache and so far the issue has not recurred (I have not though been using Power Query much since then).

@Mark Woollgar 

Thank you. This helped me after spending 90 minutes and multiple reboots.

I cleared the PQ cache. That did not work. So then I lowered my cache ceiling from 9000 to 4000.

That worked.

Strangely  went back and put my ceiling back at 9000 and PQ continued playing nicely.

Again, THANK YOU!

Jase