Forum Discussion
Power Query freezes in Excel
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 d...
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).
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
