Forum Discussion

Copper Contributor

Aug 28, 2019

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...

Copper Contributor

Mar 18, 2020

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

ire123

Copper Contributor

Mar 27, 2020

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.

Mark Woollgar
Copper Contributor
Mar 27, 2020
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).
- Jason_Sibley
  Copper Contributor
  Jan 11, 2021
  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