Forum Discussion

Graham Co's avatar
Graham Co
Copper Contributor
Jun 11, 2019

Power Query Editor window slow to open.

As of today, the Power Query Editor window, on MS Excel 2013, has been very slow to open, even on a blank workbook with no data, no queries written. Upwards of three minutes just to show an empty editor window. I have tried

  • Uninstall and install the latest version of PQ (2.62.5222.701 32-bit)
  • Repair MS Office
  • Stop MS Teams running as a new version installed
  • Checked Anti-virus - could not see anything that would impede performance

Running a refresh on a simple query that has previously taken less than 30 seconds, now takes upwards of 10 minutes. No errors are shown and the results are all OK.

 

Any suggestions on what to look for?

 

Cheers

 

Graham

BI & Data Analytics
excel 2013

1 Reply

  • Theo_Bear's avatar
    Theo_Bear
    Copper Contributor
    Jun 18, 2019

    Have you tried fast data loading option, Query option> data load. 

    if that does not help, please check your RAM size, even though an empty query shouldn't be affected by this. Using 64bit?

Resources