Power Query Editor window slow to open.

[Graham Co]

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

[#2]

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?